i'm using Community Edition version (actually 3.6.17).
First of all, thanks for all the additions done in release 3.6.5.
I've tried to use NewsLetter module, but pressing "Send" button, appears this message:
There was an unexpected problem building the email: Database error: Could not prepare statement SQL: INSERT INTO ml_sendmailing_contacts SELECT DISTINCT ?, contact_id FROM ml_mailing_contacts c INNER JOIN ab_contacts a ON (c.contact_id=a.id) WHERE group_id=? AND email_allowed='1' AND email!='' types:ii params: array ( 0 => 4, 1 => '1', )
MySQL Error: 1052 (Column 'group_id' in where clause is ambiguous)
I've solved myself that error/bug.
I've edited :
<group-office install dir>/modules/mailings/classes/mailings.class.inc.php
at line 386, changed this:
"WHERE group_id=? AND email_allowed='1' AND email!=''";
"WHERE c.group_id=? AND email_allowed='1' AND email!=''";
Now NewsLetter works perfectly.