View Issue Details

IDProjectCategoryView StatusLast Update
0006038OXID eShop (all versions)4.01. Database handlingpublic2016-01-15 10:05
Status resolvedResolutionfixed 
Product Version4.9.3 / 5.2.3 
Target VersionFixed in Version4.8.10 / 5.1.10 
Summary0006038: Admin backend allows language tags with a dash character, causes shop to crash
DescriptionWhen creating a new language with a dash, e.g. "zh-cn" oder "zh-tw" for different variants of the Chinese language, the shop tries to create database views containing a dash character:

[...] for the right syntax to use near '-cn' at line 1] in EXECUTE (DROP VIEW IF EXISTS oxv_oxactions_zh-cn, [...]

This causes the shop to stop working.
Steps To Reproduce- Create a new entry for a language and use a dash in it's short tag name.
- Rebuild the database views.
- Open a subpage of the shop. Cannot be reproduced on the start page.
Additional InformationMySQL Server version is: 5.5.41
PHP version is: 5.4.37
TagsNo tags attached.
PHP VersionNot defined
Database Version5.5


There are no notes attached to this issue.