Forums / Install & configuration / upgrade database problem

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

upgrade database problem

Previous topic

Next topic

Author	Message
Victor Starkov	Friday 24 December 2004 8:54:54 pm While upgrading Exponential 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.

Author

Message

Friday 24 December 2004 8:54:54 pm

While upgrading Exponential 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'

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.