Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-20600

Mysql5.5 : Importing the ezsurvey tables using ezsurvey setup wizard ends with database transaction error

    XMLWordPrintable

    Details

      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.
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Joao.Pingo-obsolete@ez.no Joao Pingo (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 15 minutes
                15m