Subject - Hierarchical Geography Batch loading terms with apostrophes

Project:RUcore Workflow Management System (WMS)
Version:5.0
Component:Controlled Vocabulary Module
Category:bug report
Priority:normal
Assigned:yuyang
Status:closed
Description

The batch load process gives an error message when there is a term with apostrophe.

"Error executing query: insert into REF_Country values (54, 'C?TE D'IVOIRE', 'CI', 54, 'ISO 3166', 'Y').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 'IVOIRE', 'CI', 54, 'ISO 3166', 'Y')' at line 1"

"Error executing query: insert into REF_Country values (115, '""KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF""', 'KP', 116, 'ISO 3166', 'Y').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 REPUBLIC OF""', 'KP', 116, 'ISO 3166', 'Y')' at line 1"

"Error executing query: insert into REF_Country values (118, 'LAO PEOPLE'S DEMOCRATIC REPUBLIC', 'LA', 120, 'ISO 3166', 'Y').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 DEMOCRATIC REPUBLIC', 'LA', 120, 'ISO 3166', 'Y')' at line 1"

"Error executing query: insert into REF_City values (1, 1, 'Abbott's Lane Site (N.J.)', '', 1, '', 'Y').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 Lane Site (N.J.)', '', 1, '', 'Y')' at line 1"

"Error executing query: insert into REF_City values (72, 1, 'Blackman's Mills (N.J.)', '', 73, '', 'Y').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 Mills (N.J.)', '', 73, '', 'Y')' at line 1"

Error processing config task.

Comments

#1

Status:active» fixed

Fixed, by product of the fix for the other hierarchicalGeographic bug. -YY

#2

Status:fixed» closed

The hierarchical geography terms are not batch loaded any more. They are entered the same way other terms are entered. KA

Back to top