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

Database Check Failed after clean Ez Publish 4.6 installation with Oracle

    XMLWordPrintable

    Details

      Description

      After making a clean installation of eZ Publish 4.6, with Oracle and Service Portal I get the following in the Database Consistency Check:

      The database is not consistent with the distribution database.

      To synchronize your database with the distribution setup, run the following SQL commands:

      CREATE TABLE ezstarrating (
      contentobject_attribute_id INTEGER DEFAULT 0 NOT NULL,
      contentobject_id INTEGER DEFAULT 0 NOT NULL,
      rating_average FLOAT DEFAULT 0 NOT NULL,
      rating_count INTEGER DEFAULT 0 NOT NULL,
      PRIMARY KEY ( contentobject_id, contentobject_attribute_id )
      );

      CREATE SEQUENCE s_starrating_data;

      CREATE TABLE ezstarrating_data (
      contentobject_attribute_id INTEGER DEFAULT 0 NOT NULL,
      contentobject_id INTEGER DEFAULT 0 NOT NULL,
      created_at INTEGER DEFAULT 0 NOT NULL,
      id INTEGER NOT NULL,
      rating FLOAT DEFAULT 0 NOT NULL,
      session_key VARCHAR2(32) NOT NULL,
      user_id INTEGER DEFAULT 0 NOT NULL,
      PRIMARY KEY ( id )
      );

      CREATE OR REPLACE TRIGGER ezstarrating_data_id_tr
      BEFORE INSERT ON ezstarrating_data FOR EACH ROW WHEN (new.id IS NULL)
      BEGIN
      SELECT s_starrating_data.nextval INTO :new.id FROM dual;
      END;
      /

      CREATE INDEX contentobject_id_co_attr_id ON ezstarrating_data ( contentobject_id, contentobject_attribute_id );

      CREATE INDEX user_id_session_key ON ezstarrating_data ( user_id, session_key );

      CREATE TABLE ezgmaplocation (
      address VARCHAR2(150),
      contentobject_attribute_id INTEGER DEFAULT 0 NOT NULL,
      contentobject_version INTEGER DEFAULT 0 NOT NULL,
      latitude FLOAT DEFAULT 0 NOT NULL,
      longitude FLOAT DEFAULT 0 NOT NULL,
      PRIMARY KEY ( contentobject_attribute_id, contentobject_version )
      );

      CREATE INDEX latitude_longitude_key ON ezgmaplocation ( latitude, longitude );

      Steps to reproduce
      1. Make a clean installation of Ez Publish 4.6
      2. Activate the EzOracle extension, by adding ActiveExtensions[]=ezoracle in site.ini.append.php
      3. Run ./extension/ezoracle/bin/shell/ora-initialize.sh
      4. Add to site.ini.append.php
      
      ##################################
      [DatabaseSettings]
      DatabaseImplementation=ezoracle
      User=<user>
      Password=<password>
      Database=<instance>
      ##################################
      
      5. Register in Service Portal
      6. Run Sync_Network cronjob
      7. Run Monitor cronjob
      8. Make a Database Consistency Check
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              vl Vidar Langseid
              Reporter:
              pedro.resende Pedro Resende
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: