Textpattern CMS

#1 2006-07-02 10:13:36

DaveR

Member

From: Dunedin, New Zealand

Registered: 2004-04-20

Posts: 13

Error on login

Hi,

I’ve had a Textpattern site running for several months. Today it returned the following error when I attempted to login:

Fatal error: You have an error in your SQL syntax near ‘(lower(‘MY_PASSWORD’)) or pass = old_password(‘MY_PASSWORD’)) and privs > 0’ at line 2 select name from `conferencetxp_users` where name = ‘dave’ and (pass = old_password(lower(‘MY_PASSWORD’)) or pass = old_password(‘MY_PASSWORD’)) and privs > 0 in /conf/sar/conference/textpattern/lib/txplib_db.php on line 61

The same error is returned whether I enter the correct username and password or incorrect ones.

How can I check the SQL syntax when I can’t log in to set the debug flag? That is, the debug flag used in txplib_db.php – the site is already in debugging mode.

…and anyway how can entering a username and password generate incorrect SQL???

Thanks for any help.
-Dave

Last edited by DaveR (2006-07-02 10:14:20)

#2 2006-07-02 10:45:43

Sencer

Archived Developer

From: cgn, de

Registered: 2004-03-23

Posts: 1,803

Website

Re: Error on login

Which version of Textpattern? Which version of mysql?

If yu are on mysql5.0 what do you get when you run the following query on the database (e.g. with phpmyadmin):

SELECT @@session.sql_mode;

#3 2006-07-02 11:11:54

DaveR

Member

From: Dunedin, New Zealand

Registered: 2004-04-20

Posts: 13

Re: Error on login

Hi,

Textpattern: 4.0.3 (r1188)
MySQL v3.23.58
PHP: 4.3.11

-Dave

#4 2006-07-02 11:40:09

Sencer

Archived Developer

From: cgn, de

Registered: 2004-03-23

Posts: 1,803

Website

Re: Error on login

While of course you shouldn’t be seeing that error-mesage, your actual problem is that either your name or your password are incorrect. The SQL-error only happens later when we try to workaround a backwards-compatibilit issue that ocurred between 3.23 and 4.0.

IIRC, the Textbook Manual has instructions on how you can reset your password.

#5 2006-07-03 09:05:13

DaveR

Member

From: Dunedin, New Zealand

Registered: 2004-04-20

Posts: 13

Re: Error on login

Sencer,

Thanks for that information.

I logged in sucessfully from another computer and reset the password. I can now log in successfully from all my machines.

Cheers,
Dave