The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Zero user sql error
Hi.
after upgrade to 3.7 from 3.6.8 i get the same error over and over on login and logout screens. funny thing, on the test installation with the very same files i get no such error. Code:
Database error in vBulletin 3.7.0: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM prefix_user AS user LEFT JOIN prefix_userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN prefix_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE user.userid = 0; MySQL Error : Error Number : Request Date : Thursday, July 17th 2008 @ 11:33:59 AM Error Date : Thursday, July 17th 2008 @ 11:33:59 AM Script : http://*my site*/login.php?do=logout&logouthash=fce854a65381166ab43f7e64884e11572755c690 Referrer : http://*my site*/forum/ IP Address : *** Username : root Classname : vB_Database_MySQLi MySQL Version : I can`t possibly think of a reason to search for user 0, as there shouldn`t be one. Reinstalling from scratch is not an option, unfortunately, as the database is quite large and importing it would take loads of time and work. Thanks in advance |
#2
|
|||
|
|||
Make sure you've uploaded all the PHP files which are appropriate for your version of vBulletin.
Else disable all your plugins (See: Help! I've broken my board! for information on how to temporarily disable them) Finally if your issue still persists, create a New Style with No Parent Style and test again. (Maybe try upgrading to 3.7.1 or 3.7.2 ? Not sure why you just didn't skip straight to these as they only contain bug fixes to 3.7.0 really). |
#3
|
||||
|
||||
Check your MySQL username/password in config.php.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|