View Issue Details

IDProjectCategoryView StatusLast Update
0005592OXID eShop (all versions)7. --- Other tools --------------public2017-04-04 14:31
Reportermarco_steinhaeuser 
PrioritynormalSeverityminorReproducibilityalways
Status confirmedResolutionopen 
Product Version4.8.2 / 5.1.2 
Target VersionFixed in Version 
Summary0005592: SQL importer doesn't work correctly when parsing UTF-8
DescriptionWhen 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 Informationhttp://forum.oxid-esales.com/showthread.php?t=21572#post137352
TagsSQL, UTF-8
ThemeNot defined
BrowserAll
PHP VersionNot defined
MySQL VersionNot defined

Activities

Mitmacher

2014-01-07 18:50

reporter   ~0009387

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.