Details
Description
In multi-lingual CiviCRM, when a recipient of a mailing tries to opt-out, and the opt-out link was in another language than English, the user will fall on a "DB error: syntax error".
Example link:
http://www.example.org/fr/civicrm/mailing/optout?reset=1&jid=247&qid=419319&h=0cf74e6a6502554f
This is the SQL query/error:
[debug_info] =>
SELECT civicrm_group_fr_FR.id as group_id,
civicrm_group_fr_FR.title as title,
civicrm_group_fr_FR.description as description
FROM civicrm_group_fr_FR
LEFT JOIN civicrm_group_contact
ON civicrm_group_contact.group_id = civicrm_group_fr_FR.id
WHERE civicrm_group_fr_FR.id IN ()
AND civicrm_group_fr_FR.is_hidden = 0
AND (civicrm_group_fr_FR.saved_search_id is not null
OR (civicrm_group_contact.contact_id = 48950
AND civicrm_group_contact.status = 'Added')
)
[nativecode=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 ')
AND civicrm_group_fr_FR.is_hidden = 0
AND ' at line 7]
Attachments
Issue Links
- supplements
-
CRM-10956 Multi-lingual & CiviMail: Mailings (draft, unscheduled, archived) are all missing, cannot send new mailings
- Won't Do