View Issue Details

IDProjectCategoryView StatusLast Update
0002803OXID eShop (all versions)2. ----- eShop backend (admin) -----public2011-07-29 13:17
Reportersventietje 
PrioritynormalSeveritytrivialReproducibilityalways
Status resolvedResolutionfixed 
PlatformLinuxOSSLESOS Version11-SP1
Product Version4.5.0 revision 34568 
Target VersionFixed in Version4.5.1 revision 38045 
Summary0002803: MySQL 5.5 Query Syntax Error when executing dynexportbase.php -> Reason TYPE=HEAP
Descriptiondynexportbase.php creates his own temporary table with the following query:
CREATE TABLE if not exists tmp_5ec7ac6c368cd88d61614b22bc95ef3 ( oxid char(32) NOT NULL default '' ) TYPE=HEAP DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;

on mysql 5.5 you`ll receive an error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=HEAP DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci' at line 1"

if you replace TYPE=HEAP with ENGINE=HEAP, it will work fine:

CREATE TABLE if not exists tmp_5ec7ac6c368cd88d61614b22bc95ef3 ( oxid char(32) NOT NULL default '' ) ENGINE=HEAP DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;
TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
Database Version5.5

Relationships

has duplicate 0003049 closeddainius.bigelis dynexportbase.php not compatible with mysql 5.5 

Activities

birute_meilutyte

2011-05-17 14:01

reporter   ~0004602

@developers: check from source code side if such issue still exist and if offered solution is correct