| brianvu |
03-22-2006 02:30 PM |
SQL error ! database error in vbulletin 3.5.4
hi all people
my following problems is last month i used the vbb 3.5.3 version . its good , but last weekend i have this vbb database error from the vbulletin mail. now i update the vbb 3.5.3 to 3.5.4 the problem is not fix . please anybody know how can i fix this problem , help me to fix this problem . thanxs for your help and support .
Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title AS threadtitle, thread.forumid,
pollid, open, replycount, postusername, postuserid, thread.iconid AS
threadiconid,
thread.lastpost, lastposter, thread.dateline, IF(views<=replycount,
replycount+1, views) AS views, notes, thread.visible, sticky,
votetotal, thread.attach,
hiddencount
,post.pagetext
FROM thread AS thread
WHERE thread.threadid IN (0)
ORDER BY sticky DESC, thread.lastpost DESC;
MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Date : Wednesday, March 22nd 2006 @ 03:15:38 PM
Script : http://www.thuytinh.org/forums/forumdisplay.php?f=32
Referrer :
IP Address : 64.229.16.21
Username : Unregistered
Classname : vb_database
|
More Information