Upgrading to 2.1 from 2.0

SupportPal 2.1 is a major update, adding multi-brands functionality and PHP 7 support, amongst many other new features and improvements. The most important change to take in to consideration when upgrading is the change of the database charset to utf8mb4, which has been detailed more below.

Contents

Estimated Upgrade Time: Less Than 1 Hour.

What's New?

View the 2.1 Release Notes for the new features and improvements in this series.

Upgrading Database

The release includes improved UTF8 support at the database level, allowing us to correctly store characters such as emojis that are commonly used on social networks. Due to this change, the upgrade script may be slow so we recommend to read through the below before continuing:

System Cleanup

Database tables that contain significant text, for example the email_log and ticket_message tables will significant slow down the upgrade as their character encoding is converted. For this reason, we highly recommend that you purge your email log to reduce your database size. The email log can be purged by logging into the operator panel and browsing to Utilities -> System Cleanup, all emails before the selected date will be permanently removed from your database.

Manual Character Conversions

To avoid server-side timeouts breaking the upgrade process, we highly recommend that you manually run the UTF8mb4 database changes and then continue with the SupportPal in-browser upgrade process as you would normally.

  1. Upload and extract the 2.1.0 zip file
  2. Manually run the below SQL script against your database:
    2.1.0_migrations.sql
  3. Proceed with the usual SupportPal upgrade by browsing to http://support.yourdomain.com/upgrade

Disable Server-side Timeouts

We recommend that you disable server-side timeouts within your web server, PHP and MySQL configurations for the duration of the SupportPal in-browser upgrade process.

Please ask your server administrator or hosting provider for more details on what settings are appropriate to disable for your server environment. We suggest the following PHP configuration:

API Changes

Due to the changes to accommodate brands, several API routes have been modified with some breaking changes. The changes are detailed more below:

PHP 7 Support

The 2.1 series adds support for PHP 7. If you wish to use SupportPal with PHP 7, please ensure you have installed the ionCube loaders v6 before updating SupportPal. We have two versions of the release available in our downloads area, one for PHP 5.5 and 5.6, and one for PHP 7+, so ensure you select the correct one based on your server set-up.

Other Important Changes