View Issue Details

IDProjectCategoryView StatusLast Update
0006203OXID eShop (all versions)4.01. Database handlingpublic2015-07-28 09:17
Reportermantas.vaitkunas 
PrioritylowSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.9.0 / 5.2.0 
Target VersionFixed in Version4.9.6 / 5.2.6 
Summary0006203: sDefaultDatabaseConnection config option default value is not set
DescriptionConfig option sDefaultDatabaseConnection value should not be empty.

If mysql server default collation is utf8 and eShop has these config options: iUtfMode = '0';
sDefaultDatabaseConnection = '';
After eShop setup umlauts will be broken.
Steps To Reproduce1) Change MySQL defaults:
Edit /etc/mysql/my.cnf and add under [mysqld]:
collation_server=utf8_unicode_ci
character_set_server=utf8
Don't forget to restart mysql server.
3) Run shop setup (Do not use UTF-8 character encoding)
4) Check umlauts
Additional InformationPossible fix:
Change default value for config option sDefaultDatabaseConnection from:
$this->sDefaultDatabaseConnection = '';
to:
$this->sDefaultDatabaseConnection = 'latin1';
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
MySQL VersionNot defined

Relationships

child of 0002937 resolvedLinas Kukulskis Missing "SET NAMES latin1 " in function getDb() - file /core/oxdb.php