ez-publish-community-project-2013-09

Upgrade Notes

Upgrading from eZ Publish Community Project 2013.07 to 2013.09

Important Information Before You Start

• This is the 9th "eZ Publish 5" build, that comprises an eZ Publish 4.x build, under the 'ezpublish_legacy' folder, at the root of your eZ Publish 5 installation,
• The upgrade procedure below must be applied to the latter, then the normal installation procedure for the eZ Publish 5 stack must be followed, 
• Make sure to follow the Virtual Host based installation procedure in the latter to initiate the setup wizard.

Upgrading from 2013.07 to 2013.09

This section describes how to upgrade your existing eZ Publish Community Project 2013.07 installation to build 2013.09. Make sure that you have a working backup of the site before you do the actual upgrade, and make sure the installation you are performing the upgrade on is offline.

Important upgrade notes:

The procedure for upgrading from eZ Publish Community Project build 2013.07 to build 2013.09 consists of the following steps:

• Backing up the website
• Putting the website offline (optional)
• Upgrading the database
• Upgrading the distribution files to 2013.09
• Upgrading custom extensions
• Regenerate the autoload array for extensions
• Clearing the caches
• Putting the website online (optional)

Check for requirements

It is recommended to always verify the requirements for the new version of eZ Publish before attempting an upgrade. eZ Publish Community Project 2013.07 is compatible with PHP version 5.3.3 and above. So is eZ Publish Community Project 2013.09. For more information regarding system requirements check out "Requirements for doing a normal installation".

Step 1: Backing up the website

• Filesystem set: the extension and settings folders, plus any other folder where you have put your custom developments in (e.g. design/mydesign)
• Content set: the var/storage, var/<vardir>/storage folders, and a dump of the database (nb: for ezdb cluster mode, a dump of the storage database is needed instead of the storage folders; for ezdfs cluster mode both a dump of the storage database and a backup of the shared var folder on nfs)
• Optional: the complete installation directory of eZ Publish, except for the var directory and for the eZFind index directory. This is mandatory if you have customized the .htaccess or config.php files

Tip: if you have many user sessions, and the session data is stored in the database, it might be a good idea to remove all data from the session table before backing it up
Tip: in ezdb and ezdfs cluster modes, it is a good idea to clear all caches before dumping the storage database, as it is not easy to only backup storage and not caches

Step 2: Putting the website offline (optional)

This step is recommended but not mandatory

• Put the public website offline and set up a courtesy page to prevent end users from accessing the website while you upgrade. This involves generally modifying the webserver configuration. Make sure you have a different vhost available to access the public website using a private IP address or hostname during the upgrade process
• Disable execution of eZ Publish cronjobs

Step 4: Upgrading the database

MySQL

Run the following against your MySQL database :

