View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002803 | OXID eShop (all versions) | 2. ----- eShop backend (admin) ----- | public | 2011-04-28 17:32 | 2011-07-29 13:17 |
| Reporter | sventietje | Assigned To | |||
| Priority | normal | Severity | trivial | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | Linux | OS | SLES | OS Version | 11-SP1 |
| Product Version | 4.5.0 revision 34568 | ||||
| Fixed in Version | 4.5.1 revision 38045 | ||||
| Summary | 0002803: MySQL 5.5 Query Syntax Error when executing dynexportbase.php -> Reason TYPE=HEAP | ||||
| Description | dynexportbase.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; | ||||
| Tags | No tags attached. | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | 5.5 | ||||
| has duplicate | 0003049 | closed | dainius.bigelis | dynexportbase.php not compatible with mysql 5.5 |
