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

SQL schema for ezxmlexport extensions does not work anymore (in mysql)

    XMLWordPrintable

    Details

      Description

      Hi

      When importing the .dba file for ezxmlexport in mysql I now get this error:

      [ Mar 04 2010 15:26:25 ] [] eZMySQLDB:
      Query 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 'NOT NULL DEFAULT '',
        PRIMARY KEY ( id )
      ) ENGINE=InnoDB' at line 5. Query: CREATE TABLE ezxmlexport_customers (
        ftp_target text NOT NULL,
        id int(11) NOT NULL AUTO_INCREMENT,
        name varchar(200) NOT NULL DEFAULT '',
        slicing_mode enum NOT NULL DEFAULT '',
        PRIMARY KEY ( id )
      ) ENGINE=InnoDB
      

      I guess this has is now broken, either because of changes to the schema, or regressions caused by other schema fixes.

      PS:
      Testing on both 4.3.0beta1, and on latest snapshot.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              qwix Jérôme Renard
              Reporter:
              vl Vidar Langseid
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: