Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Upgrade from v1.9.9-1 to 1.10.4.fails #4594

Open
guidokuehler opened this issue Nov 4, 2018 · 2 comments
Open

Upgrade from v1.9.9-1 to 1.10.4.fails #4594

guidokuehler opened this issue Nov 4, 2018 · 2 comments

Comments

@guidokuehler
Copy link

Serverinformationen

osTicket-Version | v1.9.9-1-gbe2f138 (be2f138)
Server-Software | nginx/1.8.0
MySQL-Version | 8.0.13
PHP-Version | 5.6.4-4ubuntu6.4

We have made the upgrade 3 Times with the same result.

Upgrade Steps:

Backup the osTicket Files
Backup the Database
Download the osTicket-v1.10.4.zip to the System
Copy the Content of Upload-Directory in Archiv to osTicket-File-Location and overwrite Files
Call https://mySupporturl/scp/upgrade.php
Click Upgrade NOW
Error is displayed (Error occured.Aborting, Please wait.. while we upgrade your osTicket installation! Something went wrong).
We wait any hours then we receive the followed Error via EMail.

[/** * @Signature 0d6099a650cc7884eb59a040feab2ce8 * @Version v1.10.0 * @title Add events to the ticket thread * */ ALTER TABLE ost_osticket_ticket_event ADD id int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST, CHANGE ticket_id thread_id int(11) unsigned NOT NULL default '0', CHANGE staff username varchar(128) NOT NULL default 'SYSTEM', CHANGE state state enum('created','closed','reopened','assigned','transferred','overdue','edited','viewed','error','collab','resent') NOT NULL, ADD data varchar(1024) DEFAULT NULL COMMENT 'Encoded differences' AFTER state, ADD uid int(11) unsigned DEFAULT NULL AFTER username, ADD uid_type char(1) NOT NULL DEFAULT 'S' AFTER uid, RENAME TO ost_osticket_thread_event] Out of range value for column 'columns' at row 167

We see also follewed errors in sql-Logs:

log_id, log_type, title, log, logger, ip_address, created, updated

