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

CJW Newsletter: systemupgrade check db output produces wrong sql

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Medium Medium
    • None
    • extension/CJW Newsletter beta
    • Legacy > Deprecated extensions
    • None

    Description

      If you enable cjw_newsletter and go to the admin system db upgradecheck you will get
      some SQL which is not valid to create the nessesary db tables.

      The problem was that the tinyint field has as default value '' instead of 0

      To fix this the schema.sql has to be updated + share/db_schema.dba

      You have to perform an sql update to prior versions

      ALTER TABLE cjwnl_edition_send CHANGE COLUMN status status tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE cjwnl_edition_send_item CHANGE COLUMN output_format_id output_format_id tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE cjwnl_edition_send_item CHANGE COLUMN status status tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE cjwnl_mailbox CHANGE COLUMN is_ssl is_ssl tinyint(1) NOT NULL DEFAULT '0';

      Attachments

        Activity

          People

            unknown unknown
            4d91e976-d41f-487b-ae85-f7216bd06dac@accounts.ibexa.co Felix Woldt
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: