Upgrade Failed

kamilr

Hi All,

I did a fresh install of osTicket, but when I imported the MySQL information, it took me back to Upgrade required

When I click on upgrade now, it fails because the ost_plugins table already exists

Any ideas?

kamilr

This is the DB Error

[SELECT A1.* FROM ost_email_account A1 WHERE A1.type = 'smtp' AND A1.type = 'smtp' AND A1.email_id = 5] Unknown column 'A1.type' in 'where clause' ---- Backtrace ---- #0 C:\xampp\htdocs\IT\include\mysqli.php(211): osTicket->logDBError('DB Error #1054', '[SELECT A1.* FR...') #1 C:\xampp\htdocs\IT\include\class.orm.php(3482): db_query('SELECT A1.* FRO...', true, true) #2 C:\xampp\htdocs\IT\include\class.orm.php(3529): MySqlExecutor->execute() #3 C:\xampp\htdocs\IT\include\class.orm.php(2010): MySqlExecutor->getArray() #4 C:\xampp\htdocs\IT\include\class.orm.php(2054): ModelInstanceManager->{closure}() #5 C:\xampp\htdocs\IT\include\class.orm.php(2033): CallbackSimpleIterator->next() #6 C:\xampp\htdocs\IT\include\class.orm.php(2042): CallbackSimpleIterator->rewind() #7 C:\xampp\htdocs\IT\include\class.orm.php(1713): CallbackSimpleIterator->valid() #8 C:\xampp\htdocs\IT\include\class.orm.php(1723): CachedResultSet->fillTo(9223372036854775807) #9 C:\xampp\htdocs\IT\include\class.orm.php(1337): CachedResultSet->asArray() #10 C:\xampp\htdocs\IT\include\class.orm.php(1360): QuerySet->all() #11 C:\xampp\htdocs\IT\include\class.orm.php(606): QuerySet->one() #12 C:\xampp\htdocs\IT\include\class.orm.php(381): VerySimpleModel::lookup(Array) #13 C:\xampp\htdocs\IT\include\class.orm.php(417): VerySimpleModel->get('smtp', NULL) #14 C:\xampp\htdocs\IT\include\class.email.php(210): VerySimpleModel->get('smtp') #15 C:\xampp\htdocs\IT\include\class.mailer.php(35): Email->getSmtpAccount(false) #16 C:\xampp\htdocs\IT\include\class.email.php(231): osTicket\Mail\Mailer->construct(Object(Email)) #17 C:\xampp\htdocs\IT\include\class.email.php(245): Email->send('**@*...', '[core]: Upgrade...', '[/\n * @versio...', NULL, Array) #18 C:\xampp\htdocs\IT\include\class.upgrader.php(204): Email->sendAlert('**@*...', '[core]: Upgrade...', '[/\n * @versio...') #19 C:\xampp\htdocs\IT\include\class.setup.php(115): StreamUpgrader->onError('[/\n * @versio...') #20 C:\xampp\htdocs\IT\include\class.setup.php(69): SetupWizard->abort('[/\n * @versio...', false) #21 C:\xampp\htdocs\IT\include\class.setup.php(44): SetupWizard->load_sql('/**\n * @version...', 'ost', true, false) #22 C:\xampp\htdocs\IT\include\class.upgrader.php(379): SetupWizard->load_sql_file('C:/xampp/htdocs...', 'ost') #23 C:\xampp\htdocs\IT\include\class.upgrader.php(112): StreamUpgrader->upgrade() #24 C:\xampp\htdocs\IT\scp\upgrade.php(41): Upgrader->upgrade() #25 {main}

KevinTheJedi

kamilr

Import the old database to the new mysql server, copy over your old include/ost-config.php file from the older install to the new one, place the old include/ost-config.php file into the include/ folder of the new installation, update the database information in the config file to match the new server's information, visit osTicket in the web browser, and run the upgrade.

Cheers.