When I add a new mailing list, the following SQL error shows up:
Code:
Database error in vBulletin 3.8.7:
Invalid SQL:
INSERT IGNORE INTO dbtech_vbmail_subscription
(userid, mailinglistid)
(
SELECT userid, 3 AS mailinglistid
FROM user AS user
WHERE (
FIND_IN_SET(2, membergroupids)
OR usergroupid IN(2)
)
AND user.dbtech_vbmail_bounceflag = '0'
);
MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number : 1054
Request Date : Thursday, May 10th 2012 @ 09:32:18 AM
Error Date : Thursday, May 10th 2012 @ 09:32:18 AM
Script : http://www.domain.com/admincp/vbmail.php?do=mailinglist
Referrer : http://www.domain.com/admincp/vbmail.php?do=mailinglist
IP Address : ***.**.**.***
Username : AdminUsername
Classname : vB_Database
MySQL Version : 5.5.21-55
Any idea?