xadoa
Mon 17th Dec '07, 3:45pm
i got this error after the upgrade when i tried to list the forums .. listing the main page or the blogs etc.. are fine except all the subforums .. this happen to only the forumdisplay.php file from the 3.7 b2 .. when i copy the 3.6.8p2 to replace this new files then it worked fine.. what's wrong?
xd
Database error in vBulletin 3.7.0 Beta 2:
Invalid SQL:
SELECT
IF(votenum >= 2, votenum, 0) AS votenum,
IF(votenum >= 2 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.forumid = 376
ORDER BY dateline DESC
LIMIT 5;
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 ' thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, th' at line 6
Error Number : 1064
Date : Monday, December 17th 2007 @ 12:20:58 PM
Script : http://xxx.com/forumdisplay.php?f=36 (http://sextalk.sexviet.com/forumdisplay.php?f=36)
Referrer :
IP Address : 99.27.154
Username : xadoa
Classname : vb_database
xd
Database error in vBulletin 3.7.0 Beta 2:
Invalid SQL:
SELECT
IF(votenum >= 2, votenum, 0) AS votenum,
IF(votenum >= 2 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.forumid = 376
ORDER BY dateline DESC
LIMIT 5;
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 ' thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, th' at line 6
Error Number : 1064
Date : Monday, December 17th 2007 @ 12:20:58 PM
Script : http://xxx.com/forumdisplay.php?f=36 (http://sextalk.sexviet.com/forumdisplay.php?f=36)
Referrer :
IP Address : 99.27.154
Username : xadoa
Classname : vb_database