0003260: No config values displayed in admin after update from 4.4.x to 4.5.x as collation mixes in SQL joins. - OXID eShop bugtrack

ID	Project	Category	View Status	Date Submitted	Last Update

0003260	OXID eShop (all versions)	4. ------ eShop Core -------	public	2011-09-21 12:07	2012-12-10 13:42

Reporter	wanis	Assigned To
Priority	high	Severity	crash	Reproducibility	always
Status	resolved	Resolution	fixed
Product Version	4.5.2 revision 38481
Fixed in Version	4.5.3 revision 39087

Summary	0003260: No config values displayed in admin after update from 4.4.x to 4.5.x as collation mixes in SQL joins.
Description	on 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 Information	For 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)
Tags	No tags attached.

Theme	Both
Browser	All
PHP Version	any
Database Version	any