The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
SQL database error (prolly from plugin)
Some of my users are experiencing problems, I on the other hand am not :P. But I can't seem to find the cause.
Code:
Database error in vBulletin 3.6.5: Invalid SQL: SELECT IF(votenum >= 100, votenum, 0) AS votenum, IF(votenum >= 100 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.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach, hiddencount, deletedcount , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason , threadredirect.expires ,thread_user.usergroupid, thread_user.membergroupids, thread_user.userid FROM php_thread AS thread LEFT JOIN php_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread') LEFT JOIN php_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1) PHP Code:
|
#2
|
|||
|
|||
Please post the full error message, you have left out the most important part.
|
#3
|
|||
|
|||
Hehe, thats what I said to them too . I'll post it asap.
|
#4
|
|||
|
|||
Yu can still get the full error from your technical email, where it is also sent.
|
#5
|
|||
|
|||
Okay I finally got it:
Code:
Database error in vBulletin 3.6.5: Invalid SQL: SELECT post.pagetext AS preview, thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach, hiddencount, deletedcount , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason , threadredirect.expires ,thread_user.usergroupid, thread_user.membergroupids, thread_user.userid FROM veh_thread AS thread LEFT JOIN veh_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread') LEFT JOIN veh_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1) LEFT JOIN veh_post AS post ON(post.postid = thread.firstpostid) LEFT JOIN veh_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid) LEFT JOIN user AS thread_user ON(thread.postuserid = thread_user.userid) WHERE thread.threadid IN (0) ORDER BY sticky DESC, lastpost DESC; MySQL Error : Table '28_vorum.user' doesn't exist Error Number : 1146 Date : Monday, April 2nd 2007 @ 04:48:18 AM Script : http://xxxxx/forum/forumdisplay.php?f=6 Referrer : http://xxxxx/forum/index.php IP Address : xxx.xxx.xxx.xxx Username : xxxxx Classname : vB_Database PHP Code:
|
#6
|
||||
|
||||
Code:
$hook_query_joins .= 'LEFT JOIN user AS thread_user ON(thread.postuserid = thread_user.userid)'; Code:
$hook_query_joins .= 'LEFT JOIN '.TABLE_PREFIX.'user AS thread_user ON(thread.postuserid = thread_user.userid)'; |
#7
|
|||
|
|||
You must have dot5hosting. I have the same problem. Their SQL server ran out of room on the partition. The dirtbags don't have teach support over the weekend. I'm going to get my money back tomorrow Guess we all have to wait till tomorrow.
See my post here; https://vborg.vbsupport.ru/showthread.php?t=143804 |
#8
|
|||
|
|||
Thx for swift reply, I'll try it in the morning
|
#9
|
|||
|
|||
Quote:
As WetWired replied, this is simply a case of a plugin that does not use the TABLE_PREFIX. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|