Hello, I'm running into an issue upgrading one of my helpdesks.
I have ran the update on another helpdesk that was exactly the same base files successfully, so I am stumped why this other helpdesk is not working.
System Info:
Running on Server 2019, IIS 10.0.17763.1
PHP7.3.21 - migrating to 8.1.16
MySQL 8.0.19
When doing the upgrade there are no plugins as I have disabled them, then deleted them from the web interface, then physically removed the files after uploading the new files to the web folder.
I get green check boxes on the upgrade page, however I get the following stack trace:
[19-Apr-2023 19:56:35 UTC] PHP Fatal error: Uncaught InconsistentModelException: Unable to prepare query: SELECT A1.* FROM
ost_email_accountA1 WHERE A1.
type= 'smtp' AND A1.
type= 'smtp' AND A1.
email_id= 1 in C:\inetpub\wwwroot\helpdesk\include\class.orm.php:3483
Stack trace:
#0 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(3529): MySqlExecutor->execute()
#1 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2010): MySqlExecutor->getArray()
#2 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2054): ModelInstanceManager->{closure}()
#3 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2033): CallbackSimpleIterator->next()
#4 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2042): CallbackSimpleIterator->rewind()
#5 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1713): CallbackSimpleIterator->valid()
#6 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1723): CachedResultSet->fillTo()
#7 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1337): CachedResultSet->asArray()
#8 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1360): QuerySet->all()
#9 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(606): QuerySet->one()
#10 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(381): VerySimpleModel::lookup()
#11 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(417): VerySimpleModel->get()
#12 C:\inetpub\wwwroot\helpdesk\include\class.email.php(210): VerySimpleModel->__get()
#13 C:\inetpub\wwwroot\helpdesk\include\class.mailer.php(35): Email->getSmtpAccount()
#14 C:\inetpub\wwwroot\helpdesk\include\class.email.php(231): osTicket\Mail\Mailer->__construct()
#15 C:\inetpub\wwwroot\helpdesk\include\class.email.php(245): Email->send()
#16 C:\inetpub\wwwroot\helpdesk\include\class.upgrader.php(204): Email->sendAlert()
#17 C:\inetpub\wwwroot\helpdesk\include\class.setup.php(115): StreamUpgrader->onError()
#18 C:\inetpub\wwwroot\helpdesk\include\class.setup.php(69): SetupWizard->abort()
#19 C:\inetpub\wwwroot\helpdesk\include\class.setup.php(44): SetupWizard->load_sql()
#20 C:\inetpub\wwwroot\helpdesk\include\class.upgrader.php(379): SetupWizard->load_sql_file()
#21 C:\inetpub\wwwroot\helpdesk\include\class.upgrader.php(112): StreamUpgrader->upgrade()
#22 C:\inetpub\wwwroot\helpdesk\include\ajax.upgrader.php(42): Upgrader->upgrade()
#23 C:\inetpub\wwwroot\helpdesk\include\class.dispatcher.php(153): UpgraderAjaxAPI->upgrade()
#24 C:\inetpub\wwwroot\helpdesk\include\class.dispatcher.php(40): UrlMatcher->dispatch()
#25 C:\inetpub\wwwroot\helpdesk\scp\ajax.php(327): Dispatcher->resolve()
#26 {main}
thrown in C:\inetpub\wwwroot\helpdesk\include\class.orm.php on line 3483
Thank you in advance for any assistance you may provide.