'1750', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/class.format.php(371): Company->__toString()
#26 (root)/include/staff/login.tpl.php(49): Format::htmlchars(Object(Company))
#27 (root)/scp/login.php(77): include_once('/var/www/it-pow...')
#28 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:02', '2018-11-04 07:41:02'
'1751', 'Error', 'DB Error #1054', '[UPDATE ost_osticket_staff SET extra = '{\"browser_lang\":\"en_US\"}', lastlogin = NOW(), updated = NOW() WHERE ost_osticket_staff.staff_id = 1 LIMIT 1] Unknown column 'extra' in 'field list'

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1054', '[UPDATE ost_os...\')<br /> #1 (root)/include/class.orm.php(3136): db_query(\'UPDATE ost_ost...', true, true)
#2 (root)/include/class.orm.php(597): MySqlExecutor->execute()
#3 (root)/include/class.staff.php(962): VerySimpleModel->save(true)
#4 (root)/include/class.staff.php(606): Staff->save()
#5 (root)/include/class.auth.php(510): Staff->onLogin(Object(osTicketAuthentication))
#6 (root)/include/class.auth.php(237): StaffAuthenticationBackend->login(Object(StaffSession), Object(osTicketAuthentication))
#7 (root)/scp/login.php(47): AuthenticationBackend::process('administrator', 'ITP131271', Array)
#8 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:13', '2018-11-04 07:41:13'
'1752', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:13', '2018-11-04 07:41:13'
'1753', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 (root)/scp/admin.inc.php(34): require('/var/www/it-pow...')
#28 (root)/scp/upgrade.php(16): require_once('/var/www/it-pow...')
#29 (root)/scp/staff.inc.php(118): require('/var/www/it-pow...')
#30 (root)/scp/autocron.php(18): require('/var/www/it-pow...')
#31 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:13', '2018-11-04 07:41:13'
'1754', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:13', '2018-11-04 07:41:13'
'1755', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:17', '2018-11-04 07:41:17'
'1756', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 (root)/scp/admin.inc.php(34): require('/var/www/it-pow...')
#28 (root)/scp/upgrade.php(16): require_once('/var/www/it-pow...')
#29 (root)/scp/staff.inc.php(118): require('/var/www/it-pow...')
#30 (root)/scp/autocron.php(18): require('/var/www/it-pow...')
#31 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:17', '2018-11-04 07:41:17'
'1757', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:17', '2018-11-04 07:41:17'
'1758', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:25', '2018-11-04 07:41:25'
'1759', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 (root)/scp/admin.inc.php(34): require('/var/www/it-pow...')
#28 (root)/scp/upgrade.php(16): require_once('/var/www/it-pow...')
#29 (root)/scp/staff.inc.php(118): require('/var/www/it-pow...')
#30 (root)/scp/autocron.php(18): require('/var/www/it-pow...')
#31 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:25', '2018-11-04 07:41:25'
'1760', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 {main}', '', 'xx.xx.xx.xx', '2018-11-04 07:41:25', '2018-11-04 07:41:25'
'1761', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/logs.php(57): include('/var/www/it-pow...')
#27 {main}', '', 'xx.xx.xx.xx', '2018-11-04 08:02:46', '2018-11-04 08:02:46'
'1762', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 (root)/scp/admin.inc.php(34): require('/var/www/it-pow...')
#28 (root)/scp/upgrade.php(16): require_once('/var/www/it-pow...')
#29 (root)/scp/staff.inc.php(118): require('/var/www/it-pow...')
#30 (root)/scp/autocron.php(18): require('/var/www/it-pow...')
#31 {main}', '', 'xx.xx.xx.xx', '2018-11-04 08:02:47', '2018-11-04 08:02:47'
'1763', 'Error', 'DB Error #1146', '[SELECT A1.* FROM ost_osticket_translation A1 WHERE (A1.lang = 'en_US' AND A1.type = 'phrase')] Table 'db_osticket_02.ost_osticket_translation' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3136): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3183): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1774): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(1818): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()
#10 (root)/include/class.translation.php(899): CachedResultSet->getIterator()
#11 (root)/include/class.translation.php(920): CustomDataTranslation::getTranslation('en_US')
#12 (root)/include/class.list.php(396): CustomDataTranslation::translate('58b98f2f0749bdd...')
#13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural')
#14 (root)/include/class.list.php(524): DynamicList->getPluralName()
#15 [internal function]: DynamicList::getSelections()
#16 (root)/include/class.forms.php(568): call_user_func(Array)
#17 (root)/include/class.forms.php(576): FormField::allTypes()
#18 (root)/include/class.forms.php(1017): FormField::getFieldType('text')
#19 [internal function]: FormField->getImpl(Object(DynamicFormField))
#20 (root)/include/class.dynamic_forms.php(599): call_user_func_array(Array, Array)
#21 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->__call('getImpl', Array)
#22 (root)/include/class.dynamic_forms.php(1344): DynamicFormField->getImpl(Object(DynamicFormField))
#23 (root)/include/class.dynamic_forms.php(953): DynamicFormEntryAnswer->getField()
#24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name')
#25 (root)/include/staff/footer.inc.php(5): Company->__toString()
#26 (root)/scp/upgrade.php(88): require('/var/www/it-pow...')
#27 {main}', '', 'xx.xx.xx.xx', '2018-11-04 08:02:47', '2018-11-04 08:02:47'

What we can or must do to get a upgradet working System?

Best Regards
Guido

clip0007
@Kwisher
Copy link

Kwisher commented Nov 16, 2018

Also experiencing similar issues. Please see the forum link below to see my details.

https://forum.osticket.com/d/93150-db-upgrade-issues-from-1-9-16-to-1-10-4

@benjaspers
Copy link

benjaspers commented Jun 20, 2019 •
edited

I had this same issue moving from v1.9.12 to v1.11, on MySQL 8.0.16.

I was attempting to figure out which column change was throwing the error in first statement of the 9143a511-0d6099a6.patch.sql file, so I broke them all out into separate ALTER TABLE statements and then the script ran fine.

Maybe to do with some of the column additions referencing changes that are happening in the same statement?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@Kwisher @guidokuehler @benjaspers