1
fbs777
Session doesnt working anymore (no more logins!)
  • 2006/4/2 18:18

  • fbs777

  • Just popping in

  • Posts: 48

  • Since: 2005/1/9 4


No one can login in my site anymore.
If someone login, appears "welcome someone..." but then come back to the site without to be logged...

This is with all, registered and admin.

I searched here in forum and i found many guys with this problem, but each one was a different reason and different solutions. I tried each one and dont work...

What i tried and dont work:

- go to www.../admin.php
- try again many times
- delete the files in templates_c and check the permissions
- repair all the tables with phpmyadmin and than optimize them all
- clear the tables xoops_online and xoops_session
- remove the xoops_session and created again with the query:
Quote:
CREATE TABLE xoops_session (
sess_id varchar(32) NOT NULL default '',
sess_updated int(10) unsigned NOT NULL default '0',
sess_ip varchar(15) NOT NULL default '',
sess_data text NOT NULL,
PRIMARY KEY (sess_id),
KEY updated (sess_updated)
) TYPE=MyISAM;

- In each one of the experiments, i deleted the cookies and cache of the navigators, and the content of the templates_c in server

The site was working well for more than a year

Configuring to show the debug, dont show any error in php, just notices... Configuring to show debug of MySQL dont show any error...

I have another site in same server (hosted) just for test (testing XOOPS 2.2.4) and is working without problem.

In phpmyadmin, before and after repair/optimize the tables dont show any error in tables.

Just if i select all tables and choose check them shows many alerts, but even in the XOOPS 2.2.4 tables and another old tables of an old site the error appears, so i think this errors are normal:
Quote:
Problems with indexes of table `xoops_banner`
Warning PRIMARY and INDEX keys should not both be set for column `bid`
Problems with indexes of table `xoops_bb_posts`
Warning More than one INDEX key was created for column `topic_id`
Problems with indexes of table `xoops_bb_topics`
Warning PRIMARY and INDEX keys should not both be set for column `topic_id`
Problems with indexes of table `xoops_config`
Warning More than one INDEX key was created for column `conf_title`
Problems with indexes of table `xoops_newblocks`
Warning More than one INDEX key was created for column `mid`
Problems with indexes of table `xoops_priv_msgs`
Warning PRIMARY and INDEX keys should not both be set for column `msg_id`
Warning More than one INDEX key was created for column `to_userid`
Problems with indexes of table `xoops_ranks`
Warning More than one INDEX key was created for column `rank_min`
Problems with indexes of table `xoops_users`
Warning PRIMARY and INDEX keys should not both be set for column `uid`
Warning More than one INDEX key was created for column `uname`
Problems with indexes of table `xoops_wfs_category`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `xoops_wfschannel`
Warning PRIMARY and INDEX keys should not both be set for column `CID`



I was making many updates and was close to release the version 2.0 of the site when this error happened... I was waiting finish all the details to make a backup after the release, so i dont have a backup...

Now i close the site for visitors (and myself, because when i put the admin login, after the "welcome admin..." he return to the maintenance page) and now i'm waiting a solution to this...

Especifications:
remote server (access just with cpanel)
xoops 2.0.13.2
apache 1.3.34
MySQL 5.0.19-log
PHP 5.1.2

2
rabideau
Re: Session doesnt working anymore (no more logins!)
  • 2006/4/2 22:57

  • rabideau

  • Home away from home

  • Posts: 1042

  • Since: 2003/4/25


Try going to your cache directory and deleting adminmenu.php

I am not certain that's the problem, but it won't hurt to try. I am inclined to believe that you have encountered a php v 5 issue although I have no idea what actually happened. Sorry. I wish I could offer more assistance.

Have you tried downloading and building the site on a php v4 machine? It might be worth a try.
Pax vobiscum,
...mark

may the road rise to meet your feet!

http://treemagic.org

3
fbs777
Re: Session doesnt working anymore (no more logins!)
  • 2006/4/3 0:12

  • fbs777

  • Just popping in

  • Posts: 48

  • Since: 2005/1/9 4


When i closed the site, i modified the text description but in the site the text still in the original form.

I was navigating in ftp and i remember about /cache contents. I deleted all the files in cache and the text description in maintenance page changed, but i still cant login...

Maybe can be something about some bad session config in admin preferences, or some session conflict...

