from 3.6.x or 3.7.x to 3.8.0
This section describes how to upgrade your existing eZ Publish 3.6.x / 3.7.x installation to version 3.8.0. If you are upgrading from a version prior to eZ Publish 3.6.0, you need to first upgrade to 3.6.0 before you can upgrade to 3.8.0.
Important note
Before continuing, note that it is recommended to upgrade directly to the latest stable release in the 3.8 branch, which is version 3.8.10. Refer to "Upgrading from 3.a.b to 3.x.y" and "Upgrading from 3.8.x to 3.8.y" to learn how this can be done. Note that there is a significant problem with eZ Publish 3.8.0-3.8.8. More precisely, the discount functionality of the shop module contains a security vulnerability. The issue has been fixed in version 3.8.9. Refer to the announcement and the upgrade instructions for details.
Make sure that you have a working backup of the site before you do the actual upgrade. The upgrade procedure consists of the following steps:
- Upgrading the distribution files to 3.8.0
- Upgrading the database to 3.8.0
- Running the system upgrade scripts
- Updating the system configuration
- Clearing the caches
Step 1: Upgrading the distribution files
The easiest way to upgrade the distribution files is to unpack eZ Publish 3.8.0 to a directory and then copy the directories that contain site-specific files from the existing installation. Make sure that you copy the following directories:
- design/example
- design/example_admin
- var
- settings/siteaccess
- settings/override
Replace "example" and "example_admin" with actual names used by your siteaccesses.
Custom extensions
If you are using custom extensions then the subdirectories inside the "extension" directory will also have to be copied. However, make sure that you do not overwrite any extensions that come with eZ Publish (for example the "PayPal" extension).
Step 2: Upgrading the database
The following text describes how a 3.6.0 database can be upgraded to 3.8.0.
MySQL
- Navigate into the eZ Publish 3.8.0 directory.
- Run the database upgrade script:
mysql -u <username> -p<password> <database> < update/database/mysql/3.8/dbupdate-3.6.0-to-3.8.0.sql
Note that the CREATE TABLE statements in the database upgrade script do not specify which storage engine to use (no ENGINE or TYPE option), and thus the default storage engine will be used. Normally, it is MyISAM (starting from MySQL v.3.23). If you are using InnoDB, make sure the default storage engine is set to InnoDB before you run the database upgrade script (refer to MySQL documentation for information about how to set the default engine). If you were not able to change the MySQL configuration on your server, and the upgrade left you with a mix of table types, you can use the "bin/php/ezconvertmysqltabletype.php" script for database conversion. It is also possible to convert the newly created tables to InnoDB using ALTER TABLE statements as shown in the following example:
ALTER TABLE table_name1 TYPE = innodb; ALTER TABLE table_name2 TYPE = innodb; ...
Replace "table_name1", "table_name2" with the actual names of the tables that need to be converted.
PostgreSQL
- Navigate into the eZ Publish 3.8.0 directory.
- Run the database upgrade script:
psql -d <database> -U <dbowner> < update/database/postgresql/3.8/dbupdate-3.6.0-to-3.8.0.sql
Step 3: Running the system upgrade scripts
The 3.8.0 version of eZ Publish introduces a couple of new features. In order to make sure that your site is compatible with these features, you'll have to run a couple of upgrade scripts.
Improved multi-language functionality
The 3.8.0 version of eZ Publish introduces improved multi-language functionality. In order to make sure that your site is compatible with this new feature, you will have to update the configuration settings and run the "updatemultilingual.php" script. This step must be done even though your site has only one language.
Configuring languages
Before running the upgrade script you need to configure how the languages must be displayed on your site.
For the public siteaccess(es) where only specific languages should be shown, add the following lines into the "[RegionalSettings]" section of the "settings/siteaccess/example/site.ini.append.php" file (replace "example" with the actual name of the siteaccess):
SiteLanguageList[] SiteLanguageList[]=<my-first-language> SiteLanguageList[]=<my-second-language> ShowUntranslatedObjects=disabled
e.g. for British English and German languages you would do:
SiteLanguageList[] SiteLanguageList[]=eng-GB SiteLanguageList[]=ger-DE ShowUntranslatedObjects=disabled
This will tell the system that English has the highest priority and German is the second language. Any other languages will not be shown.
For the siteaccess(es) like administration interface where all languages should be shown, add the following lines into the "[RegionalSettings]" section of the "settings/example_admin/site.ini.append.php" file (replace "example_admin" with the actual name of the siteaccess):
SiteLanguageList[] SiteLanguageList[]=<my-first-language> SiteLanguageList[]=<my-second-language> ShowUntranslatedObjects=enabled
e.g. for British English and German languages you would do:
SiteLanguageList[] SiteLanguageList[]=eng-GB SiteLanguageList[]=ger-DE ShowUntranslatedObjects=enabled
This will tell the system that English has the highest priority and German is the second language. All other languages will still be shown (and editable) but will have less priority. The "ShowUntranslatedObjects" setting controls whether all languages are shown or not.
Running the upgrade script
The "updatemultilingual.php" script should be run for all siteaccesses that use different databases. If you only have a public and an administration siteaccess (which is the most typical/usual case), then you will only need to run the script for one of the siteaccesses. If the siteaccess isn't specified, the default siteaccess will be used. Note that you will need to either publish or remove all the unpublished drafts in your system before launching this script.
The following example shows how to run the script:
- Navigate into the eZ Publish 3.8.0 directory.
- Run the script (replace "example" with the actual name of your siteaccess):
php update/common/scripts/updatemultilingual.php -s example
It is strongly recommended to read the information the script provides before continuing. If unsure press Control + C on your keyboard while the shell/console is active.
RSS import enhancements (optional)
The 3.8.0 version of eZ Publish introduces more generic RSS import that allows using custom RSS import definitions. If you are using the RSS import functionality on your site, you will have to run the "updaterssimport.php" script. This script should be run for all siteaccesses that use different databases. If you only have a public and an administration siteaccess (which is the most typical/usual case), then you will only need to run the script for one of the siteaccesses. If the siteaccess isn't specified, the default siteaccess will be used.
The following text shows how this can be done.
- Navigate into the eZ Publish 3.8.0 directory.
- Run the script (replace "example" with the actual name of your siteaccess):
php update/common/scripts/updaterssimport.php -s example
Step 4: Updating the system configuration
Treemenu configuration
In eZ Publish 3.8, the default configuration for the left treemenu in the administration interface has changed i.e. only folder, forum, gallery and user group objects are visible in the menu by default. (In previous versions, objects of any class were shown in the treemenu and this could cause problems when the number of objects in the system increased.)
The classes that the visible objects belong to are determined by the "ShowClasses[]" array located under the "[TreeMenu]" section of the "settings/contentstructuremenu.ini" configuration file. The following configuration is used by default:
[TreeMenu] ShowClasses[] ShowClasses[]=folder ShowClasses[]=forum ShowClasses[]=gallery ShowClasses[]=user_group
If you want to display other objects in the treemenu, e.g. user and article objects, do the following:
- Open the "contentstructuremenu.ini.append.php" configuration file located in the "settings/override" or "settings/siteaccess/example_admin" directory (replace "example_admin" with the actual name of your admin siteaccess) and edit it. If the file does not exist, create it.
- Add the following lines under the "[TreeMenu]" section:
[TreeMenu] ShowClasses[]=user ShowClasses[]=article
where "user" and "article" are class identifiers.
It is possible (but not recommended) to make the treemenu showing objects of all classes as in previous versions of eZ Publish. To do this, use the following configuration in the "contentstructuremenu.ini.append.php" file:
[TreeMenu] ShowClasses[]
Binary files indexing configuration
In eZ Publish versions prior to 3.8.0, the following default settings for binary file indexing were specified in the "binaryfile.ini" configuration file:
[HandlerSettings] MetaDataExtractor[text/plain]=plaintext MetaDataExtractor[application/pdf]=pdf MetaDataExtractor[application/msword]=word
In eZ Publish 3.8.0, the default settings for binary file indexing have been changed. This is how the new settings look like:
[HandlerSettings] MetaDataExtractor[text/plain]=ezplaintext MetaDataExtractor[application/pdf]=ezpdf MetaDataExtractor[application/msword]=ezword
If you have overridden these settings in your "binaryfile.ini.append.php" then you need to review your settings.
Default configuration of unique user emails
In eZ Publish versions prior to 3.8.0, the default configuration does not allow different users to be registered with the exact same email address. This is just a built-in precaution mechanism which can be easily turned off by setting the "RequireUniqueEmail" directive within the [UserSettings] block of a configuration override for "site.ini" to "false". However, this default configuration has been accidentally changed in eZ Publish version 3.8.0 (refer to http://issues.ez.no/9643 for more information). The change is reverted in eZ Publish version 3.8.7. If you are going to use eZ Publish 3.8.0-3.8.6, it is recommended to add the following line to the [UserSettings] block of the "override/site.ini.append.php" configuration file:
RequireUniqueEmail=true
Step 5: Clearing the caches
Whenever an eZ Publish solution is upgraded, all caches must be cleared in a proper way. This should be done from within a system shell:
- Navigate into the eZ Publish 3.8.0 directory.
- Run the clear cache script:
bin/shell/clearcache.sh --clear-all
Make sure that all caches are cleared. Sometimes the script is unable to clear caches because of restrictive file/directory permission settings. Make sure that all caches have been cleared by inspecting the contents of the various cache subdirectories within the "var" directory.
Balazs Halasy (22/04/2005 9:48 am)
Julia Shymova (26/12/2007 4:24 pm)
Comments
Policies / Siteaccess needs update too
Friday 15 September 2006 2:32:07 pm
Georg
after you have upgraded, you need to adjust all roles too.
a) You need to specify the role -> policy -> login (Siteaccesses) again (maybe a bug)
b) There is a new policy setting for "self edit". If you allow anonymous users to write content, you should alter the anonymous policy: content / edit: Owner( Self or anonymous users per HTTP session ) - thats a new setting.
Best wishes,
Georg.
Re: Policies / Siteaccess needs update too
Friday 15 September 2006 2:32:08 pm
Ole
This is to much work
Re: Policies / Siteaccess needs update too
Tuesday 10 October 2006 10:35:30 am
John Smith
Bug: Siteaccess is coming empty after upgradation.
Lets suppose if i have to update five-ten live sites, what will happen.
Ez Crew - Please fix this bug.
Regards
Smith
innodb
Friday 12 January 2007 6:48:28 am
Matthew Carroll
alter table ezcontent_language engine innodb;
alter table ezcurrencydata engine innodb;
alter table ezmultipricedata engine innodb;
alter table ezpackage engine innodb;
alter table ezproductcategory engine innodb;
alter table ezvatrule engine innodb;
alter table ezvatrule_product_category engine innodb;
See also, the 3.9 upgrade instructions, where this info has been incorporated into the instructions, and relevant bug reports:
http://issues.ez.no/8542
http://issues.ez.no/9420
http://ez.no/doc/ez_publish/upgra...upgrading_to_3_9/from_3_8_x_to_3_9_0
RelatedSiteAccesses needs to be set
Sunday 11 May 2008 9:53:34 pm
Leif Arne Storset
3.7.0-3.8.0
Thursday 30 July 2009 1:23:11 pm
Clemens
CREATE INDEX ezkeyword_keyword_id ON ezkeyword ( keyword, id );
CREATE INDEX ezkeyword_attr_link_kid_oaid ON ezkeyword_attribute_link ( keyword_id, objectattribute_id );
CREATE INDEX ezurlalias_is_wildcard ON ezurlalias( is_wildcard );
CREATE INDEX eznode_assignment_coid_cov ON eznode_assignment( contentobject_id,contentobject_version );
CREATE INDEX eznode_assignment_is_main ON eznode_assignment( is_main );
CREATE INDEX eznode_assignment_parent_node ON eznode_assignment( parent_node );