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
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