PDA

View Full Version : Database error after upgrade?


delmarva
02-04-2010, 02:47 AM
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/all_albums.php?query=&page=4

Lynne
02-04-2010, 08:15 PM
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

define('DISABLE_HOOKS', true);

If that doesn't fix it, then you should be posting over on vb.com for help with your default vB4 forum. See this sticky - Installation Issues / Questions or bug reports regarding default vBulletin 4.0 (https://vborg.vbsupport.ru/showthread.php?t=228035)

delmarva
02-08-2010, 03:18 PM
Lynne, you are an asset to this community! I will try your suggestions.

Brandon Sheley
02-08-2010, 03:38 PM
Lynne is awesome :)