Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Upgrade 1.9.15 to 1.10 error

PHP: 5.5 (ost v1.10 upgrade summary says its compatible)
OS: Ubuntu 14.04 LTS
MySQL: 5.7

I'm getting:
[SELECT A1.* FROM `ost_translation` A1 WHERE (A1.`lang` = 'en_US' AND
A1.`type` = 'phrase')] Table 'ost_database.ost_translation' doesn't
exist
This error repeats 7 times and then the upgrade script stops.

If I click to upgrade again, I get other errors similar to this:
[INSERT INTO `ost_role` SET `flags` = 1, `name` = 'Administradores
Role', `notes` = 'Administradores', `created` = NOW(), `permissions` =
'{\"ticket.create\":1, \"ticket.edit\":1, \"ticket.assign\":1,
\"ticket.transfer\":1, \"ticket.reply\":1, \"ticket.close\":1,
\"ticket.delete\":1, \"task.create\":1, \"task.edit\":1,
\"task.assign\":1, \"task.transfer\":1, \"task.reply\":1,
\"task.close\":1, \"task.delete\":1, \"canned.manage\":1,
\"emails.banlist\":1}', `updated` = NOW()] 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.

Comments

  • 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?
  • edited July 5
    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.
  • @ntozier 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 [core]: Upgrader Error (both below)

    DB Error #1146

    [SELECT A1.* FROM `ost_translation` A1 WHERE (A1.`lang` = 'en_US' AND A1.`type` = 'phrase')] 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::getTranslation('en_US')
    #12 (root)/include/class.list.php(396): CustomDataTranslation::translate('37eec2fe8f75003...')
    #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(567): call_user_func(Array)
    #17 (root)/include/class.forms.php(575): FormField::allTypes()
    #18 (root)/include/class.forms.php(1016): FormField::getFieldType('text')
    #19 [internal function]: 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:19:07 PM IP Address: 127.0.0.1


    [core]: Upgrader Error

    [/** * @signature 1ee831c854fe9f35115a3e672916bb91 * @version v1.10.0 * @title Make editable content translatable and add queues * * This patch adds support for translatable administratively editable * content, such as help topic names, department and group names, site page * and faq content, etc. * * This patch also transitions from the timezone table to the Olson timezone * database available in PHP 5.3. */ ALTER TABLE `ost_attachment` ADD `lang` varchar(16) AFTER `inline`] Duplicate column name 'lang'



    Log Date: Wed, 5 Jul 2017 15:21:16 IP Address: 127.0.0.1
  • 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.
Sign In or Register to comment.