2008-08-13, 07:01 PM
I get this error when I attempt to use the mass-mail function and fill in any other limiters besides usergroup:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''3' AND (u.usergroup IN (4) OR CONCAT(',',additionalgroups,',') LIKE '%,4,%')' at line 1
Query:
SELECT COUNT(uid) AS num FROM mybb14_users u WHERE 1=1 AND u.username LIKE '%GG-Xtreme%' AND u.email LIKE '%[email protected]%' AND u.postnumpostnum_dir'3' AND (u.usergroup IN (4) OR CONCAT(',',additionalgroups,',') LIKE '%,4,%')
Please contact the MyBB Group for support.