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;Read More →