Hi guys,
Server Details:
Followed the usual upgrade process. But it failed with the following errors:
[CREATE TABLEos_plugin_instance(idint(11) unsigned NOT NULL AUTO_INCREMENT,plugin_idint(11) unsigned NOT NULL,flagsint(10) NOT NULL DEFAULT 0,namevarchar(128) NOT NULL DEFAULT '',configtext DEFAULT NULL,notestext DEFAULT NULL,createddatetime NOT NULL,updateddatetime DEFAULT NULL, PRIMARY KEY (id), KEYplugin_id(plugin_id) ) DEFAULT CHARSET=utf8] Table 'os_plugin_instance' already exists
So I dropped the table = os_plugin_instance
Then the new error was:
[/** * @version v1.17 * @signature e2b4e5cbb8b77e50a8f44bdcf09defc7 * @title Add plugin multi-instance support * */ ALTER TABLE os_plugin ADD notes text AFTER version, ADD UNIQUE (install_path)] Duplicate column name 'notes'
So I dropped the column = notes
Then the upgrader completed successfully. No PHP errors found. No errors in the Admin log. Plus the table and column were recreated.
Setup system via https://docs.osticket.com/en/latest/OAuth2/Microsoft%20Authorization%20Guide.html
All worked fine and straight forward well done @KevinTheJedi and the gang.
Some small teething issues:
- For whatever reason it didn't have SMTP turned on anymore. I needed to go click enable and save changes.
- The first email that was retrieved from the Inbox of my support account sent an email to the agent (me) as unsupported mime. But it looked fine in osTicket and any subsequent tests did not suffer from this... very weird.
All in all fingers crossed that it continues to work 😃
Thanks again to all you developers. Your hard work is very much appreciated.
