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

sql script fails during installation

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • None
    • None
    • None
    • Version: 3.6
      PHP Version: 4.3.11
      Webserver: Apache 2
      Database: Mysql 4.1

    Description

      During the installation of the extension, the sql script sql/newsletter.sql fails, with this error.

      ERROR 1171 at line 42: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

      Changing the definition of the version_status field in the ezxsubscription table creation instruction, fixes the problem

      CREATE TABLE ezxsubscription (
      id int(11) NOT NULL auto_increment,
      version_status int(11) default '0',
      subscriptionlist_id int(11) default '0',
      ...

      becomes

      CREATE TABLE ezxsubscription (
      id int(11) NOT NULL auto_increment,
      version_status int(11) NOT NULL default '0',
      subscriptionlist_id int(11) default '0',
      ...

      Attachments

        Activity

          People

            unknown unknown
            ghige ghige
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: