Skip to content
Snippets Groups Projects
New look: Off

Dedupe for Individual Birth Date Results in Error

    • Closed Issue created by jasonobrown @jasonobrown 
    civicrm: $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO dedupe (id1, id2, weight) SELECT t1.id id1, t2.id id2, 5 weight FROM civicrm_contact t1 JOIN civicrm_contact t2 USING (birth_date) JOIN dedupe_copy ON dedupe_copy.id1 = t1.id AND dedupe_copy.id2 = t2.id WHERE t1.contact_type = &#039;Individual&#039; AND t2.contact_type = &#039;Individual&#039; AND t1.id < t2.id AND t1.birth_date IS NOT NULL AND t1.birth_date <> &#039;&#039; GROUP BY id1, id2, weight ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1292 ** Incorrect date value: &#039;&#039; for column &#039;birth_date&#039; at row 1]
    [type] => DB_Error
    [user_info] => INSERT INTO dedupe (id1, id2, weight) SELECT t1.id id1, t2.id id2, 5 weight FROM civicrm_contact t1 JOIN civicrm_contact t2 USING (birth_date) JOIN dedupe_copy ON dedupe_copy.id1 = t1.id AND dedupe_copy.id2 = t2.id WHERE t1.contact_type = &#039;Individual&#039; AND t2.contact_type = &#039;Individual&#039; AND t1.id < t2.id AND t1.birth_date IS NOT NULL AND t1.birth_date <> &#039;&#039; GROUP BY id1, id2, weight ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1292 ** Incorrect date value: &#039;&#039; for column &#039;birth_date&#039; at row 1]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO dedupe (id1, id2, weight) SELECT t1.id id1, t2.id id2, 5 weight FROM civicrm_contact t1 JOIN civicrm_contact t2 USING (birth_date) JOIN dedupe_copy ON dedupe_copy.id1 = t1.id AND dedupe_copy.id2 = t2.id WHERE t1.contact_type = &#039;Individual&#039; AND t2.contact_type = &#039;Individual&#039; AND t1.id < t2.id AND t1.birth_date IS NOT NULL AND t1.birth_date <> &#039;&#039; GROUP BY id1, id2, weight ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1292 ** Incorrect date value: &#039;&#039; for column &#039;birth_date&#039; at row 1]"]
)
    Edited
    To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information

    Child items ...

    • Activity

    Please register or sign in to reply