Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-14465

Opt-out link is broken in multi-lingual CiviCRM / non-English

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.4.4
    • Fix Version/s: 4.5
    • Component/s: None
    • Labels:

      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

            Activity

              People

              • Assignee:
                atif.shaikh Atif Shaikh
                Reporter:
                mlutfy Mathieu Lutfy
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: