Cannot upgrade from 1.8-git to 1.9.8

rocklee44

Hi all,I cannot upgrade osTicket from 1.8-git to 1.9.8, I followed insctruction here : http://osticket.com/wiki/Upgrade_and_migrationAt step "Running upgrade script", it get some error and cannot finish, these are some error in httpd log :PHP Warning: openssl_decrypt(): IV passed is 22 bytes long which is longer than the 16 expected by selected cipher, truncating in /var/www/html/osticket/upload/include/class.crypto.php on line 537, referer: http://helpdesk.itl.com/scp/upgrade.phpPHP Fatal error: Uncaught exception 'Exception' in /var/www/html/osticket/upload/include/class.orm.php\nStack trace:\n#0 /var/www/html/osticket/upload/include/class.list.php(1152): VerySimpleModel->save(true)\n#1 /var/www/html/osticket/upload/include/upgrader/streams/core/8f99b8bf-03ff59bf.task.php(31): TicketStatus:(Array)\n#2 /var/www/html/osticket/upload/include/class.upgrader.php(372): SequenceLoader->run(30)\n#3 /var/www/html/osticket/upload/include/class.upgrader.php(122): StreamUpgrader->doTask()\n#4 /var/www/html/osticket/upload/include/ajax.upgrader.php(35): Upgrader->doTask()\n#5 : UpgraderAjaxAPI->upgrade()\n#6 /var/www/html/osticket/upload/include/class.dispatcher.php(145): call_user_func_array(Array, Array)\n#7 /var/www/html/osticket/upload/include/class.dispatcher.php(38): UrlMatcher->dispatch('/upgrader', NULL)\n#8 /var/www/html/osticket/upload/scp/ajax.php(186): Dispatcher->resolve('/upgrader')\n#9 {main}\n thrown in /var/www/html/osticket/upload/include/class.orm.php on line 224, referer: http://helpdesk.itl.com/scp/upgrade.phpPHP Fatal error: Uncaught exception 'Exception' in /var/www/html/osticket/upload/include/class.orm.php\nStack trace:\n#0 /var/www/html/osticket/upload/include/upgrader/streams/core/8f99b8bf-03ff59bf.task.php(16): VerySimpleModel->save()\n#1 /var/www/html/osticket/upload/include/class.upgrader.php(372): SequenceLoader->run(30)\n#2 /var/www/html/osticket/upload/include/class.upgrader.php(122): StreamUpgrader->doTask()\n#3 /var/www/html/osticket/upload/include/ajax.upgrader.php(35): Upgrader->doTask()\n#4 : UpgraderAjaxAPI->upgrade()\n#5 /var/www/html/osticket/upload/include/class.dispatcher.php(145): call_user_func_array(Array, Array)\n#6 /var/www/html/osticket/upload/include/class.dispatcher.php(38): UrlMatcher->dispatch('/upgrader', NULL)\n#7 /var/www/html/osticket/upload/scp/ajax.php(186): Dispatcher->resolve('/upgrader')\n#8 {main}\n thrown in /var/www/html/osticket/upload/include/class.orm.php on line 224, referer: http://helpdesk.itl.com/scp/upgrade.php?c=2&r=35PHP Fatal error: Uncaught exception 'Exception' in /var/www/html/osticket/upload/include/class.orm.php\nStack trace:\n#0 /var/www/html/osticket/upload/include/upgrader/streams/core/8f99b8bf-03ff59bf.task.php(16): VerySimpleModel->save()\n#1 /var/www/html/osticket/upload/include/class.upgrader.php(372): SequenceLoader->run(30)\n#2 /var/www/html/osticket/upload/include/class.upgrader.php(122): StreamUpgrader->doTask()\n#3 /var/www/html/osticket/upload/include/ajax.upgrader.php(35): Upgrader->doTask()\n#4 : UpgraderAjaxAPI->upgrade()\n#5 /var/www/html/osticket/upload/include/class.dispatcher.php(145): call_user_func_array(Array, Array)\n#6 /var/www/html/osticket/upload/include/class.dispatcher.php(38): UrlMatcher->dispatch('/upgrader', NULL)\n#7 /var/www/html/osticket/upload/scp/ajax.php(186): Dispatcher->resolve('/upgrader')\n#8 {main}\n thrown in /var/www/html/osticket/upload/include/class.orm.php on line 224, referer: http://helpdesk.itl.com/scp/upgrade.php?c=1&r=67We have updated our osticket installation from 1.7 to 1.8 before.

Since then, we have a problem with our mail system sometimes. For example,

osticket can't fetch the mails from the IMAP Account with uft8 encode/decode problemSo I followed instruction here : https://github.com/osTicket/osTicket-1.8/issues/475 , and edit file class.crypto.php line 537 //$iv = substr($ciphertext, 0, $ivlen); //$ciphertext = substr($ciphertext, $ivlen); $iv = mb_substr($ciphertext, 0, $ivlen,'ASCII'); $ciphertext = mb_substr($ciphertext, $ivlen,1000,'ASCII');Then problem "fetch email" was gone but now I cannot upgrade to version 1.9.8Please give me some advice.Thanks for your help.

Chefkeks

Can you tell us which version you are at? (Admin panel > dashboard > system information)

Asking so stupid since every version you download from github is 1.8-git. Only the downloads from osTicket.com/download include the real version number like 1.9.8, so that you could run nearly every version between 1.8.0.0 and 1.9.7.

Apart from that I would always recommend to revert such changes back to default prior to an upgrade and if a upgrade does not work e.g. from 1.8.0.0 to 1.9.8 I'd try to upgrade in several steps to the latest version, so e.g first to 1.8.5 and then to 1.9.0 and then to 1.9.8. Since I don't know what version you are actually running nor your infrastructure (web server?, PHP version?, MySQL version?) it's currently really hard to advise.

Beside, please always do a backup of the database as well as the osTicket directory on your webserver before an upgrade!

rocklee44

Hi Chefkeks,This is infrastructure information blank My server : Centos 6.4 64 bit. How do I know my osTicket version since it show only :

1.8-git (?)As your advice, I should try to upgrade my osTicket to 1.8.5 or 1.8.6 or 1.8.7 or 1.8.8 or 1.8.9 to see if one of them succeed first , then then to 1.9.0 and then to 1.9.8 ?

Chefkeks

That was just an example on how to upgrade in several steps, but before you can upgrade we need to found out what version you are currently running. So can you (after a backup) again try to upgrade an post a screenshot of the upgrader that appears when you login to scp since the screenshot should show the missing database patches ;)

Unfortunately the screenshot above does not include the hash/signature of the github commit behind the version number. Instead it just shows (?) which does not help since we don't know if you are at 1.8.0 or 1.9.2 or etc.

rocklee44

Thank you Chefkeks,Of course I did backup before upgrading , so I can reverse old version when problem happen.I will try to upgrade again with every version from 1.8.5 to 1.8.9 and post screenshots of upgrader that appears, last time it showed 2 missing database patches, it upgrade the first one successfully but fail at second one.I will update more.

Chefkeks

Sounds like you got a good plan. Let me know the progress and maybe when you're then at one official version upgrading further shouldn't be that difficult ;)