When I add a new mailing list, the following SQL error shows up:
Any idea? The mailing list DOES get created, however, nobody is subscribed to it (even after I checked off the 'Default Subscribed' box for several usergroups).
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 : [url]http://www.domain.com/admincp/vbmail.php?do=mailinglist[/url]
Referrer : [url]http://www.domain.com/admincp/vbmail.php?do=mailinglist[/url]
IP Address : ***.**.**.***
Username : AdminUsername
Classname : vB_Database
MySQL Version : 5.5.21-55
Any idea? The mailing list DOES get created, however, nobody is subscribed to it (even after I checked off the 'Default Subscribed' box for several usergroups).