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.
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0002 secs