v1.8.2 has been working perfectly but needing the login features has prompted the upgrade to v1.9.I followed the upgrade instructions: http://tmib.net/upgrading-osticket-1812-current-19rc but got stuck on step 6. instead of getting the Upgrader I get the Installer (which I have not run).My site has a number of tickets so I don't want to rebuild the whole database, only the updates for v1.9If I use my working v1.8.2 ost-config.php the admin panel shows osTicket (v1.9.0-3-gae5e138) and .../setup/ thinks v1.9 is installed but it isn't actually.Many thanks if anyone can help to get the Upgrader to run instead of the Installer or point me in the drection to upgrade the database structure to v1.9 if that's all the upgrader will do anyway.

If you have installed the system previously then it should run the upgrader.  If it doesn't run the upgrader then you are not pointing to the old database. (did you delete the ost-config.php file which contains your settings?)

Thanks for replying.I downloaded v1.9st unpacked it and uploaded all the files under the upload folder to my support folder overwriting all the files there. I did not delete ost-config.php at this stage.Then I opened our support/ url and the full installer window came up - not the upgrade window.Not wanting to loose existing data I didnt go any further.After my forum post, I noticed the site had stopped all mysql connections which turned out to be due to CageFS had mysteriously stopped working for the cPanel it was fixed by re initiating.Now the support/ url is opening the backend login and I receive emails announcing the following sql table not found errors:

Table 'mysite_ost.ost_content' doesn't exist

Table 'mysite_ost.ost_content' doesn't existI'm wondering if there is a simple way to upgrade the mysql database to 1.9 structure manually which may get it up and running.Alternatively should I restore my backup of v1.8.2 and start over?

Checking further I find the osTicket support folder is running PHP Version 5.4.28 - will v1.9 run under PHP 5.4.28 OK?v1.8.2 was running PHP 5.3 the site admin must have just changed it.

... more info! htaccess files under support and support/include became dysfunctional with the PHP504.28 upgrade which is now fixed.Now when support/setup is opened the following attached screen presents. What is this comment getting at: If you are trying to upgrade osTicket, then go to Admin Panel. ... can the upgrade be done manually from the admin panel?

Capture.PNG

If you go to the admin panel it should tell you that there is a pending update and then you can click on it.

No such prompt in the admin panel - as I said osTicket 'thinks' v1.9 is installed based on the "delete the setup prompt in admin".If there is no way to force an upgrade another solution is needed.This is what I see when opening the admin panel:

Capture1.PNG

Capture2.PNG

The only thing that I can think of would be for you to do a fresh install (using a different database) and then compare the database structures. Then manually run the SQL commands that the upgrader would have run based on if you actually need them.  The SQL can be found at: \include\upgrader\streams\core\The errors you reported above make me think that the ost_pages table was not renamed to ost_content.  So I would start by doing that.  Which is in the file: f5692e24-4323a6a8.patch.sql circa line 70.  This file is what contains the updates from 1.8.1.x to 1.9.  Here is the pertinent SQL:-- Add `content_id` to the content table to allow for translationsRENAME TABLE `%TABLE_PREFIX%page` TO `%TABLE_PREFIX%content`;ALTER TABLE `%TABLE_PREFIX%content`  CHANGE `type` `type` varchar(32) NOT NULL default 'other',  ADD `content_id` int(10) unsigned NOT NULL default 0 AFTER `id`;UPDATE `%TABLE_PREFIX%content`  SET `content_id` = `id`;

That's some good info thanks.Before your reply I decided to restore v1.8.2 which funtioned fine (with php 5.4.28) and go with v1.9.1 latest.Downloaded v1.9.1 zip, renamed folder upload --> support. Uploaded it and extracted to overwrite the existing support folder.This time the upgrader opened but the upgrade failed (the 'smile' progress window kept updating the count but never closed.Discovered repeating php error log entries: PHP Fatal error:  Class 'Phar' not found in /home/mysite/public_html/support/include/class.i18n.php on line 309Admin info:osTicket Version

v1.9.1 (0e29c8d)

Server Software

LiteSpeed

PHP Version

5.4.28

MySQL Version

5.0.96The admin log below repeats the last entries shown for 60 or so times.... hope you can stay with me ntozier becuause I really want to get this upgrade!

Capture1.PNG

Attached png image is not showing ... anyway this is the admin log info:Log TitleUpgrader - 8f99b8bf appliedUpgrader - 9ef33a06 appliedUpgrader - 4323a6a8 (task pending)Upgrader - 4323a6a8 (task pending) Upgrader - 4323a6a8 (task pending)Upgrader - 4323a6a8 (task pending) ... these entries keep repeating for a further 60 or so.Log Types all: Debug

Just enabled PHP Phar extension...And repeated the whole procedure. This time the upgrader didn't auto appear but successfully ran via the admin panel. So I'll spend some time checking things but looks like it's there or nearly so.Thank you for your help.

Please would you confirm that these are the only database update scripts that should be applied in the v1.8.2 upgrade to v1.9.1:4323a6a8-9ef33a06.patch.sql9ef33a06-8f99b8bf.patch.sqlf5692e24-4323a6a8.patch.sql

Those are the only three I see.

The upgrade to v1.9.1 is now successful.Most if not all issues were due to server configuration. Perhaps worth taking note is the php Phar addon must to be enabled before running the upgrade.Thanks ntozier.

Very welcome!  I'm going to mark this thread as resolved and close it. Please feel free to start a new thread if you have another comment, question, etc.

Write a Reply...