MyBB Community Forums

Sorry guys, another SQLite one...

MyBB Version: 1.4.4
SQLite Version: 2.8.17
Problem: When you're defining the mail's recipients, if you define it by choosing a usergroup, you get an SQL error.
The Error Messages:
[attachment=12144]
and
[attachment=12145]
To Reproduce: Go to ACP > Users & Groups > Mass Mail > Create New Mailing. When you get to 'Send Mass Mailing: Step 3 - Define the Recipients', choose one or more usergroups, and on the next step, you'll see the error.
Extra Info: When you go back and then reload the 'Mass mail Queue' page, the mailing does appear, as a draft.

hmm, not sure why this is happening. It appears to be right

switch($db->type)
{
	case "pgsql":
	case "sqlite3":
	case "sqlite2":
		$additional_sql .= " OR ','||additionalgroups||',' LIKE '%,{$usergroup},%'";
		break;
	default:
		$additional_sql .= " OR CONCAT(',',additionalgroups,',') LIKE '%,{$usergroup},%'";
}

inc/functions_massmail.php

This should have been fixed from the old bug: http://community.mybboard.net/thread-41616.html

I can confirm it is fixed in SVN (both branch and trunk).

MattR, please make sure your running the latest SVN when you test your bugs.