Project

General

Profile

Actions
Copy link

Bug #21887

closed

SQL parser cannot parse escaped single quote in INSERT statement

Added by Xavier Perseguers almost 15 years ago. Updated almost 15 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Xavier Perseguers
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2009-12-27
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

When trying to import static data from EXT:static_info_tables, the script dies with typical error:

ERROR: Query could not be parsed: "SQL engine parse ERROR: No ) parenthesis in list: near "Andorra', 'Principality of Andorra', 'Andorra la Vella', 'ad', 'EUR', '978', '376', '0', '1', '0', 'Andorra', 'Andorra', '1') "". Query: "INSERT INTO static_countries VALUES ('1', '0', '0', 'AD', 'AND', '20', '39', 'Principat d\'Andorra', 'Principality of Andorra', 'Andorra la Vella', 'ad', 'EUR', '978', '376', '0', '1', '0', 'Andorra', 'Andorra', '1');"

This is cause by the escaped single quote in "Principat d\'Andorra"

(issue imported from #M13104)

Files

Download all files
13104_static_info_tables.diff (1.24 KB) 13104_static_info_tables.diff Administrator Admin, 2009-12-28 01:03
13104_core.diff (678 Bytes) 13104_core.diff Administrator Admin, 2009-12-28 01:35
13104_dbal.diff (2.13 KB) 13104_dbal.diff Administrator Admin, 2009-12-28 01:35
Actions
Copy link

Also available in: Atom PDF