<span>ALTER</span> <span>TABLE</span> ezcontent_language    <span>MODIFY</span> id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcontentclass    <span>MODIFY</span> initial_language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,    <span>MODIFY</span> language_mask BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcontentclass_name    <span>MODIFY</span> language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcontentobject    <span>MODIFY</span> initial_language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,    <span>MODIFY</span> language_mask BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcontentobject_name    <span>MODIFY</span> language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcontentobject_attribute    <span>MODIFY</span> language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcontentobject_version    <span>MODIFY</span> initial_language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,    <span>MODIFY</span> language_mask BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcobj_state    <span>MODIFY</span> default_language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,    <span>MODIFY</span> language_mask BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcobj_state_group    <span>MODIFY</span> default_language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,    <span>MODIFY</span> language_mask BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcobj_state_group_language    <span>MODIFY</span> language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,    <span>MODIFY</span> real_language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezcobj_state_language    <span>MODIFY</span> language_id BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>ALTER</span> <span>TABLE</span> ezurlalias_ml    <span>MODIFY</span> lang_mask BIGINT <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>; <span>-- Start ezp-21465 : Cleanup extra lines in the ezurl_object_link table</span><span>DROP</span> <span>TEMPORARY</span> <span>TABLE</span> <span>IF</span> <span>EXISTS</span> ezurl_object_link_temp ; <span>-- create a temporary table containing stale links</span><span>CREATE</span> <span>TEMPORARY</span> <span>TABLE</span> ezurl_object_link_temp<span>SELECT</span> <span>DISTINCT</span> contentobject_attribute_id, contentobject_attribute_version, url_id<span>FROM</span> ezurl_object_link <span>AS</span> T1 <span>JOIN</span> ezcontentobject_attribute <span>ON</span> T1.contentobject_attribute_id <span>=</span> ezcontentobject_attribute.id<span>WHERE</span> ezcontentobject_attribute.data_type_string <span>=</span> <span>"ezurl"</span><span>AND</span> T1.url_id <span><</span> ANY  <span>(</span><span>SELECT</span> <span>DISTINCT</span> T2.url_id  <span>FROM</span> ezurl_object_link T2  <span>WHERE</span> T1.url_id <span><</span> T2.url_id  <span>AND</span> T1.contentobject_attribute_id <span>=</span> T2.contentobject_attribute_id  <span>AND</span> T1.contentobject_attribute_version <span>=</span> T2.contentobject_attribute_version<span>)</span>; <span>SET</span> @OLD_SQL_SAFE_UPDATES<span>=</span>@@SQL_SAFE_UPDATES;<span>SET</span> SQL_SAFE_UPDATES<span>=</span><span>0</span>; <span>DELETE</span> ezurl_object_link.*<span>FROM</span> ezurl_object_link <span>JOIN</span> ezurl_object_link_temp <span>ON</span> ezurl_object_link.url_id <span>=</span> ezurl_object_link_temp.url_id<span>AND</span> ezurl_object_link.contentobject_attribute_id <span>=</span> ezurl_object_link_temp.contentobject_attribute_id<span>AND</span> ezurl_object_link.contentobject_attribute_version <span>=</span> ezurl_object_link_temp.contentobject_attribute_version; <span>SET</span> SQL_SAFE_UPDATES<span>=</span>@OLD_SQL_SAFE_UPDATES;<span>-- End ezp-21465</span> <span>-- Start EZP-21469</span><span>-- While using the public API, ezcontentobject.language_mask was not updated correctly,</span><span>-- the UPDATE statement below fixes that based on the language_mask of the current version.</span><span>UPDATE</span>    ezcontentobject <span>AS</span> o<span>INNER</span> <span>JOIN</span>    ezcontentobject_version <span>AS</span> v <span>ON</span> o.id <span>=</span> v.contentobject_id <span>AND</span> o.current_version <span>=</span> v.version<span>SET</span>    o.language_mask <span>=</span> <span>(</span>o.language_mask & <span>1</span><span>)</span> <span>|</span> <span>(</span>v.language_mask & ~<span>1</span><span>)</span>;<span>-- End EZP-21469</span> <span>-- Start EZP-21648:</span><span>-- Adding 'priority' and 'is_hidden' columns to the 'eznode_assignment' table</span><span>ALTER</span> <span>TABLE</span> eznode_assignment <span>ADD</span> <span>COLUMN</span> priority int<span>(</span><span>11</span><span>)</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>;<span>ALTER</span> <span>TABLE</span> eznode_assignment <span>ADD</span> <span>COLUMN</span> is_hidden int<span>(</span><span>11</span><span>)</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>;<span>-- End EZP-21648</span>

If you are running on DFS Cluster and MySQL, you will need to run the following in addition:

<span>CREATE</span> <span>TABLE</span> ezdfsfile_cache <span>(</span>  <span>`name`</span> text <span>NOT</span> <span>NULL</span>,  name_trunk text <span>NOT</span> <span>NULL</span>,  name_hash varchar<span>(</span><span>34</span><span>)</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span>,  datatype varchar<span>(</span><span>255</span><span>)</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'application/octet-stream'</span>,  scope varchar<span>(</span><span>25</span><span>)</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span>,  size bigint<span>(</span><span>20</span><span>)</span> <span>UNSIGNED</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,  mtime int<span>(</span><span>11</span><span>)</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,  expired tinyint<span>(</span><span>1</span><span>)</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'0'</span>,  <span>PRIMARY</span> <span>KEY</span> <span>(</span>name_hash<span>)</span>,  <span>KEY</span> ezdfsfile_name <span>(</span><span>`name`</span><span>(</span><span>250</span><span>)</span><span>)</span>,  <span>KEY</span> ezdfsfile_name_trunk <span>(</span>name_trunk<span>(</span><span>250</span><span>)</span><span>)</span>,  <span>KEY</span> ezdfsfile_mtime <span>(</span>mtime<span>)</span>,  <span>KEY</span> ezdfsfile_expired_name <span>(</span>expired,<span>`name`</span><span>(</span><span>250</span><span>)</span><span>)</span><span>)</span> ENGINE<span>=</span>InnoDB;

