DB Error #1054 when upgrading from v1.16 to v1.17

he133425

in a Dev VM I have upgraded from OsTicket from v1.14 to v1.16 successfully but when attempting to then upgrade from v1.16 to v1.17, it's failing and reporting:
Upgrade Aborted!
Upgrade aborted due to errors. Any errors at this stage are fatal.

When I check the System logs:
DB Error #1054
[SELECT A1.* FROM ost_email_account A1 WHERE A1.type = 'smtp' AND A1.type = 'smtp' AND A1.email_id = 6] Unknown column 'A1.type' in 'where clause' ---- Backtrace ---- #0 (root)/include/mysqli.php(201): osTicket->logDBError() #1 (root)/include/class.orm.php(3468): db_query() #2 (root)/include/class.orm.php(3515): MySqlExecutor->execute() #3 (root)/include/class.orm.php(2001): MySqlExecutor->getArray() #4 (root)/include/class.orm.php(2045):

Could you please give me a few pointers on how to proceed?

he133425

Issue is now fixed and was able to complete the upgrade. Upgrade needed to deploy a database change, unique index on ost-plugin table and install_path column, but because of a duplicate record the deployment failed. I removed the duplicate and the upgrade completed

KevinTheJedi

he133425

Thank you for posting. I can check to see if the upcoming v1.17 with multi instance plugin support will fix issues like this (as in preventing duplicates). If not we can look into adding unique indexes on the plugin table.

Cheers.