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

        Activity

          People

            qwix qwix
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: