The upgrade from 1.6 ST to 1.8.1 seemed to go OK but it stopped after it had apparently imported the attachments. I logged off and logged back on again and then completed the upgrade. However there were 1025 database errors: 4 x #1146, 1 x # 1062, 1020 x #1054. These were all as follows.
#1146 ($)Table 'csportalosticket.ost_session' doesn't exist<br /><br />---- Backtrace ----<br />#0 (root)/include/mysqli.php(138): osTicket->logDBError('DB Error #1146', '[DELETE FROM os...')<br />#1 (root)/include/class.ostsession.php(120): db_query('DELETE FROM ost...')<br />#2 (root)/include/class.auth.php(330): osTicketSession->destroy('226thbqgrffsusq...')<br />#3 (root)/include/class.auth.php(133): StaffAuthenticationBackend->login(Object(StaffSession), Object(osTicketAuthentication))<br />#4 (root)/scp/login.php(30): AuthenticationBackend:('administrator', '********', NULL)<br />#5 {main}#1062 (1)Duplicate entry '0-0-D' for key 'PRIMARY'<br /><br />---- Backtrace ----<br />#0 (root)/include/mysqli.php(138): osTicket->logDBError('DB Error #1062', '[INSERT INTO os...')<br />#1 (root)/include/upgrader/streams/core/d51f303a-dad45ca2.task.php(27): db_query('INSERT INTO ost...')<br />#2 (root)/include/class.upgrader.php(371): NewHtmlTemplate->run(30)<br />#3 (root)/include/class.upgrader.php(122): StreamUpgrader->doTask()<br />#4 (root)/include/ajax.upgrader.php(35): Upgrader->doTask()<br />#5 : UpgraderAjaxAPI->upgrade()<br />#6 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)<br />#7 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/upgrader', NULL)<br />#8 (root)/scp/ajax.php(114): Dispatcher->resolve('/upgrader')<br />#9 {main}#1054 (1020)Unknown column 'key' in 'field list'<br /><br />---- Backtrace ----<br />#0 (root)/include/mysqli.php(138): osTicket->logDBError('DB Error #1054', '[SELECT id, `ke...')<br />#1 (root)/include/class.file.php(322): db_query('SELECT id, `key...')<br />#2 (root)/include/upgrader/streams/core/15b30765-dd0022fb.task.php(111): AttachmentFile->save(Array)<br />#3 (root)/include/upgrader/streams/core/15b30765-dd0022fb.task.php(63): AttachmentMigrater->next()<br />#4 (root)/include/upgrader/streams/core/15b30765-dd0022fb.task.php(37): AttachmentMigrater->do_batch(27, 100)<br />#5 (root)/include/class.upgrader.php(371): AttachmentMigrater->run(30)<br />#6 (root)/include/class.upgrader.php(122): StreamUpgrader->doTask()<br />#7 (root)/include/ajax.upgrader.php(35): Upgrader->doTask()<br />#8 : UpgraderAjaxAPI->upgrade()<br />#9 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)<br />#10 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/upgrader', NULL)<br />#11 (root)/scp/ajax.php(114): Dispatcher->resolve('/upgrader')<br />#12 {main}
I can see all tickets but no attachments.