Hi , everybody !
This morning I have some problem with my library. When I click on any video, I see this:
Code:
Database error in vBulletin 4.1.4:
Invalid SQL:
SELECT media_comment.*, user.*, media.title, IF(NOT ISNULL(user.userid), user.username, media_comment.username) AS username,
NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath,
customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.dateline AS avatardateline
FROM media_comment AS media_comment
LEFT JOIN user AS user ON(user.userid = media_comment.userID)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN media AS media ON(media.mediaID = media_comment.mediaID)
WHERE media_comment.mediaID = '241'
ORDER BY media_comment.dateline DESC
LIMIT -0, 0;
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 '-0, 0' at line 11
Error Number : 1064
Request Date : Wednesday, July 13th 2011 @ 11:10:38 AM
Error Date : Wednesday, July 13th 2011 @ 11:10:39 AM
Script : http://www.povsemumiru.ru/media.php?do=details&mid=241
Referrer :
IP Address : 87.245.137.50
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.54-rel12.5-log
Can you help me ?