PHP: 5.5 (ost v1.10 upgrade summary says its compatible)OS: Ubuntu 14.04 LTSMySQL: 5.7I'm getting: Table 'ost_database.ost_translation' doesn't

existThis error repeats 7 times and then the upgrade script stops.If I click to upgrade again, I get other errors similar to this: Duplicate entry

'Administradores Role' for key 'name'And if I keep clicking to upgrade I always get different errors over and over until it quits to a screen saying "Upgrade Aborted"I tried truncating ost_role table, pre-creating ost_translation, but I always get a new error about some table already created or non-existence table errors. I could do a manual upgrade but I don't know how to do it.

Do you have language packs installed?

Yes, but I get the same errors even if I remove the pt_BR.phar file (inside include/i18n).

Did you upgrade the language packs PRIOR to upgrading osTicket?

No, should I do that? To upgrade I only need to replace the phar file inside i18n?

Q: No, should I do that? A: Yes.Q: To upgrade I only need to replace the phar file inside i18n?A: Yes you would replace it with the new version.

@[deleted] I did what you suggested, by putting the new language pack version (replacing the old one) at i18n folder but i'm still getting the translate table error. I got the DB Error #1146 repeated 7 times (same content) and one : Upgrader Error (both below)DB Error #1146 Table 'ost_database.ost_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(3133): db_query('SELECT A1.* FRO...', true, true) #2 (root)/include/class.orm.php(3180): MySqlExecutor->execute() #3 (root)/include/class.orm.php(1771): MySqlExecutor->getArray() #4 (root)/include/class.orm.php(1815): ModelInstanceManager->{closure}() #5 (root)/include/class.orm.php(1794): CallbackSimpleIterator->next() #6 (root)/include/class.orm.php(1803): 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:('en_US') #12 (root)/include/class.list.php(396): CustomDataTranslation:('37eec2fe8f75003...') #13 (root)/include/class.list.php(209): DynamicList->getLocal('name_plural') #14 (root)/include/class.list.php(524): DynamicList->getPluralName() #15 : DynamicList:() #16 (root)/include/class.forms.php(567): call_user_func(Array) #17 (root)/include/class.forms.php(575): FormField:() #18 (root)/include/class.forms.php(1016): FormField:('text') #19 : FormField->getImpl(Object(DynamicFormField)) #20 (root)/include/class.dynamic_forms.php(596): call_user_func_array(Array, Array) #21 (root)/include/class.dynamic_forms.php(1339): DynamicFormField->__call('getImpl', Array) #22 (root)/include/class.dynamic_forms.php(1339): DynamicFormField->getImpl(Object(DynamicFormField)) #23 (root)/include/class.dynamic_forms.php(948): 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/vhosts...') #27 {main}

Log Date: 07/05/2017 03 PM IP Address: 127.0.0.1: Upgrader Error Duplicate column name 'lang'

Log Date: Wed, 5 Jul 2017 15 IP Address: 127.0.0.1

5 days later

Hello,I've had a similar problem and no one was able to help.http://forum.osticket.com/d/discussion//upgrading-from-1-9-14-to-1-10-unknown-column-ticket-id-in-new#latest

3 months later

Hello,Finally I've solved my problem. Posting the solution in case anyone is in need as I was.First and very important, do backups of your database and all files, in case anything goes wrong you will have to restore your data back. I've had to restore from backups at least some five times until getting it right.- First, upgrade to the next stable version in 1.9.x (if there is one), to me it was at this time 1.9.16.- Rename/copy your OST database, ex. ostdatabase to ostdatabase_bk (if you used copy then DROP ostdatabase).- Create a new and empty database with the same original name: ostdatabase- From the downloaded ZIP (ex. osTicket-v1.9.16.zip) you can find inside this folder: (\upload\setup\inc\streams\core) in it this SQL file (install-mysql.sql).- Execute the file in the new database ostdatabase. This will create the needed tables empty.- Now, copy ONLY the data from the database ostdatabase_bk (do not create any new objects missing, such as tables, indexes, etc., only data rows).- Download the the new stable version 1.10 (at this time to me was 1.10.1) and upload it.- Goto now to your OST dashboard, and you will be asked to UPGRADE.- Execute upgrade.If everything goes well as it did for me, it should work and now you have the new OST 1.10.

a year later
Write a Reply...