0003287: Empty "Modules" textarea in Admin parameters - OXID eShop bugtrack

ID	Project	Category	View Status	Date Submitted	Last Update

0003287	OXID eShop (all versions)	2. ----- eShop backend (admin) -----	public	2011-10-03 06:54	2011-10-05 10:53

Reporter	avenger	Assigned To
Priority	high	Severity	crash	Reproducibility	always
Status	closed	Resolution	duplicate
Product Version	4.5.2 revision 38481

Summary	0003287: Empty "Modules" textarea in Admin parameters
Description	The "Modules" textarea in admin parameters entry was empty.
Additional Information	After 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;
Tags	No tags attached.

Theme	Both
Browser	All
PHP Version	any
Database Version	any