Issues upgrading from 1.16 to 1.17

mredus

Hello,

(IIS 10 / PHP 8.0.0 / osT 1.16.4 to IIS 10 / PHP 8.1.12 / osT 1.17.2)
I am trying to upgrade one of our osTicket instances to the latest release in preparation for Microsoft's complete discontinuation of legacy auth early next year and am running in to an issue while attempting to do so.

I've upgraded the helpdesks for some of our other departments already (all are on separate instances for data regulation reasons) and everything went smoothly with them. The error I'm getting has to do with migrating the database:

 [core]: Upgrader Error
[/** * @version v1.17 * @signature (removed) * @title Add plugin multi-instance support * */ ALTER TABLE 'ost_plugin' ADD 'notes' text AFTER 'version', ADD UNIQUE ('install_path')] Duplicate column name 'notes'

I've rolled back the database and static files to 1.16.4 and have put it back in to production for now - any help with this is much appreciated.

Thank you!

Edit: Removed forum markup in SQL error - replaced ` with '

KevinTheJedi

mredus

You basically have a column in your table that shouldn't be there so when it's trying to add it it's complaining that it already exists. I would just delete the notes column in the ost_plugin table and re-run the upgrade.

Cheers.

mredus

Bingo, I was pretty sure that I needed to do that but just wanted some input. After removing that column, I also had to remove the ost_plugin_instance table entirely as it was causing another error. I guess these were remnants of one of the previous failed upgrade attempts and somehow the SQL dump that I was using to restore included them. Up and running now though - thank you!