Hello
I have alot of mails in my inbox from my forum they says:
Quote:
Database error in vBulletin 3.8.1: Invalid SQL: SELECT user.*, ufield.*, subscribethread.emailupdate, subscribethread.subscribethreadid FROM subscribethread AS subscribethread INNER JOIN user AS user ON (subscribethread.userid = user.userid) INNER JOIN userfield AS ufield ON (ufield.userid = user.userid) LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE subscribethread.threadid = 1591 AND subscribethread.emailupdate IN (1, 4) AND subscribethread.canview = 1 AND CONCAT(' ', IF(usertextfield.ignorelist IS NULL, '', usertextfield.ignorelist), ' ') NOT LIKE '% 3 %' AND user.usergroupid <> 3 AND ufield.field20 <> '' AND (usergroup.genericoptions & 32); MySQL Error : Unknown column 'ufield.field20' in 'where clause' Error Number : 1054 Request Date : Thursday, July 9th 2009 @ 07:46:34 PM Error Date : Thursday, July 9th 2009 @ 07:46:34 PM Script : http://www.parseforum.com/newreply.p...streply&t=1591 Referrer : http://www.parseforum.com/newreply.p...quote=1&p=7786 IP Address : 78.38.15.2 Username : Tohid Classname : vB_Database MySQL Version :
|
I`m using vb 3.8.1 pl 1 on a VPS with php 5.2.10 and MySQL 5.0.67
what should I do?