Postgresql

Run the following against your Postgresql database :

<span>ALTER</span> <span>TABLE</span> ezcontent_language    <span>ALTER</span> <span>COLUMN</span> id TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcontentclass    <span>ALTER</span> <span>COLUMN</span> initial_language_id TYPE BIGINT,    <span>ALTER</span> <span>COLUMN</span> language_mask TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcontentclass_name    <span>ALTER</span> <span>COLUMN</span> language_id TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcontentobject    <span>ALTER</span> <span>COLUMN</span> initial_language_id TYPE BIGINT,    <span>ALTER</span> <span>COLUMN</span> language_mask TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcontentobject_name    <span>ALTER</span> <span>COLUMN</span> language_id TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcontentobject_attribute    <span>ALTER</span> <span>COLUMN</span> language_id TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcontentobject_version    <span>ALTER</span> <span>COLUMN</span> initial_language_id TYPE BIGINT,    <span>ALTER</span> <span>COLUMN</span> language_mask TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcobj_state    <span>ALTER</span> <span>COLUMN</span> default_language_id TYPE BIGINT,    <span>ALTER</span> <span>COLUMN</span> language_mask TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcobj_state_group    <span>ALTER</span> <span>COLUMN</span> default_language_id TYPE BIGINT,    <span>ALTER</span> <span>COLUMN</span> language_mask TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcobj_state_group_language    <span>ALTER</span> <span>COLUMN</span> language_id TYPE BIGINT,    <span>ALTER</span> <span>COLUMN</span> real_language_id TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezcobj_state_language    <span>ALTER</span> <span>COLUMN</span> language_id TYPE BIGINT; <span>ALTER</span> <span>TABLE</span> ezurlalias_ml    <span>ALTER</span> <span>COLUMN</span> lang_mask TYPE BIGINT; <span>-- Start ezp-21465 : Cleanup extra lines in the ezurl_object_link table</span><span>DELETE</span><span>FROM</span> ezurl_object_link <span>AS</span> T1<span>WHERE</span>  T1.url_id <span><</span> ANY <span>(</span>  <span>SELECT</span> <span>DISTINCT</span> url_id  <span>FROM</span>  ezurl_object_link T2 <span>JOIN</span> ezcontentobject_attribute <span>ON</span> T2.contentobject_attribute_id <span>=</span> ezcontentobject_attribute.id  <span>WHERE</span> T1.url_id <span><</span> T2.url_id  <span>AND</span> T1.contentobject_attribute_id <span>=</span> T2.contentobject_attribute_id  <span>AND</span> T1.contentobject_attribute_version <span>=</span> T2.contentobject_attribute_version  <span>AND</span> ezcontentobject_attribute.data_type_string <span>=</span> <span>'ezurl'</span><span>)</span>;<span>-- End ezp-21465</span> <span>-- Start EZP-21469</span><span>-- While using the public API, ezcontentobject.language_mask was not updated correctly,</span><span>-- the UPDATE statement below fixes that based on the language_mask of the current version.</span><span>UPDATE</span>    ezcontentobject <span>AS</span> o<span>SET</span>    language_mask <span>=</span> <span>(</span>o.language_mask & <span>1</span><span>)</span> <span>|</span> <span>(</span>v.language_mask & ~<span>1</span><span>)</span><span>FROM</span>    ezcontentobject_version <span>AS</span> v<span>WHERE</span>    o.id <span>=</span> v.contentobject_id <span>AND</span> o.current_version <span>=</span> v.version;<span>-- End EZP-21469</span> <span>-- Start EZP-21648:</span><span>-- Adding 'priority' and 'is_hidden' columns to the 'eznode_assignment' table</span><span>ALTER</span> <span>TABLE</span> eznode_assignment <span>ADD</span> priority integer <span>DEFAULT</span> <span>0</span> <span>NOT</span> <span>NULL</span>;<span>ALTER</span> <span>TABLE</span> eznode_assignment <span>ADD</span> is_hidden integer <span>DEFAULT</span> <span>0</span> <span>NOT</span> <span>NULL</span>;<span>-- End EZP-21648</span>

Step 3: Upgrading the distribution files

