CiviCRM Community Forums (archive)

3.4.alpha1

When I attempt to dedupe contacts I get a database error. It is due to apostrophe's in a contact's names which interfere with the MySQL syntax.

Here is my sanitised error message ...

Database Error Code: 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 '*****";s:5:"dstID";s:5:"*****";s:7:"dstName";s:13:"***** O'*****";s:6:"weight";s' at line 130, 1064
Additional Details:

Array
(
    [callback] => Array
        (
            [ 0 ] => CRM_Core_Error
            [ 1 ] => handle
        )

    [ code ] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_prevnext_cache ( entity_table, entity_id1, entity_id2, cacheKey, data ) VALUES

Here is the sanitised line that causes the problem ...

  ( 'civicrm_contact', *****, *****, 'merge Individual_8_0', 'a:6:{s:5:"srcID";s:5:"*****";s:7:"srcName";s:13:"***** O'*****";s:5:"dstID";s:5:"*****";s:7:"dstName";s:13:"***** O'*****";s:6:"weight";s:2:"20";s:8:"canMerge";b:1;}' ) ,

If a contact has a name containing an apostrophe, that is interpreted by MySQL as a string delimiter. Names need to be quoted to avoid this.

Ken

Created issue CRM-7637