View Issue Details

IDProjectCategoryView StatusLast Update
0003287OXID eShop (all versions)2. ----- eShop backend (admin) -----public2011-10-05 10:53
Reporteravenger Assigned To 
PriorityhighSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
Product Version4.5.2 revision 38481 
Summary0003287: Empty "Modules" textarea in Admin parameters
DescriptionThe "Modules" textarea in admin parameters entry was empty.
Additional InformationAfter debugging the issue I found, that the reason was different collations of the "oxconfig"- and "oxconfigdisplay"-tables, leading to a "Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='" error in the SQL-statement to read the configuration parameters (line 202 in admin/shop_config.php).

Looking at the database If found, that the "oxconfig"-table had a "latin1_general_ci" collation, whereas the "oxconfigdisplay"-table had a "latin1_swedish_ci" collation.

After forcing the "oxconfigdisplay"-table to the same format as the "oxconfig"-table, the query was successfully finished.

The update sql for creating the "oxconfigdisplay"-table in 34028.sql should have explicitely specified the same collation and characterset parameters used for the "oxconfig"-table, to avoid this problem.

Currently it leaves too much to the database-servers default values.

CREATE TABLE `oxconfigdisplay` (
  `OXID` char(32) character set latin1 collate latin1_general_ci NOT NULL,
  `OXCFGMODULE` varchar(32) NOT NULL default '',
  `OXCFGVARNAME` char(32) NOT NULL default '',

  `OXGROUPING` varchar(255) NOT NULL default '',
  `OXVARCONSTRAINT` varchar(255) NOT NULL default '',
  `OXPOS` int NOT NULL default 0,
  PRIMARY KEY (`OXID`),
  KEY `list` (`OXCFGMODULE`, `OXCFGVARNAME`)
) ENGINE=MyISAM;

TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Relationships

duplicate of 0003260 resolvedarvydas_vapsva No config values displayed in admin after update from 4.4.x to 4.5.x as collation mixes in SQL joins. 

Activities

svetlana

2011-10-05 10:47

reporter   ~0005288

@developers, please investigate it

dainius.bigelis

2011-10-05 10:52

reporter   ~0005290

Duplicate of 0003260.