The easiest way to upgrade the distribution files is to unpack eZ Publish 2013.09 to a separate directory and then copy into it the directories that contain site-specific files from the existing installation. Make sure that you copy the following directories:

• design/<mydesign>
• design/<mydesign_admin>
• var
• settings/siteaccess
• settings/override

Replace "mydesign" and "mydesign_admin" with the actual names of your designs.

Important note: Because the new directory has replaced the original directory, the directory permissions need to be fixed. Use the following commands to do this.

(You have the choice between Shell commands or Alternative shell commands):

• Shell commands

These shell commands will give proper permission to the web server:

cd </path/to/your/eZ/Publish/directory>cd ezpublish_legacychmod -R a+rwx design extension settings var 

• Alternative shell commands

 These commands will setup the permission more correctly, but require knowledge about the user account used for running the web server process.cd </path/to/your/eZ/Publish/directory>

cd </path/to/your/eZ/Publish/directory>cd ezpublish_legacychmod -R og+rwx design extension settings varchown -R <webuser>:<webusergroup> design extension settings var 

Step 4: Custom extensions

If you are using custom extensions, the sub-directories inside the "extension" directory will also have to be copied. However, make sure that you do not overwrite any extensions that are included in the eZ Publish 2013.09 tarball, which are currently:

Bundled and enabled

• ezautosave-5.2.0-rc1
• ezcomments-5.2.0-rc1 (ezpublish-5.2.0-rc1)
• ezformtoken-5.2.0-rc1
• ezie-5.2.0-rc1
• ezjscore-5.2.0-rc1
• ezmultiupload-5.2.0-rc1
• ezodf-5.2.0-rc1 (ezpublish-5.2.0-rc1)
• ezoe-5.2.0-rc1
• ezprestapiprovider-5.2.0-rc1
• eztags-1.3.0-dev

Bundled but not enabled

• ezfind-5.2.0-rc1
• ezscriptmonitor-5.2.0-rc1 (ezpublish-5.2.0-rc1)

Optional installation (depending on the package chosen during the installation wizard)

• ezdemo-5.2.0-rc1 (ezpublish-5.2.0-rc1)
• ezdemodesign-5.2.0-rc1 (ezpublish-5.2.0-rc1)
• ezflow-5.2.0-rc1 (ezpublish-5.2.0-rc1)
• ezgmaplocation-5.2.0-rc1 (ezpublish-5.2.0-rc1)
• ezstarrating-5.2.0-rc1 (ezpublish-5.2.0-rc1)
• ezwebin-5.2.0-rc1 (ezpublish-5.2.0-rc1)
• ezwt-5.2.0-rc1 (ezpublish-5.2.0-rc1)

Step 5: Regenerate the autoload array for extensions

To regenerate the autoload array, execute the following script from the root of your eZ Publish installation:

cd </path/to/your/eZ/Publish/directory>cd ezpublish_legacyphp bin/php/ezpgenerateautoloads.php --extension

Step 6: Clearing the caches

Whenever an eZ Publish website is upgraded, all caches must be cleared in a proper way. This should be done from the root directory of your eZ Publish installation:

cd </path/to/your/eZ/Publish/directory>cd ezpublish_legacyphp bin/php/ezcache.php --clear-all --purge 

Tip : Purging ensures that the caches are physically removed. When the "--purge" parameter is not specified, the caches will be expired but not removed.

Sometimes the script is unable to clear all cache files because of restrictive file/directory permission settings. Make sure that all cache files have been cleared by inspecting the contents of the various cache sub-directories within the "var" directory (typically the "var/cache/" and "var/<name_of_siteaccess>/cache/" directories). If there are any cache files left, you need to remove them manually.

Step 7: Putting the website back online

This step is optional, and is only needed if you put the website offline at step 2

• warm up the template cache by pre-compiling template files. This should be done from the root directory of your eZ Publish installation:

cd </path/to/your/eZ/Publish/directory>cd ezpublish_legacyphp bin/php/eztc.php --wwwdir=<value> --index-file=<value> 

• re-enable the cronjobs
• warm up the content cache: use a tool such as curl or wget that will navigate the website to force eZPublish to generate the view cache for all content
• change the webserver / firewall configuration to allow public access to your website again

• Backing up the website
• Putting the website offline (optional)
• Upgrading the database
• Upgrading the distribution files to 2013.07
• Upgrading custom extensions
• Regenerate the autoload array for extensions
• Clearing the caches
• Putting the website online (optional)