Forums / General / Upgrade check
Kristoffer Raun
Tuesday 13 April 2010 9:49:46 am
Hi
I have upgraded my site from 3.8 to 4.3 (took a while....) and have made a upgrade check. File consistency is ok, however, the db gives the following error, and provides a fix w. a sql query. However this fix does not help. Any suggestions on how to solve this or which upgrade script i have missed
ALTER TABLE ezcontentclass CHANGE COLUMN contentobject_name contentobject_name varchar(255) DEFAULT NULL; ALTER TABLE ezcontentclass CHANGE COLUMN url_alias_name url_alias_name varchar(255) DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_float1 data_float1 float DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_float2 data_float2 float DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_float3 data_float3 float DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_float4 data_float4 float DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_int1 data_int1 int(11) DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_int2 data_int2 int(11) DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_int3 data_int3 int(11) DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_int4 data_int4 int(11) DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_text1 data_text1 varchar(50) DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_text2 data_text2 varchar(50) DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_text3 data_text3 varchar(50) DEFAULT NULL; ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_text4 data_text4 varchar(255) DEFAULT NULL; ALTER TABLE ezcontentclass_classgroup CHANGE COLUMN group_name group_name varchar(255) DEFAULT NULL; ALTER TABLE ezcontentclassgroup CHANGE COLUMN name name varchar(255) DEFAULT NULL; ALTER TABLE ezcontentobject CHANGE COLUMN current_version current_version int(11) DEFAULT NULL; ALTER TABLE ezcontentobject CHANGE COLUMN is_published is_published int(11) DEFAULT NULL; ALTER TABLE ezcontentobject CHANGE COLUMN name name varchar(255) DEFAULT NULL; ALTER TABLE ezcontentobject CHANGE COLUMN remote_id remote_id varchar(100) DEFAULT NULL; ALTER TABLE ezcontentobject_attribute CHANGE COLUMN data_float data_float float DEFAULT NULL; ALTER TABLE ezcontentobject_attribute CHANGE COLUMN data_int data_int int(11) DEFAULT NULL; ALTER TABLE ezcontentobject_name CHANGE COLUMN name name varchar(255) DEFAULT NULL; ALTER TABLE ezcontentobject_name CHANGE COLUMN real_translation real_translation varchar(20) DEFAULT NULL; ALTER TABLE ezcontentobject_trash CHANGE COLUMN contentobject_id contentobject_id int(11) DEFAULT NULL; ALTER TABLE ezcontentobject_trash CHANGE COLUMN contentobject_version contentobject_version int(11) DEFAULT NULL; ALTER TABLE ezcontentobject_trash CHANGE COLUMN main_node_id main_node_id int(11) DEFAULT NULL; ALTER TABLE ezcontentobject_tree CHANGE COLUMN contentobject_id contentobject_id int(11) DEFAULT NULL; ALTER TABLE ezcontentobject_tree CHANGE COLUMN contentobject_is_published contentobject_is_published int(11) DEFAULT NULL; ALTER TABLE ezcontentobject_tree CHANGE COLUMN contentobject_version contentobject_version int(11) DEFAULT NULL; ALTER TABLE ezcontentobject_tree CHANGE COLUMN main_node_id main_node_id int(11) DEFAULT NULL; ALTER TABLE ezcontentobject_version CHANGE COLUMN contentobject_id contentobject_id int(11) DEFAULT NULL; ALTER TABLE ezdiscountsubrule CHANGE COLUMN discount_percent discount_percent float DEFAULT NULL; ALTER TABLE ezdiscountsubrule CHANGE COLUMN limitation limitation char(1) DEFAULT NULL; ALTER TABLE ezinfocollection CHANGE COLUMN user_identifier user_identifier varchar(34) DEFAULT NULL; ALTER TABLE ezinfocollection_attribute CHANGE COLUMN contentobject_attribute_id contentobject_attribute_id int(11) DEFAULT NULL; ALTER TABLE ezinfocollection_attribute CHANGE COLUMN contentobject_id contentobject_id int(11) DEFAULT NULL; ALTER TABLE ezinfocollection_attribute CHANGE COLUMN data_float data_float float DEFAULT NULL; ALTER TABLE ezinfocollection_attribute CHANGE COLUMN data_int data_int int(11) DEFAULT NULL; ALTER TABLE ezkeyword CHANGE COLUMN keyword keyword varchar(255) DEFAULT NULL; ALTER TABLE ezmedia CHANGE COLUMN controls controls varchar(50) DEFAULT NULL; ALTER TABLE ezmedia CHANGE COLUMN height height int(11) DEFAULT NULL; ALTER TABLE ezmedia CHANGE COLUMN pluginspage pluginspage varchar(255) DEFAULT NULL; ALTER TABLE ezmedia CHANGE COLUMN quality quality varchar(50) DEFAULT NULL; ALTER TABLE ezmedia CHANGE COLUMN width width int(11) DEFAULT NULL; ALTER TABLE ezmodule_run CHANGE COLUMN function_name function_name varchar(255) DEFAULT NULL; ALTER TABLE ezmodule_run CHANGE COLUMN module_name module_name varchar(255) DEFAULT NULL; ALTER TABLE ezmodule_run CHANGE COLUMN workflow_process_id workflow_process_id int(11) DEFAULT NULL; ALTER TABLE eznode_assignment CHANGE COLUMN contentobject_id contentobject_id int(11) DEFAULT NULL; ALTER TABLE eznode_assignment CHANGE COLUMN contentobject_version contentobject_version int(11) DEFAULT NULL; ALTER TABLE eznode_assignment CHANGE COLUMN parent_node parent_node int(11) DEFAULT NULL; ALTER TABLE ezorder_item CHANGE COLUMN description description varchar(255) DEFAULT NULL; ALTER TABLE ezorder_item CHANGE COLUMN price price float DEFAULT NULL; ALTER TABLE ezorder_item CHANGE COLUMN type type varchar(30) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN created created int(11) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN creator_id creator_id int(11) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN export_classes export_classes varchar(255) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN export_structure export_structure varchar(255) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN modified modified int(11) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN modifier_id modifier_id int(11) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN pdf_filename pdf_filename varchar(255) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN show_frontpage show_frontpage int(11) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN site_access site_access varchar(255) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN source_node_id source_node_id int(11) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN status status int(11) DEFAULT NULL; ALTER TABLE ezpdf_export CHANGE COLUMN title title varchar(255) DEFAULT NULL; ALTER TABLE ezpending_actions CHANGE COLUMN created created int(11) DEFAULT NULL; ALTER TABLE ezpolicy CHANGE COLUMN function_name function_name varchar(255) DEFAULT NULL; ALTER TABLE ezpolicy CHANGE COLUMN module_name module_name varchar(255) DEFAULT NULL; ALTER TABLE ezpolicy CHANGE COLUMN role_id role_id int(11) DEFAULT NULL; ALTER TABLE ezpolicy_limitation CHANGE COLUMN policy_id policy_id int(11) DEFAULT NULL; ALTER TABLE ezpolicy_limitation_value CHANGE COLUMN limitation_id limitation_id int(11) DEFAULT NULL; ALTER TABLE ezpolicy_limitation_value CHANGE COLUMN value value varchar(255) DEFAULT NULL; ALTER TABLE ezpreferences CHANGE COLUMN name name varchar(100) DEFAULT NULL; ALTER TABLE ezpreferences CHANGE COLUMN value value varchar(100) DEFAULT NULL; ALTER TABLE ezproductcollection CHANGE COLUMN created created int(11) DEFAULT NULL; ALTER TABLE ezproductcollection_item CHANGE COLUMN discount discount float DEFAULT NULL; ALTER TABLE ezproductcollection_item CHANGE COLUMN is_vat_inc is_vat_inc int(11) DEFAULT NULL; ALTER TABLE ezproductcollection_item CHANGE COLUMN vat_value vat_value float DEFAULT NULL; ALTER TABLE ezproductcollection_item_opt CHANGE COLUMN object_attribute_id object_attribute_id int(11) DEFAULT NULL; ALTER TABLE ezrole CHANGE COLUMN value value char(1) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN access_url access_url varchar(255) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN active active int(11) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN created created int(11) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN creator_id creator_id int(11) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN image_id image_id int(11) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN modified modified int(11) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN modifier_id modifier_id int(11) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN node_id node_id int(11) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN rss_version rss_version varchar(255) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN site_access site_access varchar(255) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN title title varchar(255) DEFAULT NULL; ALTER TABLE ezrss_export CHANGE COLUMN url url varchar(255) DEFAULT NULL; ALTER TABLE ezrss_export_item CHANGE COLUMN category category varchar(255) DEFAULT NULL; ALTER TABLE ezrss_export_item CHANGE COLUMN class_id class_id int(11) DEFAULT NULL; ALTER TABLE ezrss_export_item CHANGE COLUMN description description varchar(255) DEFAULT NULL; ALTER TABLE ezrss_export_item CHANGE COLUMN enclosure enclosure varchar(255) DEFAULT NULL; ALTER TABLE ezrss_export_item CHANGE COLUMN rssexport_id rssexport_id int(11) DEFAULT NULL; ALTER TABLE ezrss_export_item CHANGE COLUMN source_node_id source_node_id int(11) DEFAULT NULL; ALTER TABLE ezrss_export_item CHANGE COLUMN title title varchar(255) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN active active int(11) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN class_description class_description varchar(255) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN class_id class_id int(11) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN class_title class_title varchar(255) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN class_url class_url varchar(255) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN created created int(11) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN creator_id creator_id int(11) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN destination_node_id destination_node_id int(11) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN modified modified int(11) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN modifier_id modifier_id int(11) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN name name varchar(255) DEFAULT NULL; ALTER TABLE ezrss_import CHANGE COLUMN object_owner_id object_owner_id int(11) DEFAULT NULL; ALTER TABLE ezsearch_search_phrase CHANGE COLUMN phrase phrase varchar(250) DEFAULT NULL; ALTER TABLE ezsearch_word CHANGE COLUMN word word varchar(150) DEFAULT NULL; ALTER TABLE ezsection CHANGE COLUMN locale locale varchar(255) DEFAULT NULL; ALTER TABLE ezsection CHANGE COLUMN name name varchar(255) DEFAULT NULL; ALTER TABLE eztrigger CHANGE COLUMN name name varchar(255) DEFAULT NULL; ALTER TABLE eztrigger CHANGE COLUMN workflow_id workflow_id int(11) DEFAULT NULL; ALTER TABLE ezurlalias CHANGE COLUMN source_md5 source_md5 varchar(32) DEFAULT NULL; ALTER TABLE ezuser CHANGE COLUMN password_hash password_hash varchar(50) DEFAULT NULL; ALTER TABLE ezuser_discountrule CHANGE COLUMN contentobject_id contentobject_id int(11) DEFAULT NULL; ALTER TABLE ezuser_discountrule CHANGE COLUMN discountrule_id discountrule_id int(11) DEFAULT NULL; ALTER TABLE ezuser_role CHANGE COLUMN contentobject_id contentobject_id int(11) DEFAULT NULL; ALTER TABLE ezuser_role CHANGE COLUMN role_id role_id int(11) DEFAULT NULL; ALTER TABLE ezuser_setting CHANGE COLUMN max_login max_login int(11) DEFAULT NULL; ALTER TABLE ezvattype CHANGE COLUMN percentage percentage float DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_int1 data_int1 int(11) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_int2 data_int2 int(11) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_int3 data_int3 int(11) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_int4 data_int4 int(11) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_text1 data_text1 varchar(255) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_text2 data_text2 varchar(255) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_text3 data_text3 varchar(255) DEFAULT NULL; ALTER TABLE ezworkflow_event CHANGE COLUMN data_text4 data_text4 varchar(255) DEFAULT NULL; ALTER TABLE ezworkflow_group_link CHANGE COLUMN group_name group_name varchar(255) DEFAULT NULL; ALTER TABLE ezworkflow_process CHANGE COLUMN activation_date activation_date int(11) DEFAULT NULL; ALTER TABLE ezworkflow_process CHANGE COLUMN event_state event_state int(11) DEFAULT NULL; ALTER TABLE ezworkflow_process CHANGE COLUMN memento_key memento_key varchar(32) DEFAULT NULL; ALTER TABLE ezworkflow_process CHANGE COLUMN status status int(11) DEFAULT NULL;
Thanks in advance
<i>If you can't describe what you are doing as a process, you don't know what you're doing.</i> W. Edwards Deming
Robin Muilwijk
Tuesday 13 April 2010 11:32:09 am
Hi Kristoffer,
Did you follow the upgrade guide(s), in most cases an SQL upgrade script needs to be run between upgrading versions. Maybe you missed one of those scripts? Might also be useful to mention which database engine you are on (Oracle, MySQL, PostgreSQL).
Regards Robin
Board member, eZ Publish Community Project Board - Member of the share.ez.no team - Key values: Openness and Innovation. LinkedIn: http://nl.linkedin.com/in/robinmuilwijk // Twitter: http://twitter.com/i_robin // Skype: robin.muilwijk
Tuesday 13 April 2010 12:07:03 pm
Hi Robin
Thank you for the input.
Yes i followed the upgrade guides, but I might have forgotten one as i indicated :-(
Can i run the upgrade scripts (sql queries) again without making the problem bigger?
Sorry for the mistake by not mentioning the database engine - I use MySQL w. innoDB.
I hope i can avoid to go through all of the upgrade steps - it took quite some time :-o
Mark Marsiglio
Wednesday 21 April 2010 3:34:28 pm
The upgrade check output should be in a form that you can run as a query in something like phpmyadmin to bring the database up to date. Did you say that would not work though? Can you verify that the script is being run, and if it returns any error messages from the query?
http://www.thinkcreative.com Turning Ideas Into Strategic Solutions
Wednesday 05 May 2010 12:39:14 pm
Thank you for the reply.
Yes i run the query in phpmyadmin, and the query is run without any errors.
When I make a new database check, i have the same output as stated above.
Thank for any help - I appriciate it a lot!
/Kristoffer