Im receiving the cookies. When i enter in the site i receive a cookie (session_xoops). This cookie expire about 1/2 hour after received, maybe because i changed in phpmyadmin the standard number time from 15 to 1500 (session_expire in table xoops_config).
The other cookie (PHPSSESID) i receive when i try to login. Both have the same id session.
But in table xoops_config have an usercookie (cat_id 10) named sitename_user, but i dont receive this cookie.

About php version, like i said, the site was working for more than a year, and i cant change the php version, im hosting the site in an external (not dedicated) server...

Im loosing my mind, the site is closed and i dont know what to do anymore!...

Im accepting any hint!!!

4
fbs777
Re: Session doesnt working anymore (no more logins!)
  • 2006/4/3 1:37

  • fbs777

  • Just popping in

  • Posts: 48

  • Since: 2005/1/9 4


I was thinking: what about to creat a query to alter the table xoops_config (but just the session options), to go back to the normal configuration? Because i think this is maybe the only cause of this error...

The problem is: i dont know how to alter tables, i just know how to execute the query...

5
tripmon
Re: Session doesnt working anymore (no more logins!)
  • 2006/4/3 6:55

  • tripmon

  • Module Developer

  • Posts: 462

  • Since: 2004/2/28


Altering the session table won't really do any good, might as well re-create it after checking a few things.

Have you checked with your host (if hosted) to see if anything changed? Are you using a redirect from another root? If no, try below.

Try this ==>in order...

Make sure that your mainfile.php has not changed and the entries are correct... Exactly correct.

1)Clean templates_c except for index

2)-turn off custom sessions via dB using phpmyadmin-
in the config table:
Find the entry below:
[conf_name] use_mysession
[conf_title]_MD_AM_USEMYSESS
click the pencil looking thing to the left of the row.
Set conf_value to [0] (that's a zero) then empty & drop the session table

3)-re-create session table
MAKE SURE you change XXX to your dB prefix in the line below, then run this in the phpmyadmin SQL panel.

CREATE TABLE XXX_session (
sess_id varchar(32) NOT NULL default '',
sess_updated int(10) unsigned NOT NULL default '0',
sess_ip varchar(15) NOT NULL default '',
sess_data text NOT NULL,
PRIMARY KEY (sess_id),
KEY updated (sess_updated)
) TYPE=MyISAM;

Unless you have edited some other things in the dB, if that doesn't do it, it's got to be a php/mysql version or config. change issue.

6
fbs777
Re: Session doesnt working anymore (no more logins!)
  • 2006/4/4 6:09

  • fbs777

  • Just popping in

  • Posts: 48

  • Since: 2005/1/9 4


Thanks, i tested what you said, but dont work here:
Quote:

tripmon wrote:
Have you checked with your host (if hosted) to see if anything changed?
I checked with them today and they dont changed anything.
Quote:
Are you using a redirect from another root?

Are you talking about redirect url? Yes, the url ishttp://mysite.cjb.net, but this is the same url in more than a year...

Quote:
Make sure that your mainfile.php has not changed and the entries are correct... Exactly correct.

All the names are corrected (url, db name, table name, etc)

Quote:
1)Clean templates_c except for index

Ok, done. But about the index.php, is like i said before:
Quote:

- In each one of the experiments, i deleted the cookies and cache of the navigators, and the content of the templates_c in server


Quote:
2)-turn off custom sessions via dB using phpmyadmin-
in the config table:
Find the entry below:
[conf_name] use_mysession
[conf_title]_MD_AM_USEMYSESS
click the pencil looking thing to the left of the row.
Set conf_value to [0] (that's a zero) then empty & drop the session table
Ok, done.
Quote:
3)-re-create session table
MAKE SURE you change XXX to your dB prefix in the line below, then run this in the phpmyadmin SQL panel.

CREATE TABLE XXX_session (
sess_id varchar(32) NOT NULL default '',
sess_updated int(10) unsigned NOT NULL default '0',
sess_ip varchar(15) NOT NULL default '',
sess_data text NOT NULL,
PRIMARY KEY (sess_id),
KEY updated (sess_updated)
) TYPE=MyISAM;
Ok, done.
Quote:

Unless you have edited some other things in the dB, if that doesn't do it, it's got to be a php/mysql version or config. change issue.
Before the problem i dont edited nothing in the phpmyadmin, but i dont remember what (and if) i modified something in the XOOPS admin area...

I heard something about the header.php files cant have a blank line in the end (after line ?>). Is that right? Because in the end of some header.php files there is a blank line in the end...

Login

Who's Online

251 user(s) are online (159 user(s) are browsing Support Forums)


Members: 0


Guests: 251


more...

Donat-O-Meter

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

Latest GitHub Commits