I am trying to migrate our old DB to a new server and upgraded version of osticket. I was able to get 1.17 installed successfully. I imported the old DB and logged in. After logging in it said the system needed to upgrade. Clicked to upgrade and received the following errors.
[core]: Upgrader Error
[/** * @signature 86707325fc571e56242fccc46fd24466 * @version v1.11.0 * @title Add ticket referral * * This patch adds a table for thread referral as well as thread event states of referred and deleted */ CREATE TABLE ost_thread_referral ( id int(10) unsigned NOT NULL AUTO_INCREMENT, thread_id int(11) unsigned NOT NULL, object_id int(11) unsigned NOT NULL, object_type char(1) NOT NULL, created datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY ref (object_id, object_type, thread_id), KEY thread_id (thread_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8] Table 'ost_thread_referral' already exists
Log Date: Friday, June 30, 2023 at 8:11 AM IP Address: ::1
DB Error #1054
[SELECT A1.* FROM ost_email_account A1 WHERE A1.type = 'smtp' AND A1.type = 'smtp' AND A1.email_id = 4] Unknown column 'A1.type' in 'where clause'<br /> <br /> ---- Backtrace ----<br /> #0 C:\inetpub\wwwroot\osticket\include\mysqli.php(211): osTicket->logDBError()<br /> #1 C:\inetpub\wwwroot\osticket\include\class.orm.php(3482): db_query()<br /> #2 C:\inetpub\wwwroot\osticket\include\class.orm.php(3529): MySqlExecutor->execute()<br /> #3 C:\inetpub\wwwroot\osticket\include\class.orm.php(2010): MySqlExecutor->getArray()<br /> #4 C:\inetpub\wwwroot\osticket\include\class.orm.php(2054): ModelInstanceManager->{closure}()<br /> #5 C:\inetpub\wwwroot\osticket\include\class.orm.php(2033): CallbackSimpleIterator->next()<br /> #6 C:\inetpub\wwwroot\osticket\include\class.orm.php(2042): CallbackSimpleIterator->rewind()<br /> #7 C:\inetpub\wwwroot\osticket\include\class.orm.php(1713): CallbackSimpleIterator->valid()<br /> #8 C:\inetpub\wwwroot\osticket\include\class.orm.php(1723): CachedResultSet->fillTo()<br /> #9 C:\inetpub\wwwroot\osticket\include\class.orm.php(1337): CachedResultSet->asArray()<br /> #10 C:\inetpub\wwwroot\osticket\include\class.orm.php(1360): QuerySet->all()<br /> #11 C:\inetpub\wwwroot\osticket\include\class.orm.php(606): QuerySet->one()<br /> #12 C:\inetpub\wwwroot\osticket\include\class.orm.php(381): VerySimpleModel::lookup()<br /> #13 C:\inetpub\wwwroot\osticket\include\class.orm.php(417): VerySimpleModel->get()<br /> #14 C:\inetpub\wwwroot\osticket\include\class.email.php(210): VerySimpleModel->get()<br /> #15 C:\inetpub\wwwroot\osticket\include\class.mailer.php(35): Email->getSmtpAccount()<br /> #16 C:\inetpub\wwwroot\osticket\include\class.email.php(231): osTicket\Mail\Mailer->construct()<br /> #17 C:\inetpub\wwwroot\osticket\include\class.email.php(245): Email->send()<br /> #18 C:\inetpub\wwwroot\osticket\include\class.upgrader.php(204): Email->sendAlert()<br /> #19 C:\inetpub\wwwroot\osticket\include\class.setup.php(115): StreamUpgrader->onError()<br /> #20 C:\inetpub\wwwroot\osticket\include\class.setup.php(69): SetupWizard->abort()<br /> #21 C:\inetpub\wwwroot\osticket\include\class.setup.php(44): SetupWizard->load_sql()<br /> #22 C:\inetpub\wwwroot\osticket\include\class.upgrader.php(379): SetupWizard->load_sql_file()<br /> #23 C:\inetpub\wwwroot\osticket\include\class.upgrader.php(112): StreamUpgrader->upgrade()<br /> #24 C:\inetpub\wwwroot\osticket\include\ajax.upgrader.php(42): Upgrader->upgrade()<br /> #25 C:\inetpub\wwwroot\osticket\include\class.dispatcher.php(153): UpgraderAjaxAPI->upgrade()<br /> #26 C:\inetpub\wwwroot\osticket\include\class.dispatcher.php(40): UrlMatcher->dispatch()<br /> #27 C:\inetpub\wwwroot\osticket\scp\ajax.php(327): Dispatcher->resolve()<br /> #28 {main}
