Members Area SQL Error

DavidOWS

New Member
When opening a support ticket:

Database error in vBulletin 3.7.5:

Code:
Invalid SQL:
SELECT IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, user.usertitle as usertitle,
			response.userid as userid,response.dateline as dateline,response.message as message, user.username as username FROM cevbsql_ma_responses as response
		LEFT JOIN cevbsql_user ON (response.userid = user.userid)	
		WHERE ticketid = '1';

MySQL Error   : Unknown table 'user' in field list
Error Number  : 1109
Request Date  : Sunday, February 1st 2009 @ 07:29:23 PM
Error Date    : Sunday, February 1st 2009 @ 07:29:23 PM
Script        : http://mysite.com/helpdesk.php?do=viewticket&id=1
Referrer      : https://mysite.com/helpdesk.php
IP Address    : 0.0.0.0
Username      : 
Classname     : vb_database
MySQL Version :
 
Back
Top