SQL database error (prolly from plugin)

[PayBas]

Some of my users are experiencing problems, I on the other hand am not :P. But I can't seem to find the cause.

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)

I think it's caused by this small plugin but not 100% sure:

PHP Code:

$hook_query_fields .= ',thread_user.usergroupid, thread_user.membergroupids, thread_user.userid'; 
$hook_query_joins .= 'LEFT JOIN user AS thread_user ON(thread.postuserid = thread_user.userid)'; 


[Marco van Herwaarden]

Please post the full error message, you have left out the most important part.

[PayBas]

Hehe, thats what I said to them too . I'll post it asap.

[Marco van Herwaarden]

Yu can still get the full error from your technical email, where it is also sent.

[PayBas]

Okay I finally got it:

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

And it's caused by this plugin:

PHP Code:

$hook_query_fields .= ',thread_user.usergroupid, thread_user.membergroupids, thread_user.userid'; 
$hook_query_joins .= 'LEFT JOIN user AS thread_user ON(thread.postuserid = thread_user.userid)'; 


Hook: forumdisplay_query

[WetWired]

$hook_query_joins .= 'LEFT JOIN user AS thread_user ON(thread.postuserid = thread_user.userid)';

becomes

$hook_query_joins .= 'LEFT JOIN '.TABLE_PREFIX.'user AS thread_user ON(thread.postuserid = thread_user.userid)';

[ZomgStuff]

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

[PayBas]

Thx for swift reply, I'll try it in the morning

[Marco van Herwaarden]

Originally Posted by ZomgStuff

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

Please do not jump to conclusions or spam your frustrations to multiple threads, especially as there is no indication that your problem has anything to do with this one.

As WetWired replied, this is simply a case of a plugin that does not use the TABLE_PREFIX.