Upgrade path from 4.0.1 to 4.3

Wednesday 25 August 2010 1:42:23 am

Hi

Would anyone be able to advise me as to the simplest upgrade path to move from version 4.0.1 to version 4.3

Thanks in advance

Wednesday 25 August 2010 2:06:56 pm

I think you can still use my direct upgrade statements to update your ez 4.0.1 to 4.3.0, if you add the following sql statements and run the following php-script. I got the following information from the update/*/4.3 folders in ezpublish 4.3.0 installation package.

SQL-Scripts

SET storage_engine=InnoDB;
UPDATE ezsite_data SET value='4.3.0' WHERE name='ezpublish-version';
UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';


ALTER TABLE ezrss_export_item ADD COLUMN enclosure VARCHAR( 255 ) NULL;
ALTER TABLE ezcontentclass ADD COLUMN serialized_description_list longtext NULL;
ALTER TABLE ezcontentclass_attribute ADD COLUMN serialized_data_text longtext NULL;
ALTER TABLE ezcontentclass_attribute ADD COLUMN serialized_description_list longtext NULL;
ALTER TABLE ezcontentclass_attribute ADD COLUMN category VARCHAR( 25 ) NOT NULL default '';


CREATE TABLE ezscheduled_script (
  id int(11) NOT NULL auto_increment,
  process_id int(11) NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  command varchar(255) NOT NULL default '',
  last_report_timestamp int(11) NOT NULL default '0',
  progress int(3) default '0',
  user_id int(11) NOT NULL default '0',
  PRIMARY KEY (id),
  KEY ezscheduled_script_timestamp (last_report_timestamp)
);

php-Script to be run afterwards:

 update/common/scripts/4.3/updatenodeassignment.php

But of course you are free to update from 4.0.x to 4.2 using the given update mchanism explained in the script and then update to 4.3.0.
Or you may update as Robin suggested: incremental, step by step...
But whatever solution you might prefer: don't forget to backup all your data before updating anything and try to test it on your development-server first.

cheers,

chris

edited sql-code, pasted some html-font-tags in it m(
Remember: this is untested, as i don't have an 4.0.x at hand right now. But theoretically it should work because doing the single-step-updates (which is the officially/supposed way to do it) take exactly the same steps.

edit #2: and again this comment-wysiwyg-thingy is playing mad with me...

Hannover, Germany
eZ-Certified http://auth.ez.no/certification/verify/395613

Thursday 26 August 2010 3:45:52 am

Adam,

Anders Berre is following the steps he just posted himself as well, just so you know :)

-- 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