Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.8
-
Fix Version/s: 2.0
-
Component/s: Core CiviCRM
-
Labels:None
Description
The data in civicrm_data.fr_CA.sql somestimes has an apostrophe (') in the text, such as:
INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved )
VALUES( @domain_id, 'Employé(e) de', 'Employeur de', 'Relation d'emploi.','Individual','Organization', 0 );
In the above, the string "Relation d'emploi" should be escaped, otherwise it causes an SQL error. This happens with another few strings in the same file.
Thanks,
Mathieu