Details
-
Bug
-
Resolution: Fixed
-
High
-
5.1-dev
-
None
-
Debian 6
PHP 5.3.22
Mysql 5.5.30
Description
Importing the database schema for ezsurvey in admin interface, using mysql 5.5 generates the following fatal error:
Fatal error: A database transaction in eZ Publish failed. The current execution was stopped to prevent further problems. You should contact the System Administrator of this site with the information on this page. The current transaction ID is TRANSID-5289a3e595a594c5633bd99365ce7ecd and has been logged. Please include the transaction ID and the current URL when contacting the system administrator.
The following information is present in ezpublish debug
Error: eZMySQLiDB Mar 20 2013 15:05:00 Query error (1064): 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 = innodb' at line 1. Query: ALTER TABLE ezsurvey TYPE = innodb Error: eZDBInterface::commit TRANSID-894966ec7a643653ecbd09b3ff7620e0 Mar 20 2013 15:05:00 Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-894966ec7a643653ecbd09b3ff7620e0.