Database error in vBulletin 3.0.9:
Invalid SQL:
SELECT user.*, subscribethread.emailupdate
FROM subscribethread AS subscribethread, user AS user
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
WHERE subscribethread.threadid = 4368 AND
subscribethread.emailupdate IN (1, 4) AND
subscribethread.userid = user.userid AND
CONCAT(' ', usertextfield.ignorelist, ' ') NOT LIKE ' 4 ' AND
user.usergroupid <> 3 AND
user.userid <> 4 AND
user.lastactivity > 1129709854 AND
(usergroup.genericoptions & 32) = 0
mysql error: Unknown table 'usertextfield' in where clause
mysql error number: 1109
Date: Wednesday 19th of October 2005 06:22:50 PM
Script: /forum/newreply.php
Referer: /forum/showthread.php?t=4368
Username: Robert
IP Address: xxx.xxx
Invalid SQL:
SELECT user.*, subscribethread.emailupdate
FROM subscribethread AS subscribethread, user AS user
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
WHERE subscribethread.threadid = 4368 AND
subscribethread.emailupdate IN (1, 4) AND
subscribethread.userid = user.userid AND
CONCAT(' ', usertextfield.ignorelist, ' ') NOT LIKE ' 4 ' AND
user.usergroupid <> 3 AND
user.userid <> 4 AND
user.lastactivity > 1129709854 AND
(usergroup.genericoptions & 32) = 0
mysql error: Unknown table 'usertextfield' in where clause
mysql error number: 1109
Date: Wednesday 19th of October 2005 06:22:50 PM
Script: /forum/newreply.php
Referer: /forum/showthread.php?t=4368
Username: Robert
IP Address: xxx.xxx
Now, that table does exist, and so does the field, 'ignorelist'.
Anyone know what could be the matter??
Comment