FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Can not Login After Upgrade
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Can not Login After Upgrade [message #30950] Tue, 21 March 2006 20:43 Go to next message
aitor is currently offline  aitor   Spain
Messages: 17
Registered: September 2003
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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: Tue, 21 March 2006 20:48]

Report message to a moderator

Re: Can not Login After Upgrade [message #30965 is a reply to message #30950] Wed, 22 March 2006 12: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
add to buddy list
ignore all messages by this user
Does the query fail if you execute it manually? I can't see a problem with the query...

FUDforum Core Developer
Re: Can not Login After Upgrade [message #30971 is a reply to message #30965] Wed, 22 March 2006 16:11 Go to previous messageGo to next message
aitor is currently offline  aitor   Spain
Messages: 17
Registered: September 2003
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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

Re: Can not Login After Upgrade [message #30984 is a reply to message #30971] Thu, 23 March 2006 12: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
add to buddy list
ignore all messages by this user
What database driver are you using mysql or pdo_mysql?

FUDforum Core Developer
Re: Can not Login After Upgrade [message #30990 is a reply to message #30984] Thu, 23 March 2006 15:32 Go to previous messageGo to next message
aitor is currently offline  aitor   Spain
Messages: 17
Registered: September 2003
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I use mysql before update how can i know what kind of driver is using fud?
Re: Can not Login After Upgrade [message #31010 is a reply to message #30990] Fri, 24 March 2006 11:33 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Send me the
/home/uskolao/public_html/FUDforum2/include/theme/default/db.inc
File and I can tell you.


FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Wed Jan 17 08:18:00 EST 2018

Total time taken to generate the page: 0.00697 seconds