Upgrading from 1.9.16 to 1.14.1 upgrade now error

keitharo

Hello everyone, been trying to do this for the past day but I wasn't able to do it hence I'm here.

I followed the steps from the upgrade and migration page. Replaced the entire upload folder with the 1.14.1 files. Then i went to ip/scp/admin.php and tried to upgrade. Now the problem is when I clicked upgrade now, it shows me the error shown below

I went ost_syslog and found the following problems:

All the files in the upload folder has read write access as well.

My environments are:
PHP 5.6.40
Amazon Linux AMI 2018.03
RHEL 7
5.5.62 MySQL Community Server (GPL)
Current version osTicket 1.9.16

What should i do to upgrade successfully? Thank you for all the help!

ntozier

You appear to have done things correctly.
Your screen shot only displays a partial error. (after lang ...)

My guess is that the upgrade script is trying to add a column to the ost_translation table and that column already exists.
Why does it already exist? I'm not sure.

You can do any of the the following and it might solve your issue:

Try the system and see if it works (in which case you can ignore the error.
restore the database to before you ran the upgrader, edit the database and remove that column so the upgrader will run; There is a chance that you will have to repeat this step until you edit any other tables that error out later in the upgrade process.
or try to upgrade to 1.10 first and then upgrade to 1.14.1.

Either way i will report this thread to the devs to see if they have any additional insight into the problem.

keitharo

Hello KevinTheJedi and ntozier ,

I fixed the error by upgrading to PHP7.2. Also, i did not mention earlier but the issue might have been caused by NGINX due to my www and nginx config files not being set properly. But i have no idea why it was working for the previous version 1.09 though.

For future reference, this was how i fixed it. I added the following lines in /var/run/php-fpm/www.sock

listen = /var/run/php-fpm/www.sock 
listen.owner = nginx 
listen.group = nginx 
listen.mode = 0664 
user = nginx 
group = nginx

In etc/nginx/nginx conf i added

fast_cgi_pass = unix:/var/run/php-fpm/www.sock;

After that, i restarted nginx and php services and i managed to upgrade without errors.

The earlier error in mysql was:
[SELECT A1.* FROMost_translationA1 WHERE A1.lang= 'en_US' AND A1.type= 'phrase'] Table 'osticket.ost_translation' doesn't exist ---- Backtrace ---- #0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...') #1 (root)/include/class.orm.php(3459): db_query('SELECT A1.* FRO...', true, true) #2 (root)/include/class.orm.php(3506): MySqlExecutor->execute() #3 (root)/include/class.orm.php(1999): MySqlExecutor->getArray() #4 (root)/include/class.orm.php(2043): ModelInstanceManager->{closure}() #5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next() #6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind() #7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid() #8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807) #9 (root)/include/class.orm.php(1729): 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(532): DynamicList->getPluralName() #15 [internal function]: DynamicList::getSelections() #16 (root)/include/class.forms.php(605): call_user_func(Array) #17 (root)/include/class.forms.php(613): FormField::allTypes() #18 (root)/include/class.forms.php(1117): FormField::getFieldType('text') #19 [internal function]: FormField->getImpl(Object(DynamicFormField)) #20 (root)/include/class.dynamic_forms.php(606): call_user_func_array(Array, Array) #21 (root)/include/class.dynamic_forms.php(1371): DynamicFormField->__call('getImpl', Array) #22 (root)/include/class.dynamic_forms.php(1371): DynamicFormField->getImpl(Object(DynamicFormField)) #23 (root)/include/class.dynamic_forms.php(967): DynamicFormEntryAnswer->getField() #24 (root)/include/class.company.php(71): DynamicFormEntry->getAnswer('name') #25 (root)/include/client/footer.inc.php(5): Company->__toString() #26 (root)/offline.php(34): require('/var/www/ostick...') #27 (root)/client.inc.php(38): include('/var/www/ostick...') #28 (root)/index.php(16): require('/var/www/ostick...') #29 {main}

AND

[SELECT A1.* FROMost_translationA1 WHERE A1.type= 'article' AND A1.object_hash= 'cc78cd3b9390da92'] Table 'osticket.ost_translation' doesn't exist ---- Backtrace ---- #0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1146', '[SELECT A1.* FR...') #1 (root)/include/class.orm.php(3459): db_query('SELECT A1.* FRO...', true, true) #2 (root)/include/class.orm.php(3506): MySqlExecutor->execute() #3 (root)/include/class.orm.php(1999): MySqlExecutor->getArray() #4 (root)/include/class.orm.php(2043): ModelInstanceManager->{closure}() #5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next() #6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind() #7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid() #8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807) #9 (root)/include/class.orm.php(1336): CachedResultSet->asArray() #10 (root)/include/class.translation.php(1036): QuerySet->all() #11 (root)/include/class.page.php(94): CustomDataTranslation::allTranslations('cc78cd3b9390da9...', 'article') #12 (root)/include/class.page.php(80): Page->getAllTranslations() #13 (root)/include/class.page.php(70): Page->_getLocal('body', false) #14 (root)/include/class.page.php(73): Page->getLocalBody() #15 (root)/offline.php(28): Page->getBodyWithImages() #16 (root)/client.inc.php(38): include('/var/www/ostick...') #17 (root)/index.php(16): require('/var/www/ostick...') #18 {main}

This was the error in my nginx log

[error] 23939#0: *1729 connect() failed (111: Connection refused) while connecting to upstream, client: xx.xx.xx.xx, server: _, request: "GET /favicon.ico HTTP/2.0", upstream: "fastcgi://127.0.0.1:9000", host: "xx.xx.xx.xx", referrer: "https://xx.xx.xx.xx/"

Would appreciate if you could enlighten me about what was the initial problem there

KevinTheJedi

@keitharo

Post the full error please.

Cheers.

KevinTheJedi

@keitharo

I've only seen major Upgrade Issues with PHP 7.4, not 5.6. Maybe your specific build of PHP 5.6 didn't want to upgrade for some reason? 🤣

Cheers.