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

eZ Oracle dbschema lib issue

    XMLWordPrintable

Details

    Description

      After installing Ez Oracle extension in eZ Publish 4.6, and running the sync_network and monitor cronjobs, when doing a database consistency check I get the following errors:

      The database is not consistent with the distribution database.
      To synchronize your database with the distribution setup, run the following SQL commands:
      DROP INDEX ezx_ezpnet_installation00014_i;
      CREATE INDEX ezx_ezpnet_installation00001_i ON ezx_ezpnet_installation ( customer_id );
      DROP INDEX ezx_ezpnet_mon_result_f00015_i;
      CREATE INDEX ezx_ezpnet_mon_result_f00002_i ON ezx_ezpnet_mon_result ( finnished );
      ALTER TABLE ezstarrating MODIFY (contentobject_attribute_id INTEGER DEFAULT 0);
      ALTER TABLE ezstarrating MODIFY (contentobject_id INTEGER DEFAULT 0);
      ALTER TABLE ezstarrating MODIFY (rating_average FLOAT DEFAULT 0);
      ALTER TABLE ezstarrating MODIFY (rating_count INTEGER DEFAULT 0);
      ALTER TABLE ezstarrating_data MODIFY (contentobject_attribute_id INTEGER DEFAULT 0);
      ALTER TABLE ezstarrating_data MODIFY (contentobject_id INTEGER DEFAULT 0);
      ALTER TABLE ezstarrating_data MODIFY (created_at INTEGER DEFAULT 0);
      ALTER TABLE ezstarrating_data MODIFY (rating FLOAT DEFAULT 0);
      ALTER TABLE ezstarrating_data MODIFY (session_key VARCHAR2(32) NOT NULL);
      ALTER TABLE ezstarrating_data MODIFY (user_id INTEGER DEFAULT 0);
      ALTER TABLE ezm_block MODIFY (node_id INTEGER DEFAULT 0);
      ALTER TABLE ezm_block MODIFY (zone_id CHAR(32) NOT NULL);
      ALTER TABLE ezm_pool MODIFY (node_id INTEGER DEFAULT 0);
      ALTER TABLE ezm_pool MODIFY (object_id INTEGER DEFAULT 0);

      Steps to reproduce
      1. Clean installation of eZ Publish 4.6
      2. Register in eZ Network
      3. Install ezoracle extension
      4. Run sync_network and monitor cronjobs
      
      

      Attachments

        Activity

          People

            bd bd
            pedro.resende pedro.resende
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: