I just performed a upgrade from 1.15 to 1.18. The website comes up in offline mode. I go to the admin portal and login using credentials and it sticks on "VERIFYING".
Checking the logs reveal error during login:
PHP Fatal error: Uncaught InconsistentModelException: Unable to prepare query: SELECT A1.* FROMost_email_accountA1 WHERE A1.type= 'smtp' AND A1.type= 'smtp' AND A1.email_id= 1 in /var/www/helpdesk/include/class.orm.php:3483
Stack trace:
#0 /var/www/helpdesk.8-koi.com/include/class.orm.php(3529): MySqlExecutor->execute()
#1 /var/www/helpdesk.8-koi.com/include/class.orm.php(2010): MySqlExecutor->getArray()
#2 /var/www/helpdesk.8-koi.com/include/class.orm.php(2054): ModelInstanceManager->{closure}()
#3 /var/www/helpdesk.8-koi.com/include/class.orm.php(2033): CallbackSimpleIterator->next()
#4 /var/www/helpdesk.8-koi.com/include/class.orm.php(2042): CallbackSimpleIterator->rewind()
#5 /var/www/helpdesk.8-koi.com/include/class.orm.php(1713): CallbackSimpleIterator->valid()
#6 /var/www/helpdesk.8-koi.com/include/class.orm.php(1723): CachedResultSet->fillTo()
#7 /var/www/helpdesk.8-koi.com/include/class.orm.php(1337): CachedResultSet->asArray()
#8 /var/www/helpdesk.8-" while reading response header from upstream, client: Y.Y.Y.Y, server: helpdesk.XXXXXXX.com, request: "POST /scp/login.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php8.1-fpm.sock:", host: "helpdesk.XXXXXXX.com", referrer: "https://helpdesk.XXXXXXX.com/scp/login.php"
(NOTE THE ABOVE HAS BEEN SANITIZED FOR SECURITY PURPOSES)
I feel I am missing something elementary...but what?
Any help would be great.
