|
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
|