Cannot upgrade from v1.6 ST to v 1.8.0.2

sf395

I have backed up my old 1.6 ST site and MySQL database as osticket-1.6

I have put the upload directory from the osticket 1.8.0.2 unzipped download in Home/Dowmloads/osticket. I then perform the following

cd /var/www

sudo rm -rf osticket

sudo cp -rp osticket-1.6 osticket

sudo cp -r /home/Downloads/osticket/upload/* ./osticket

sudo chmod -R www-data.www-data ./osticket

In ./osticket/include there is the file ost-config.php which contains my MySQL config

I goto http://<hostname>/osticket and am greeted with the attached screen

Help please

sf395

The attachment did not get saved. Basically the screen says

The upgrader does NOT support upgrading from the current patch !

It then says it's checking for PHP v5.3 or greater (finds 5.5.3-1), MySQLi extension for PHP - (says module loaded) and MySQL v5.0 or greater - (finds 5.5.35). However there is an orange cross against each

sf395

Should've said. My 1.6 ST installation that I am upgrading from is running uner Apache 2.5 on Linux Mint 16

sf395

Apache 2.4, 64 bit Linux Mint 16

ntozier

Please re-attach the screen shot.The CLI commands that you included appear that your trying to upgrade from 1,6 to 1.6.

sf395

No. I (i) backed up the 1.6 install in the directory osticket into a directory called osticket-1.6, (ii) deleted the old osticket, (iii) created a new directory of this backed up installation called osticket - - and (iv) copied the files from the 1.8.0.2 uploads file into osticket.

This may seem a bit convoluted but I created the new osticket directory this way () because, when the upgrade failed, to try again I needed to get rid of the osticket directory containing the 1.8.0.2 files and start from scratch. I tried this several times.

sf395

Uploaded screen shot. Had to use Firefox: wouldn't work in Opera

Screenshot from 2014-02-06 17:58:31.png

sf395

It couldn't be 1.6 to 1.6 as there is no upgrade option for 1.6I should also say that I have made some changes to the database

structure: extra tables; extra columns in some default tables. I don't

know if this is significant.

sf395

Got a bit further. I had forgotten to restore my backed up MySQL database. However, I still have problems. The upgrade screen looks OK (green ticks against the software requirements). See attached screen

sf395

I now click upgarde and get to teh next screen

sf395

I click Upgrade now and it fails. The system logs show:

sf395

The top one : Upgrade Error is showing that it fails to rename ost_email_filter -> ost_filter because ost_filter exists. I log off, drop the table ost_filter from the database, log on and proceed as abov. This time it fails because table ost_filter_rule exists. And so on and so on.Any advice welcome

sf395

I should've said that it has carried out all operations up to and including 1.7-rc2 - nested help topics. See attached screen shot

sf395

I have the following shell script that sets up the osticket 1.8.0.2 directory pre to running the install process. Note: I'm not running xampp on this box: I have separate Apache, MySQL, and PHP installations. However, our production server has lampp installed and so I have a virtual website set up to use the same structure as this installation.#!/bin/bashecho "Stopping Apache"service apache2 stop#echo "Setting up /opt/lampp/htdocs/csportal/osticket"echo "Delete old osticket directory"rm -rf /opt/lampp/htdocs/csportal/osticketecho "Copy 1.6 backup directory as osticket"cp -rp /opt/lampp/htdocs/csportal/osticket-1.6 /opt/lampp/htdocs/csportal/osticketecho "Copy 1.8.0.2 upload directory contents into osticket directory"cp -rf /opt/lampp/htdocs/csportal/upload/* /opt/lampp/htdocs/csportal/osticket/echo "Change ownership of osticket directory to www-data.www-data"chown -R www-data.www-data /opt/lampp/htdocs/csportal/osticket#echo "Loading backup csportalosticket database"mysql -uosticket -posticket -D csportalosticket < /home/Projects/work/database_dumps/topcat_database_dumps/csportalosticket.sqlecho "Starting Apache"service apache2 startecho Done

sf395

I did manage to do the upgrade but it meantdeleting the four extra tables I had createddeleting all from ost_teamdropping tables ost_canned_response, ost_group_dept_access.(I think that's all). As I did this incrementally at each stage I had to restore my 1.6 MySQL database, drop the table specified, dump the database and run the script above.I have made a lot of bespoke changes to our current installation so I will not be upgrading our production system any time soon

ntozier

I have several custom tables in both my implementations (4 in one, 6 in the other) and heavily modified my installations and I have never had a problem upgrading like you've discussed here. I'm mostly waiting for plugins to be documented etc so that I can start making more plugins to re-add a few things. (like my pending/autoclose mod).

sf395

Thanks for your input. I'm going through the process, modifying my process again as I'm going to have to get it working. I must admit I dropped the extra tables because I wanted to started from a vanilla schema in 1.6. However, they were to provide ticket form fields that I can now define in 1.8 so all I need is a copy of the 1.6 database so that I can get the field values to update the converted tickets.Thanks again

ntozier

Very welcome. :)

sf395

Enormous problems again. I use the following script to set-up my system. I don't think the chmod statements are necessary.echo "Stopping Apache"service apache2 stop#echo "Setting up /opt/lampp/htdocs/csportal/osticket"echo "Delete old osticket directory"#rm -rf /opt/lampp/htdocs/csportal/osticket#echo "Copy 1.6 backup directory as osticket"cp -rp /home/Projects/work/osticketUpgrade/osticket-1.6-live /opt/lampp/htdocs/csportal/osticket#echo "Copy 1.8.0.2 upload directory contents into osticket directory"cp -rf /home/Projects/work/osticketUpgrade/upload-1.8.0.2/* /opt/lampp/htdocs/csportal/osticket/#echo "Change ownership of osticket directory to www-data.www-data"chown -R www-data.www-data /opt/lampp/htdocs/csportal/osticket#echo "Give group read-write access to attachments directory"chmod -R g+w /opt/lampp/htdocs/csportal/osticket/attachmentsecho "Give all read & execute access to attachments directory"chmod -R a+rx /opt/lampp/htdocs/csportal/osticket/attachments#echo "Loading backup csportalosticket database"mysql -uosticket -posticket -D csportalosticket < /home/Projects/work/osticketUpgrade/csportalosticket.sql#echo "Starting Apache"service apache2 start#echo Done