Just upgraded to latest version 1.10-rc2 and now getting db error ( fortunately have backup). Upgrader completed successfully without errors. Posting the details. DB Error #1054 Unknown column 'dept_id' in 'field list'---- Backtrace ----#0 C:\wamp\www\osticket\include\mysqli.php(183): osTicket->logDBError('DB Error #1054', '[SELECT count(d...')#1 C:\wamp\www\osticket\scp\emails.php(57): db_query('SELECT count(de...')#2 {main}
Checked the logs and it seems as the upgrader started .. other DB errors were there too. DB Error #1146 Table 'ost.ost_translation' doesn't exist---- Backtrace ----#0 C:\wamp\www\osticket\include\mysqli.php(318): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')#1 C:\wamp\www\osticket\include\class.orm.php(2741): db_prepare('SELECT A1.* FRO...')#2 C:\wamp\www\osticket\include\class.orm.php(2735): MySqlExecutor->execute()#3 C:\wamp\www\osticket\include\class.orm.php(2811): MySqlExecutor->_prepare()#4 C:\wamp\www\osticket\include\class.orm.php(1540): MySqlExecutor->getArray()#5 C:\wamp\www\osticket\include\class.orm.php(1363): ModelInstanceManager->fillTo(0)#6 C:\wamp\www\osticket\include\class.translation.php(899): ResultSet->valid()#7 C:\wamp\www\osticket\include\class.translation.php(920): CustomDataTranslation:('en_US')#8 C:\wamp\www\osticket\include\class.list.php(392): CustomDataTranslation:('7a52eb6cff3a4ce...')#9 C:\wamp\www\osticket\include\class.list.php(205): DynamicList->getLocal('name_plural')#10 C:\wamp\www\osticket\include\class.list.php(520): DynamicList->getPluralName()#11 : DynamicList:()#12 C:\wamp\www\osticket\include\class.forms.php(563): call_user_func(Array)#13 C:\wamp\www\osticket\include\class.forms.php(571): FormField:()#14 C:\wamp\www\osticket\include\class.forms.php(1002): FormField:('text')#15 : FormField->getImpl(Object(DynamicFormField))#16 C:\wamp\www\osticket\include\class.dynamic_forms.php(638): call_user_func_array(Array, Array)#17 C:\wamp\www\osticket\include\class.dynamic_forms.php(1385): DynamicFormField->__call('getImpl', Array)#18 C:\wamp\www\osticket\include\class.dynamic_forms.php(1385): DynamicFormField->getImpl(Object(DynamicFormField))#19 C:\wamp\www\osticket\include\class.dynamic_forms.php(990): DynamicFormEntryAnswer->getField()#20 C:\wamp\www\osticket\include\class.company.php(71): DynamicFormEntry->getAnswer('name')#21 C:\wamp\www\osticket\include\staff\footer.inc.php(5): Company->__toString()#22 C:\wamp\www\osticket\scp\upgrade.php(88): require('C:\wamp\www\ost...')#23 C:\wamp\www\osticket\scp\staff.inc.php(116): require('C:\wamp\www\ost...')#24 C:\wamp\www\osticket\scp\admin.inc.php(16): require('C:\wamp\www\ost...')#25 C:\wamp\www\osticket\scp\upgrade.php(16): require_once('C:\wamp\www\ost...')#26 C:\wamp\www\osticket\scp\staff.inc.php(116): require('C:\wamp\www\ost...')#27 C:\wamp\www\osticket\scp\autocron.php(18): require('C:\wamp\www\ost...')#28 {main}-----------------DB Error #1146 Table 'ost.ost_translation' doesn't exist---- Backtrace ----#0 C:\wamp\www\osticket\include\mysqli.php(318): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')#1 C:\wamp\www\osticket\include\class.orm.php(2741): db_prepare('SELECT A1.* FRO...')#2 C:\wamp\www\osticket\include\class.orm.php(2735): MySqlExecutor->execute()#3 C:\wamp\www\osticket\include\class.orm.php(2811): MySqlExecutor->_prepare()#4 C:\wamp\www\osticket\include\class.orm.php(1540): MySqlExecutor->getArray()#5 C:\wamp\www\osticket\include\class.orm.php(1363): ModelInstanceManager->fillTo(0)#6 C:\wamp\www\osticket\include\class.translation.php(899): ResultSet->valid()#7 C:\wamp\www\osticket\include\class.translation.php(920): CustomDataTranslation:('en_US')#8 C:\wamp\www\osticket\include\class.list.php(392): CustomDataTranslation:('7a52eb6cff3a4ce...')#9 C:\wamp\www\osticket\include\class.list.php(205): DynamicList->getLocal('name_plural')#10 C:\wamp\www\osticket\include\class.list.php(520): DynamicList->getPluralName()#11 : DynamicList:()#12 C:\wamp\www\osticket\include\class.forms.php(563): call_user_func(Array)#13 C:\wamp\www\osticket\include\class.forms.php(571): FormField:()#14 C:\wamp\www\osticket\include\class.forms.php(1002): FormField:('text')#15 : FormField->getImpl(Object(DynamicFormField))#16 C:\wamp\www\osticket\include\class.dynamic_forms.php(638): call_user_func_array(Array, Array)#17 C:\wamp\www\osticket\include\class.dynamic_forms.php(1385): DynamicFormField->__call('getImpl', Array)#18 C:\wamp\www\osticket\include\class.dynamic_forms.php(1385): DynamicFormField->getImpl(Object(DynamicFormField))#19 C:\wamp\www\osticket\include\class.dynamic_forms.php(990): DynamicFormEntryAnswer->getField()#20 C:\wamp\www\osticket\include\class.company.php(71): DynamicFormEntry->getAnswer('name')#21 C:\wamp\www\osticket\include\staff\footer.inc.php(5): Company->__toString()#22 C:\wamp\www\osticket\scp\upgrade.php(88): require('C:\wamp\www\ost...')#23 {main}---------------------------