php error is the following, I have tried using php 8.1, currently using 8.0, tried mysql 5.7 and also mariadb 10.3, can access other pages like system.php, profile.php, when I try agent portal or tickets they return blank with below error messsage.
Ticket queue settings also don't load properly, no option to save a new one or edit any settings under the columns.

[Tue May 23 11:38:43.729691 2023] [proxy_fcgi:error] [pid 82530] [client 10.100.31.43:43574] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught DoesNotExist in /var/www/procurement.dkit.ie/upload/include/class.orm.php:1362\nStack trace:\n#0 /var/www/procurement.dkit.ie/upload/include/class.organization.php(368): QuerySet->one()\n#1 /var/www/procurement.dkit.ie/upload/include/class.queue.php(353): Organization::getSearchableFields()\n#2 /var/www/procurement.dkit.ie/upload/include/class.queue.php(391): CustomQueue::getSearchableFields()\n#3 /var/www/procurement.dkit.ie/upload/include/class.queue.php(391): CustomQueue::getSearchableFields()\n#4 /var/www/procurement.dkit.ie/upload/include/class.queue.php(319): CustomQueue::getSearchableFields()\n#5 /var/www/procurement.dkit.ie/upload/include/class.queue.php(151): CustomQueue->getSupportedMatches()\n#6 /var/www/procurement.dkit.ie/upload/include/staff/queue.inc.php(88): CustomQueue->describeCriteria()\n#7 /var/www/procurement.dkit.ie/upload/scp/queues.php(118): include_once('...')\n#8 {main}\n thrown in /var/www/procurement.dkit.ie/upload/include/class.orm.php on ...', referer: http://procurement.dkit.ie/scp/settings.php?t=tickets

some db errors on the admin page

DB Error #1146

[SELECT A1.* FROM ost_translation A1 WHERE A1.lang = 'en_US' AND A1.type = 'phrase'] Table 'procurement.ost_translation' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(211): osTicket->logDBError()<br /> #1 (root)/include/class.orm.php(3482): db_query()<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()<br /> #9 (root)/include/class.orm.php(1739): CachedResultSet->asArray()<br /> #10 (root)/include/class.translation.php(910): CachedResultSet->getIterator()<br /> #11 (root)/include/class.translation.php(931): CustomDataTranslation::getTranslation()<br /> #12 (root)/include/class.list.php(400): CustomDataTranslation::translate()<br /> #13 (root)/include/class.list.php(213): DynamicList->getLocal()<br /> #14 (root)/include/class.list.php(540): DynamicList->getPluralName()<br /> #15 (root)/include/class.forms.php(647): DynamicList::getSelections()<br /> #16 (root)/include/class.forms.php(655): FormField::allTypes()<br /> #17 (root)/include/class.forms.php(1165): FormField::getFieldType()<br /> #18 (root)/include/class.dynamic_forms.php(650): FormField->getImpl()<br /> #19 (root)/include/class.dynamic_forms.php(1448): DynamicFormField->call()<br /> #20 (root)/include/class.dynamic_forms.php(1011): DynamicFormEntryAnswer->getField()<br /> #21 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer()<br /> #22 (root)/include/staff/footer.inc.php(6): Company->toString()<br /> #23 (root)/scp/upgrade.php(88): require('...')<br /> #24 {main}

DB Error #1054

[UPDATE ost_staff SET extra = '{\"browser_lang\":\"en_US\"}', lastlogin = NOW(), updated = NOW() WHERE ost_staff.staff_id = 1 LIMIT 1] Unknown column 'extra' in 'field list'<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(211): osTicket->logDBError()<br /> #1 (root)/include/class.orm.php(3482): db_query()<br /> #2 (root)/include/class.orm.php(658): MySqlExecutor->execute()<br /> #3 (root)/include/class.staff.php(1216): VerySimpleModel->save()<br /> #4 (root)/include/class.staff.php(814): Staff->save()<br /> #5 (root)/include/class.auth.php(674): Staff->onLogin()<br /> #6 (root)/include/class.auth.php(343): StaffAuthenticationBackend->login()<br /> #7 (root)/scp/login.php(71): AuthenticationBackend::process()<br /> #8 {main}

DB Error #1064

[SELECT FROM ost_content A1 WHERE A1.type = 'banner-staff' ORDER BY A1.name ASC] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM ost_content A1 WHERE A1.type = 'banner-staff' ORDER BY A1.name ASC' at line 1<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(211): osTicket->logDBError()<br /> #1 (root)/include/class.orm.php(3482): db_query()<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()<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.page.php(235): QuerySet->one()<br /> #12 (root)/scp/login.php(26): Page::lookupByType()<br /> #13 {main}

No never removed it, where should it be?

I basically created a complete new install of osticket as we only use this for one department there isn't much config needed.

After I tested new install, I could log on and change settings as needed, setup ldap plugin, setup emails etc.

Then imported old db over the new one and then system went through upgrade process. Seemed to get to 1.17 and aborted at the very end and only errors were those db errors.

I didn't change any files under include folder

Sorry under upload folder