Forums / Install & configuration / upgrade database problem
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.0rc1ALTER 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
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.