Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.6.0beta1
-
None
-
Operating System: Red Hat 6.1 Enterprise
PHP Version: 5.3.3
Database and version: Oracle 11g
Browser (and version): any
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
Issue Links
- relates to
-
EZP-18193 oracle: convert ezdbschema-mysql2oracle.sh to a php script
- Closed