Login issues with 2.0.1

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

jason559
Posts: 16
Joined: Wed Jun 27, 2007 8:03 am

Login issues with 2.0.1

Post by jason559 »

It has been covered here a few times, but I don't see any error messages in the debug data like some previous users have seen.

I get redirected back to the login screen whenever I choose any item in the admin area. Also, the box in the top left of the admin never changes from " Time to your session expiration: Loading..." I'm using MySQL database.


At the login screen my debug shows:

DEBUG INFORMATION:
COOKIES:

TABLES & RECORDS:
faqadminlog: 194
faqcaptcha: 19
faqcategories: 8
faqcategory_group: 8
faqcategory_user: 8
faqcategoryrelations: 45
faqchanges: 37
faqcomments: 0
faqconfig: 33
faqdata: 45
faqdata_group: 45
faqdata_revisions: 13
faqdata_tags: 0
faqdata_user: 45
faqglossary: 0
faqgroup: 0
faqgroup_right: 0
faqlinkverifyrules: 0
faqnews: 1
faqquestions: 1
faqright: 29
faqsessions: 32870
faqtags: 0
faquser: 2
faquser_group: 0
faquser_right: 29
faquserdata: 2
faquserlogin: 2
faqvisits: 45
faqvoting: 23

At the admin screen my debug is:


phpMyFAQ Version
phpMyFAQ 2.0.1
Server Software
Apache/1.3.35 (Unix) PHP/4.4.2
PHP Version
PHP 4.4.2
Register Globals
on
Safe Mode
off
Open Basedir
off
Database Server
Mysql
Database Client Version
3.23.49
Database Server Version
4.0.24-standard
Webserver Interface
APACHE
PHP Extensions
xml, tokenizer, standard, session, posix, overload, mysql, gd, ctype, zlib, pcre, apache


DEBUG INFORMATION:
pmf_currentuser->getuserbylogin() in line 146:

SELECT
user_id,
login,
account_status
FROM
faquser
WHERE
login = 'xxxx(I took this out)'



pmf_userdata->load() in line 373:

SELECT
last_modified, display_name, email
FROM
faquserdata
WHERE
user_id = 1


pmf_currentuser->updatesessionid() in line 150:

UPDATE
faquser
SET
session_id = '9a935ae4a57cab246755314444785f7a',
session_timestamp = 1182927980,
last_login = '20070627030620',
ip = '(xxxxxxx I took this out)'
WHERE
user_id = 1


pmf_currentuser->login() in line 89:

UPDATE
faquser
SET
auth_source = 'local'
WHERE
user_id = 1


pmf_permbasic->getallrightsdata() in line 122:

SELECT
right_id,
name,
description,
for_users,
for_groups
FROM
faqright
ORDER BY
right_id ASC


pmf_permbasic->getuserrights() in line 309:

SELECT
faqright.right_id AS right_id
FROM
faqright,
faquser_right,
faquser
WHERE
faqright.right_id = faquser_right.right_id AND
faquser.user_id = 1 AND
faquser.user_id = faquser_right.user_id



db_mysql->gettablestatus() in line 269:

SHOW TABLE STATUS


COOKIES:
pmf_lang: en

TABLES & RECORDS:
faqadminlog: 194
faqcaptcha: 19
faqcategories: 8
faqcategory_group: 8
faqcategory_user: 8
faqcategoryrelations: 45
faqchanges: 37
faqcomments: 0
faqconfig: 33
faqdata: 45
faqdata_group: 45
faqdata_revisions: 13
faqdata_tags: 0
faqdata_user: 45
faqglossary: 0
faqgroup: 0
faqgroup_right: 0
faqlinkverifyrules: 0
faqnews: 1
faqquestions: 1
faqright: 29
faqsessions: 32870
faqtags: 0
faquser: 2
faquser_group: 0
faquser_right: 29
faquserdata: 2
faquserlogin: 2
faqvisits: 45
faqvoting: 23


After clicking on any link on the page, i'm redirected back to the login screen and the debug is:
DEBUG INFORMATION:
COOKIES:
pmf_lang: en

TABLES & RECORDS:
faqadminlog: 194
faqcaptcha: 19
faqcategories: 8
faqcategory_group: 8
faqcategory_user: 8
faqcategoryrelations: 45
faqchanges: 37
faqcomments: 0
faqconfig: 33
faqdata: 45
faqdata_group: 45
faqdata_revisions: 13
faqdata_tags: 0
faqdata_user: 45
faqglossary: 0
faqgroup: 0
faqgroup_right: 0
faqlinkverifyrules: 0
faqnews: 1
faqquestions: 1
faqright: 29
faqsessions: 32870
faqtags: 0
faquser: 2
faquser_group: 0
faquser_right: 29
faquserdata: 2
faquserlogin: 2
faqvisits: 45
faqvoting: 23
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

was this an update from an older version?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
jason559
Posts: 16
Joined: Wed Jun 27, 2007 8:03 am

Post by jason559 »

Yes, it was.

Unfortunately, I do not know the exact version of the old version. I believe it was in the 1.7 range.
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

I'll take a look at it.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
matteo
Posts: 572
Joined: Sun Nov 20, 2005 6:53 pm
Location: Italy

Re: Login issues with 2.0.1

Post by matteo »

Hi,
jason559 wrote: COOKIES:
pmf_lang: en
could you check if everything is fine with PHP sessions in your server? A possibile reason for your issue could be that PHP sessions cannot be created, e.g. a permission issue with your session.save_path.

Ciao,
Matteo
phpMyFAQ QA / Developer
Amazon.co.uk Wishlist
jason559
Posts: 16
Joined: Wed Jun 27, 2007 8:03 am

Post by jason559 »

Hi, yes I did check that, via php.ini. I see the session files getting created in the proper folder. It took me awhile to get that all checked. I also have other scripts that use sessions without issues.
matteo
Posts: 572
Joined: Sun Nov 20, 2005 6:53 pm
Location: Italy

Post by matteo »

Hi,
please could you check if this post could be of any help for your deployment?
Besides, do you have any error log to let us help you?

Ciao,
Matteo
phpMyFAQ QA / Developer
Amazon.co.uk Wishlist
jason559
Posts: 16
Joined: Wed Jun 27, 2007 8:03 am

Post by jason559 »

My Apache log file does not show anything in the error log file. Is there somewhere else I should try? I wish I could downgrade back to the last 1.x series, I didn't have the issue with those releases. Is there anything else I can do to get my login/MyFAQ working again? I also updated to 2.0.2 and it didn't correct the problem.
jason559
Posts: 16
Joined: Wed Jun 27, 2007 8:03 am

Post by jason559 »

It doesn't look like I can...

Is there anyway I can downgrade, and if so are there any instructions?
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

can you please send me your database dump to me? Thanks!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
jason559
Posts: 16
Joined: Wed Jun 27, 2007 8:03 am

Post by jason559 »

I sent the file to you about 12 hours ago. Please let me know if for some reason it didn't arrive. I'm unsure if 2mb was too much to send via email. Thanks
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

nothing arrived here... please put it on a server and send me the download URL by private message. Thanks.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
jason559
Posts: 16
Joined: Wed Jun 27, 2007 8:03 am

Post by jason559 »

Sent via PM
jason559
Posts: 16
Joined: Wed Jun 27, 2007 8:03 am

Post by jason559 »

Did you ever receive my PM? It's been quite a few months and I did the upgrade to 2.0.4 and I still have the same issue. I noticed others having an issue too, but they are using MS SQL, I'm using MySQL...

I also wiped the database and all files, did a clean re-install, same issue.
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

sorry! Does this fix work for you? -> viewtopic.php?p=21632#21632

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply