What does the upgrader.php page use to determine an error?

Codewow

What is the upgrader page looking at to determine an internal error? Even when drop my tables and import my backup, it still says an internal error occurred and I can't proceed with the upgrade attempt...

KevinTheJedi

Codewow

Internal Error is not the upgrader rather the server indicating there is a deeper issue somewhere. You need to check your logs for any related errors. It’s more than likely it can’t connect to the database but you need to find the real error to see exactly what’s going on.

Cheers.

Codewow

KevinTheJedi

Had to check the code. It was checking the session variable for "Aborted" after a previous failed attempt. Logged out and back in and it was cleared.

Now I'm getting this bugger going from 1.16.5 to 1.17.2

[SELECT A1.* FROMost_email_accountA1 WHERE A1.type= 'smtp' AND A1.type= 'smtp' AND A1.email_id= 1] Unknown column 'A1.type' in 'where clause' ---- Backtrace ---- #0 C:\inetpub\wwwroot\osTicket\include\mysqli.php(207): osTicket->logDBError() #1 C:\inetpub\wwwroot\osTicket\include\class.orm.php(3482): db_query() #2 C:\inetpub\wwwroot\osTicket\include\class.orm.php(3529): MySqlExecutor->execute() #3 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2010): MySqlExecutor->getArray() #4 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2054): ModelInstanceManager->{closure}() #5 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2033): CallbackSimpleIterator->next() #6 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2042): CallbackSimpleIterator->rewind() #7 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1713): CallbackSimpleIterator->valid() #8 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1723): CachedResultSet->fillTo() #9 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1337): CachedResultSet->asArray() #10 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1360): QuerySet->all() #11 C:\inetpub\wwwroot\osTicket\include\class.orm.php(606): QuerySet->one() #12 C:\inetpub\wwwroot\osTicket\include\class.orm.php(381): VerySimpleModel::lookup() #13 C:\inetpub\wwwroot\osTicket\include\class.orm.php(417): VerySimpleModel->get() #14 C:\inetpub\wwwroot\osTicket\include\class.email.php(210): VerySimpleModel->__get() #15 C:\inetpub\wwwroot\osTicket\include\class.mailer.php(35): Email->getSmtpAccount() #16 C:\inetpub\wwwroot\osTicket\include\class.email.php(231): osTicket\Mail\Mailer->__construct() #17 C:\inetpub\wwwroot\osTicket\include\class.email.php(245): Email->send() #18 C:\inetpub\wwwroot\osTicket\include\class.upgrader.php(204): Email->sendAlert() #19 C:\inetpub\wwwroot\osTicket\include\class.setup.php(115): StreamUpgrader->onError() #20 C:\inetpub\wwwroot\osTicket\include\class.setup.php(69): SetupWizard->abort() #21 C:\inetpub\wwwroot\osTicket\include\class.setup.php(44): SetupWizard->load_sql() #22 C:\inetpub\wwwroot\osTicket\include\class.upgrader.php(379): SetupWizard->load_sql_file() #23 C:\inetpub\wwwroot\osTicket\include\class.upgrader.php(112): StreamUpgrader->upgrade() #24 C:\inetpub\wwwroot\osTicket\include\ajax.upgrader.php(42): Upgrader->upgrade() #25 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(153): UpgraderAjaxAPI->upgrade() #26 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(40): UrlMatcher->dispatch() #27 C:\inetpub\wwwroot\osTicket\scp\ajax.php(326): Dispatcher->resolve() #28 {main}

KevinTheJedi

Codewow

It seems it’s looking for a column that should exist but doesn’t in your database for whatever reason. ~~What version are you trying to upgrade from?~~

Sorry I’m blind I see 1.16.5. Let me look at the error deeper.

Cheers.

KevinTheJedi

Codewow

Okay so the stack trace says it’s trying to run an SQL statement from the upgrade scripts but it’s failing. When an upgrade query fails it tries to send an email to the Admin but the query to grab a system email account to send from is also failing as it’s looking for a column in a table that’s not fully upgraded yet. So the real issue is there is an upgrade query that’s failing to run causing an alert to be sent out (or tries to in this case). Try looking at the system logs and see what query failed.

Cheers.

Codewow

KevinTheJedi

Figured it out. Looks like first attempt failure created some columns in the db and was getting caught up on "error adding column duplicate found" error, I removed the columns and reran the upgrader and it completed successfully.