11
gediminasbyt
Re: Help! Login trouble on 2.2.1

OK. I did get my site back after editing database directly for php debug. I was not able to get recovery.php page, just blank one.

What I noticed though was, somehow I had gzip turned on!? Don't know how, don't ask me. But here it is to what I did to get php debug on in PHPMyAdmin.

Possibly you can use this sql line, but be warned, make database backup before you touch your databases:
Change XOOPS to your database extension you named when installed (something what is in front of every table in format somename_config).
Quote:

UPDATE `xoops_config` SET `conf_value` = 'a:1:{i:1;s:1:"0";}' WHERE `conf_id` =19 LIMIT 1 ;


Or you can manually (safer) achieve:
In phpmyadmin go to your XOOPS database click Structure.
Find xoops_config and click on little icon Browse
Row 19 should be debug_mode it will say something like a:1:{i:0;s:1:"0";} if i=0 then debug is OFF, you need to turn it on.
Click Edit icon and in conf_value change 0 to 1 and Click GO.

Voila! Site is back and PHP is ON. Disable gzip and you can safely turn off PHP. (Hopefully )


The other way could be turn off gzip:
Quote:

UPDATE `xoops_config` SET `conf_value` = '0' WHERE `conf_id` =14 LIMIT 1 ;


or in xoops_config click Browse, in row 14 if it's 1, click Edit and in next screen under conf_value change to 0 then click GO.

I'll keep an eye on this thread. Hope it works.

12
koenvd
Re: Help! Login trouble on 2.2.1
  • 2005/8/28 14:40

  • koenvd

  • Just popping in

  • Posts: 31

  • Since: 2004/1/15


Quote:

SimonTheMime wrote:
If you're still here, can I ask how you fixed your x_session? I am having the same login problem, checked x_session, it's broken, don't know how to fix it..

edit: fixed.


i have exactly the same problem.
how do you now wich table is broken ?
and how you fix it ?

2 users report it's fixed, but there's no solution reported in this topic.

thanks.

13
john_la
Re: Help! Login trouble on 2.2.1
  • 2005/8/28 19:59

  • john_la

  • Just popping in

  • Posts: 11

  • Since: 2005/8/24


One more with the same problem...

After upload of my site i cant login... It's v2.2.2
I have try with gzip... not working..
and other things... Please tell / help us, it's not one person who have this problem...

thanks!

14
john_la
Re: Help! Login trouble on 2.2.1
  • 2005/8/28 21:52

  • john_la

  • Just popping in

  • Posts: 11

  • Since: 2005/8/24


I have fixed!!

I have download XOOPS 2.2.0 to 2.2.3 Patch
upload all files where they should be.. And after that i get error... and i have back my old files but not all just:

In class folder:

- module.textsanitizer.php
- theme.php

In class > database

- mysqldatabase.php

In class > xoopsform

- formselectuser.php

I have now, don't now what version of xoops... But i will leave to XOOPS stuff team to find out what file is bad thing here and other things...

15
koenvd
Re: Help! Login trouble on 2.2.1
  • 2005/8/29 20:18

  • koenvd

  • Just popping in

  • Posts: 31

  • Since: 2004/1/15


john_la, your problem with 2.2.3 is a known bug (see the news section).
our problem with XOOPS 2.2.2 / 2.2.1 NOT ....

so could anybody please explain how you check which table is broken ? and how you fix that table again.

here's my post with my problem....
https://xoops.org/modules/newbb/viewtopic.php?topic_id=40027&viewmode=flat&order=ASC&start=0

16
john_la
Re: Help! Login trouble on 2.2.1
  • 2005/8/31 15:43

  • john_la

  • Just popping in

  • Posts: 11

  • Since: 2005/8/24


I have also XOOPS version 2.2 ! If you read my instr. maybe it will help you...

17
koenvd
Re: Help! Login trouble on 2.2.1
  • 2005/8/31 20:26

  • koenvd

  • Just popping in

  • Posts: 31

  • Since: 2004/1/15


PEOPLE please
i'm getting desperate. still can't acces my site.
i can login, but i can't acces the admin menu. even through /admin.php i get the message that i'm not allowed there.

i'm giving up.............. :( :(

any ideas, tips, hints, whatever ?
help. help. help.

18
rowdie
Re: Help! Login trouble on 2.2.1
  • 2005/8/31 21:23

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


I think the comments about fixing the session table means they've optimised it by clicking the 'optimise table' link in phpMyAdmin.

When you go to the 'stucture' tab of the session table, there's a block titled: 'space usage'. Mine has 'overhead x number of Bytes' in red. Click the optimize table link underneath and that will clean it up. If you don't see any red text or the optimize link then it doesn't need it.

Don't know if it will help you with your problem though.

19
koenvd
Re: Help! Login trouble on 2.2.1
  • 2005/9/1 17:14

  • koenvd

  • Just popping in

  • Posts: 31

  • Since: 2004/1/15


thanks for the tip
i'm making progress
problem i have is the same as posted here... !!

https://xoops.org/modules/newbb/viewtopic.php?topic_id=39769&forum=27

#1016 - Can't open file: 'xoops_session.MYI'. (errno: 145)

phpmyadmin doesn't allow me to repair that table though ?
can i just delete it ?!:)


*************************

EDIT !!!
FIXED !!!
solution:
https://xoops.org/modules/newbb/viewtopic.php?topic_id=23582&forum=1&post_id=117051#forumpost117051

run this sql query !
REPAIR TABLE xoops_session

MANY THANKS PEOPLE

20
toddherrold
Re: Help! Login trouble on 2.2.1

thanks for finding and posting the solution to the " no valid session token" issue. This was only a sporadic problem for a limited number of users and was killing me. I used both the "optimize table" solution as well as the "REPAIR TABLE xoops_session" SQL command.

Hoping this works.

Login

Who's Online

238 user(s) are online (160 user(s) are browsing Support Forums)


Members: 0


Guests: 238


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits