Upgrading Osticket from 1.6 to 1.10

By:
On:
In: General

Upgrading Osticket from 1.6 to 1.10

In my experience, we need to migrate to 1.7 first in order to move all attachments  from file system to database , if you go directly from 1.6 to 1.10 , attachment might be missing.

We need to run the following queries before to fix some issues with database:
ALTER TABLE `supportedf_help_topic` ADD INDEX(`topic`);

ALTER TABLE `supportedf_department` ADD INDEX(`dept_name`);

If you have duplicate topic you might need to clear the topic first

TRUNCATE supportedf_help_topic;