Details
-
Bug
-
Resolution: Fixed
-
Critical
-
5.1.0beta1
-
None
-
RHEL 6.4
PHP: 5.3.3
Mysql: 5.1.61
Description
After upgrading a ezp5.0 (ezflow) to ezp5.1 the following error is present in upgrade database check
Mysql:
The database is not consistent with the distribution database.
To synchronize your database with the distribution setup, run the following SQL commands:
ALTER TABLE eznode_assignment CHANGE COLUMN remote_id remote_id varchar(100) NOT NULL DEFAULT '0';
Postgres:
ALTER TABLE eznode_assignment RENAME COLUMN remote_id TO remote_id_tmp;
ALTER TABLE eznode_assignment ADD COLUMN remote_id character varying(100);
ALTER TABLE eznode_assignment ALTER remote_id SET DEFAULT '0'::character varying ;
ALTER TABLE eznode_assignment ALTER remote_id SET NOT NULL ;
UPDATE eznode_assignment SET remote_id=remote_id_tmp;
ALTER TABLE eznode_assignment DROP COLUMN remote_id_tmp;