3.5 upgradeproblem (from beta1 to rc1 )

Author Message

Felix Laate

Wednesday 24 November 2004 5:41:39 am

Hi all!

Just upgraded a site running on 3.5.0beta1 to 3.5.0rc1.

After running "Database consistency check" in the admin interface I get this output:

<i>
The database is not consistent with the distribution database.
To synchronize your database with the distribution setup, run the following SQL commands:

ALTER TABLE ezpdf_export ADD COLUMN version int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezpdf_export DROP PRIMARY KEY;
ALTER TABLE ezpdf_export ADD PRIMARY KEY ( id, version );
ALTER TABLE ezproductcollection_item ADD COLUMN name varchar(255) NOT NULL DEFAULT '';
ALTER TABLE ezrole ADD COLUMN is_new int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezrss_export CHANGE COLUMN status status int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezrss_export DROP PRIMARY KEY;
ALTER TABLE ezrss_export ADD PRIMARY KEY ( id, status );
ALTER TABLE ezrss_export_item ADD COLUMN status int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezrss_export_item DROP PRIMARY KEY;
ALTER TABLE ezrss_export_item ADD PRIMARY KEY ( id, status );
ALTER TABLE ezrss_import CHANGE COLUMN status status int(11) NOT NULL DEFAULT '0';
ALTER TABLE ezrss_import DROP PRIMARY KEY;
ALTER TABLE ezrss_import ADD PRIMARY KEY ( id, status );
ALTER TABLE ezsearch_word DROP INDEX ezsearch_word;
ALTER TABLE ezsearch_word ADD INDEX ezsearch_word_word_i ( word );
</i>

Fair enough! But when I try to run the sql-commands I get errors speaking about e.g. duplicate columns etc.

How come?

Felix

Publlic Relations Manager
Greater Stavanger
www.greaterstavanger.com

Frederik Holljen

Wednesday 24 November 2004 5:45:50 am

Sounds like a bug in the SQL diff tool. Please file a bug report.

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.