FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Installation Issues » Can not Login After Upgrade
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Can not Login After Upgrade [message #30950] Wed, 22 March 2006 01:43 Go to next message
aitor is currently offline  aitor   Spain
Messages: 17
Registered: September 2003
Karma: 0
Junior Member
I have upgraded my old fud and i can´t login, checked that cookies are being send to browser and i see that i have this error in the file errors/sql_errors.

?830 ?1142991343?(/home/uskolao/public_html/FUDforum2/include/theme/default/db.i nc:73 <br />
/home/uskolao/public_html/FUDforum2/include/theme/default/db.inc:133<br />
/home/uskolao/public_html/foros/adm/admloginuser.php:23<br />
) 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right $
Query: SELECT id FROM fud253_users WHERE login='aitor' AND passwd='compiledpassword' AND users_opt&gt;=10485$
_POST: array (
'SQ' =&gt; '0',
'login' =&gt; 'aitor',
'passwd' =&gt; 'mipassword',
'btn_login' =&gt; 'Login',
)<br />
Server Version: 4.0.25-standard<br />
[Referring Page] http://www.uskola.org/foros/adm/admloginuser.php?<br />


Any Hint?



Upgrade script says.

Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/home/uskolao/public_html/FUDforum2/errors/.backup/"

Beginning SQL Upgrades
SQL Upgrades Complete
Adding GLOBAL Variables
Compiling theme default
Compiling theme uskola

Executing Consistency Checker (if the popup with the consistency checker failed to appear you MUST click here
PLEASE REMOVE THIS FILE (/home/uskolao/public_html/foros/upgrade.php) UPON COMPLETION OF THE UPGRADE PROCESS.
THIS IS IMPERATIVE, OTHERWISE ANYONE COULD RUN THIS SCRIPT!

[Updated on: Wed, 22 March 2006 01:48]

Report message to a moderator

Re: Can not Login After Upgrade [message #30965 is a reply to message #30950] Wed, 22 March 2006 17:08 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Does the query fail if you execute it manually? I can't see a problem with the query...

FUDforum Core Developer

Report message to a moderator

Re: Can not Login After Upgrade [message #30971 is a reply to message #30965] Wed, 22 March 2006 21:11 Go to previous messageGo to next message
aitor is currently offline  aitor   Spain
Messages: 17
Registered: September 2003
Karma: 0
Junior Member
If I execute the query with phpmyadmin

SELECT id FROM fud253_users WHERE login='aitor' AND passwd='CompiledPass' AND users_opt>=10485

It returns id=2

Report message to a moderator

Re: Can not Login After Upgrade [message #30984 is a reply to message #30971] Thu, 23 March 2006 17:53 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
What database driver are you using mysql or pdo_mysql?

FUDforum Core Developer

Report message to a moderator

Re: Can not Login After Upgrade [message #30990 is a reply to message #30984] Thu, 23 March 2006 20:32 Go to previous messageGo to next message
aitor is currently offline  aitor   Spain
Messages: 17
Registered: September 2003
Karma: 0
Junior Member
I use mysql before update how can i know what kind of driver is using fud?

Report message to a moderator

Re: Can not Login After Upgrade [message #31010 is a reply to message #30990] Fri, 24 March 2006 16:33 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Send me the
/home/uskolao/public_html/FUDforum2/include/theme/default/db.inc
File and I can tell you.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: System Error on Posts after applying theme template
Next Topic: CAN't UPDATE SERVER LOCAL TIME
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 26 16:47:09 GMT 2024

Total time taken to generate the page: 0.03177 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software