The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Database error after upgrade?
I am receiving emails with the following information. Any direction would be appreciated.
Database error in vBulletin 4.0.1: Invalid SQL: SELECT album.*, picture.pictureid, picture.extension, picture.idhash, picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height, user.* FROM vb_album AS album LEFT JOIN vb_picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0) LEFT JOIN vb_user AS user ON (album.userid = user.userid) WHERE album.state IN ('public', 'private', 'profile') ORDER BY LIMIT 60, 20; MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 60, 20' at line 10 Error Number : 1064 Request Date : Wednesday, February 3rd 2010 @ 11:12:16 PM Error Date : Wednesday, February 3rd 2010 @ 11:12:16 PM Script : http://www.atlanticanglers.com/forum...?query=&page=4 |
#2
|
||||
|
||||
Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php PHP Code:
|
#3
|
||||
|
||||
Lynne, you are an asset to this community! I will try your suggestions.
|
#4
|
||||
|
||||
Lynne is awesome
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|