View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005592 | OXID eShop (all versions) | 7. --- Other tools -------------- | public | 2014-01-07 11:59 | 2023-02-13 10:02 |
Reporter | marco_steinhaeuser | Assigned To | |||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 4.8.2 / 5.1.2 | ||||
Summary | 0005592: SQL importer doesn't work correctly when parsing UTF-8 | ||||
Description | When trying to import an UTF-8 SQL file via admin -> service -> tools, the import fails with the error message "You have an error in your SQL syntax; check ... Error number : 1064". This is obviously because the OXID multibyte functions are not used in this tool. | ||||
Additional Information | http://forum.oxid-esales.com/showthread.php?t=21572#post137352 | ||||
Tags | SQL, UTF-8 | ||||
Theme | Not defined | ||||
Browser | All | ||||
PHP Version | Not defined | ||||
Database Version | Not defined | ||||
|
I want to add some details: It not directly depends on the UTF-8 mode of the SQL-Data, but the HTML-Form of the service tool (which runs with UTF-8 in most cases). I've build a SQL test snippet which reproduces the error (the same with "ä", "ö", "ü"): INSERT IGNORE INTO oxcontents (oxid,oxloadid,oxtitle,oxcontent) VALUES('test','test','test','some text including "ß"...'); DELETE FROM oxcontents WHERE oxid='123test'; Both statements for their own are running fine, but together it gives an error because str_len() is counting wrong so that the ";" isn't correctly matched as a seperator for the statements I guess. |
|
This issue is not reproducable in the current version of OXID eShop |