upgrade database problem

Author Message

Victor Starkov

Friday 24 December 2004 8:54:54 pm

While upgrading ezpublish 3.4-3.5 database returned error on script

dbupdate-3.5.0beta1-to-3.5.0rc1.sql

Anything wrong with sql server?
--------
SQL-query:

-- 3.5.0beta1 to 3.5.0rc1
ALTER TABLE ezrole ADD COLUMN is_new integer NOT NULL default 0

sever reply
#1060 - Duplicate column name 'is_new'

or

ALTER TABLE ezcontentobject_tree ADD INDEX ezcontentobject_tree_path_ident( path_identification_string )

reply:
#1170 - BLOB column 'path_identification_string' used in key specification without a key length

Victor Starkov

Friday 24 December 2004 9:16:35 pm

then I run "check database consistency". System said that database was not consistent. When running recommended script returned error again.

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