View Issue Details

IDProjectCategoryView StatusLast Update
0003260OXID eShop (all versions)4. ------ eShop Core -------public2012-12-10 13:42
Reporterwanis Assigned To 
PriorityhighSeveritycrashReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.5.2 revision 38481 
Fixed in Version4.5.3 revision 39087 
Summary0003260: No config values displayed in admin after update from 4.4.x to 4.5.x as collation mixes in SQL joins.
Descriptionon oxid 4.5.x oxConfig::_loadConfVars() there is changed select which uses joining oxconfig table with oxconfigdisplay:
...
  from
    oxconfig as cfg
    left join oxconfigdisplay as disp
      on cfg.oxmodule=disp.oxcfgmodule
      and cfg.oxvarname=disp.oxcfgvarname
...
So these columns should match collations. From old oxid databases, then importing and exporting back, collation fixed by first export, and then new tables are creating, they creates in different collation then the first ones.

My suggestion is to fix the collation on these columns to latin1_general_ci, so there will be no collation mixes between version/server changes.

Problem also noticed in https://bugs.oxid-esales.com/view.php?id=2997
Additional InformationFor existing/affected systems these SQL's will fix it:

ALTER TABLE `oxconfigdisplay` CHANGE `OXCFGMODULE` `OXCFGMODULE` VARCHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
CHANGE `OXCFGVARNAME` `OXCFGVARNAME` CHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '';

ALTER TABLE `oxconfig` CHANGE `OXMODULE` `OXMODULE` VARCHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
CHANGE `OXVARNAME` `OXVARNAME` CHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '';


Affected:
/setup/sql/database.sql ("CREATE TABLE `oxconfig`" and "CREATE TABLE `oxconfigdisplay`")
/updateApp/updates/sql/34028.sql ("CREATE TABLE `oxconfigdisplay`" and alter oxconfig missing)
TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Relationships

has duplicate 0002997 closeddainius.bigelis Errors within oxconfig, oxconfigdisplay 
has duplicate 0003287 closeddainius.bigelis Empty "Modules" textarea in Admin parameters 

Activities

There are no notes attached to this issue.