Website interface 1.10 upgrade

Back-up

Before starting the Website Interface upgrading process make sure that you have a working backup of the existing website state including database, extensions, INI settings, etc. During the upgrade process the existing "Website Interface" extension will be removed and replaced with a new version.

Packages

Download following packages from http://packages.ez.no/ezpublish/4.7/4.7.0/:
 "ezwebin_extension.ezpkg"
 "ezstarrating_extension.ezpkg"
 "ezgmaplocation_extension.ezpkg"
 "ezwt_extension.ezpkg"
 "ezwebin_design_blue.ezpkg"

Go to the packages management interface in the "Administration Interface". This can be done via the "Setup-tab", where you can click on the "Packages"-link in the left menu:

The package management screen

From the Repository drop-down box choose eZ-system then click “Change repository” button. From the list of available packages remove following packages:
 "ezwebin_extension"
 "ezstarrating_extension"
 "ezgmaplocation_extension"
 "ezwt_extension"
 "ezwebin_design_blue"

Next change repository again to the “eZ-systems” and click on “Import new package” button. In the next view select "ezwebin_extension" and click “Import package” button. Once the "ezwebin_extension" is imported click on “Install package”. In the next view choose “Replace extension” option and click “Continue” button. Repeat these steps for rest of new extensions ("ezstarrating_extension", "ezgmaplocation_extension" and "ezwt_extension").

Once all new extensions are imported they need to be activated under the [ExtensionSettings] block in the "settings/site.ini.append.php":

[ExtensionSettings]
[...]
ActiveExtensions[]=ezjscore
ActiveExtensions[]=ezstarrating
ActiveExtensions[]=ezgmaplocation
ActiveExtensions[]=ezwt
ActiveExtensions[]=ezwebin
[…]

Autoload update

Next the autoload array needs to be updated for the new extensions. In order to do so, execute following command from eZ Publish root folder:

$ php bin/php/ezpgenerateautoloads.php -e -p

Content classes

Website Interface 1.10 does not provide any new content classes.

Database changes

Note: The database changes below for eZ Flow, eZ GMAP Location and eZ StarRating are only related to Postgre SQL setups.

For eZ GMAP Location (for Postgre SQL only):

ALTER INDEX ezgml_latitude_longitude_key RENAME TO latitude_longitude_key;

For eZ StarRating (for Postgre SQL only):

ALTER INDEX ezsr_data_user_id_session_key RENAME TO user_id_session_key;
ALTER INDEX ezsr_data_contentobject_id_contentobject_attribute_id
RENAME TO contentobject_id_contentobject_attribute_id;

UPDATE ezsite_data SET value='4.7.0rc1' WHERE name='ezpublish-version';
UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';

ALTER TABLE ONLY ezpending_actions
   ADD CONSTRAINT ezpending_actions_pkey PRIMARY KEY (id);

UPDATE eztrigger SET name = 'pre_updatemainassignment', function_name = 'updatemainassignment'
   WHERE name = 'pre_UpdateMainAssignment' AND function_name = 'UpdateMainAssignment';

ALTER TABLE ezstarrating RENAME COLUMN rating_average TO rating_average_tmp;
ALTER TABLE ezstarrating ADD COLUMN rating_average real;
ALTER TABLE ezstarrating ALTER rating_average SET DEFAULT 0::real ;
ALTER TABLE ezstarrating ALTER rating_average SET NOT NULL ;
UPDATE ezstarrating SET rating_average=rating_average_tmp;
ALTER TABLE ezstarrating DROP COLUMN rating_average_tmp;
 
ALTER TABLE ezstarrating_data RENAME COLUMN rating TO rating_tmp;
ALTER TABLE ezstarrating_data ADD COLUMN rating real;
ALTER TABLE ezstarrating_data ALTER rating SET DEFAULT 0::real ;
ALTER TABLE ezstarrating_data ALTER rating SET NOT NULL ;
UPDATE ezstarrating_data SET rating=rating_tmp;
ALTER TABLE ezstarrating_data DROP COLUMN rating_tmp;

Note: If you have already upgraded eZ StarRating packages while upgrading eZ Webwin, you may have run these queries already. If you run them again, some errors will rise.

INI settings

Update" settings/siteaccess/(public_site_name)/design.ini.append.php" and replace old settings with new ones:

[StylesheetSettings]
SiteCSS=var/storage/packages/eZ-systems/ezwebin_design_blue/files/default/file/site-colors.css
ClassesCSS=var/storage/packages/eZ-systems/ezwebin_design_blue/files/default/file/classes-colors.css
CSSFileList[]
 
[JavaScriptSettings]
JavaScriptList[]=insertmedia.js

Note: The settings above have not changed from 4.5, so unless you upgrade from 4.4, you don't need to change these settings. Check them, however. Better safe than sorry!

Clear Cache

Once the upgrade script is done, you need to clear the cache by executing following command from eZ Publish root folder:

php bin/php/ezcache.php --clear-all --purge