Details
-
Bug
-
Resolution: Fixed
-
High
-
4.7.0-dev
-
None
-
Operating System: Debian 6.0
PHP Version: PHP 5.3.3-7+squeeze3 with Suhosin-Patch
Database and version: Posgres 8.4.8
Browser (and version): Any
Description
After making a clean installation of eZ Publish 4.6, in Postgres, and upgrading to eZ Publish 4.7 rc1 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:
ALTER TABLE ONLY ezpending_actions ADD CONSTRAINT ezpending_actions_pkey PRIMARY KEY ( id );
ALTER TABLE ezx_ezpnet_module_branch ADD COLUMN branch_id integer;
ALTER TABLE ezx_ezpnet_module_branch ALTER branch_id SET DEFAULT 0 ;
ALTER TABLE ezx_ezpnet_module_branch ALTER branch_id SET NOT NULL ;
ALTER TABLE ezstarrating RENAME COLUMN rating_average TO rating_average_tmp;
ALTER TABLE ezstarrating ADD COLUMN rating_average real;
ALTER TABLE ezstarrating ALTER rating_average SET DEFAULT 0::real ;
ALTER TABLE ezstarrating ALTER rating_average SET NOT NULL ;
UPDATE ezstarrating SET rating_average=rating_average_tmp;
ALTER TABLE ezstarrating DROP COLUMN rating_average_tmp;
ALTER TABLE ezstarrating_data RENAME COLUMN rating TO rating_tmp;
ALTER TABLE ezstarrating_data ADD COLUMN rating real;
ALTER TABLE ezstarrating_data ALTER rating SET DEFAULT 0::real ;
ALTER TABLE ezstarrating_data ALTER rating SET NOT NULL ;
UPDATE ezstarrating_data SET rating=rating_tmp;
ALTER TABLE ezstarrating_data DROP COLUMN rating_tmp;
Steps to reproduce
1. Make a clean installation of Ez Publish 4.6 2. Register in Service Portal 3. Run Sync_Network cronjob 4. Run Monitor cronjob 5. Upgrade to eZ Publish 4.7 rc1 6. Run Sync_Network cronjob 7. Run Monitor cronjob 8. Make a Database Consistency Check