I have a very similar issue and I tried the upgrade 3 times.
Twice from 15.2 and then I upgraded step by step to 16.5
But 17.2 fails every time with the same messages:
[core]: Upgrader Error
[CREATE TABLE `plugin_instance` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `plugin_id` int(11) unsigned NOT NULL, `flags` int(10) NOT NULL DEFAULT 0, `name` varchar(128) NOT NULL DEFAULT '', `config` text DEFAULT NULL, `notes` text DEFAULT NULL, `created` datetime NOT NULL, `updated` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `plugin_id` (`plugin_id`) ) DEFAULT CHARSET=utf8] Table 'plugin_instance' already exists
Log Date: Wed, 1. Feb 2023 21:34 IP Address:
DB Error #1054
[SELECT A1.* FROM `email_account` A1 WHERE A1.`type` = 'smtp' AND A1.`type` = 'smtp' AND A1.`email_id` = 5] Unknown column 'A1.type' in 'where clause'<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(207): osTicket->logDBError('DB Error #1054', '[SELECT A1.* FR...')<br /> #1 (root)/include/class.orm.php(3482): db_query('SELECT A1.* FRO...', true, true)<br /> #2 (root)/include/class.orm.php(3529): MySqlExecutor->execute()<br /> #3 (root)/include/class.orm.php(2010): MySqlExecutor->getArray()<br /> #4 (root)/include/class.orm.php(2054): ModelInstanceManager->{closure}()<br /> #5 (root)/include/class.orm.php(2033): CallbackSimpleIterator->next()<br /> #6 (root)/include/class.orm.php(2042): CallbackSimpleIterator->rewind()<br /> #7 (root)/include/class.orm.php(1713): CallbackSimpleIterator->valid()<br /> #8 (root)/include/class.orm.php(1723): CachedResultSet->fillTo(9223372036854775807)<br /> #9 (root)/include/class.orm.php(1337): CachedResultSet->asArray()<br /> #10 (root)/include/class.orm.php(1360): QuerySet->all()<br /> #11 (root)/include/class.orm.php(606): QuerySet->one()<br /> #12 (root)/include/class.orm.php(381): VerySimpleModel::lookup(Array)<br /> #13 (root)/include/class.orm.php(417): VerySimpleModel->get('smtp', NULL)<br /> #14 (root)/include/class.email.php(210): VerySimpleModel->__get('smtp')<br /> #15 (root)/include/class.mailer.php(35): Email->getSmtpAccount(false)<br /> #16 (root)/include/class.email.php(231): osTicket\Mail\Mailer->__construct(Object(Email))<br /> #17 (root)/include/class.email.php(245): Email->send('patrick.dimarti...', '[core]: Upgrade...', '[CREATE TABLE `...', NULL, Array)<br /> #18 (root)/include/class.upgrader.php(204): Email->sendAlert('patrick.dimarti...', '[core]: Upgrade...', '[CREATE TABLE `...')<br /> #19 (root)/include/class.setup.php(115): StreamUpgrader->onError('[CREATE TABLE `...')<br /> #20 (root)/include/class.setup.php(69): SetupWizard->abort('[CREATE TABLE `...', false)<br /> #21 (root)/include/class.setup.php(44): SetupWizard->load_sql('/**\n * @version...', '', true, false)<br /> #22 (root)/include/class.upgrader.php(379): SetupWizard->load_sql_file('/home/latincon/...', '')<br /> #23 (root)/include/class.upgrader.php(112): StreamUpgrader->upgrade()<br /> #24 (root)/include/ajax.upgrader.php(42): Upgrader->upgrade()<br /> #25 (root)/include/class.dispatcher.php(153): UpgraderAjaxAPI->upgrade()<br /> #26 (root)/include/class.dispatcher.php(40): UrlMatcher->dispatch('/upgrader', NULL)<br /> #27 (root)/scp/ajax.php(326): Dispatcher->resolve('/upgrader')<br /> #28 {main}
Log Date: Wed, 1. Feb 2023 21:34 IP Address:
I am on a dedicated server and this looks more like a database issue to me than a php settings one.
I will just go back and stay at 16.5, but it may help to solve the puzzle.