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
|