Page 1 of 1
Upgrade Process
Posted: Mon Jun 29, 2009 1:23 pm
by floweringmind
This is the WORST upgrade system ever. Why can't you just give database updates instead of this lame way of re-importing the old database which does not work in 99% of the cases??
Re: Upgrade Process
Posted: Mon Jun 29, 2009 4:53 pm
by tifosi
I have to agree, and I've posted as much in the past when I upgraded from 1.1.8 to 1.2.x and then got flamed because the upgrade utterly broke the system because of the changes in the structure and because I suggested - as a developer - that this method was flawed at best.
This is the only software of this class that I've used that totally deletes the database and then reimports the old database. The correct way of upgrading should be to do stepwise sequential updates depending on the initial version and then altering the tables as required. The best system I've seen so far is the vbulletin update process whose graphical interface shows the update process from release stream to release stream with user confirmation input.
The current system really depends on the user updating from the last release o the current one. In a diverging OS product such as this that is a BAD assumption. The majority of users will be on staggered release streams.
To delete the database renders any modifications which need database changes inefective and forces then to be reinstalled fully. Hardly condusive to a progressive mod database or a happy community.
A new update process should be high on the list.
S
Re: Upgrade Process
Posted: Tue Jun 30, 2009 1:46 pm
by djbrock
I noticed the 1.2.9 text says
1.2.8 > 1.2.9
To Upgrade:
1. First off backup your site.
2. Download a backup of your database.
3. Delete the files in your hosting directory
4. Upload the files from the download.
5. Go through the install as normal.
6. Once the install is finished import the database you backed up.
7. Goto the image directory from the backup and copy all the image and upload to the image directory on your hosting.
Why delete your /images directory? Just delete in the images in /upload/images instead.
BE SURE to delete the /install directory otherwise things won't work right. Even then I'm getting the error
Notice: Undefined index: description in /home/xxxxx/public_html/xxxxx/catalog/controller/product/category.php on line 52
when I go to my Category link from the customer pages.
Re: Upgrade Process
Posted: Wed Jul 01, 2009 1:43 am
by Daniel
if you did set number 5:
5. Go through the install as normal.
you should not get this error!!
Re: Upgrade Process
Posted: Wed Jul 01, 2009 5:15 am
by djbrock
I did #5. I re-entered all the database info as if it were a new install.
The only exception that I made at all was that I didn't delete the /images directory (why recopy everything???) and instead deleted all the images in the upload/images directory.
I did try to run the website and forgot to delete the /install directory which caused some display problems with the Latest Products, but once I got rid of that it worked fine.
I did not delete my original database on
Also, is it really necessary to delete the config.php each time? The info is the same when it is recreated.
Additionally, as with 1.2.8's upgrade, when I log in as a customer and try to check out I get this:
Notice: Undefined index: country_id in /home/xxxxxx/public_html/xxxx/catalog/model/payment/cheque.php on line 9
Notice: Undefined index: zone_id in /home/xxxx/public_html/xxxx/catalog/model/payment/cheque.php on line 9
Notice: Undefined index: country_id in /home/xxxx/public_html/xxxx/catalog/model/payment/paypal.php on line 9
Notice: Undefined index: zone_id in /home/xxxxx/public_html/xxxxx/catalog/model/payment/paypal.php on line 9
Notice: Undefined index: address_format in /home/xxxx/public_html/xxxxx/catalog/controller/checkout/payment.php on line 132
Notice: Undefined index: firstname in /home/xxxx/public_html/xxxx/catalog/controller/checkout/payment.php on line 151
Notice: Undefined index: lastname in /home/xxxx/public_html/xxxxxs/catalog/controller/checkout/payment.php on line 152
Notice: Undefined index: company in /home/xxxxx/public_html/xxxxx/catalog/controller/checkout/payment.php on line 153
Notice: Undefined index: address_1 in /home/xxxx/public_html/xxxx/catalog/controller/checkout/payment.php on line 154
Notice: Undefined index: address_2 in /home/xxxx/public_html/xxxxx/catalog/controller/checkout/payment.php on line 155
Notice: Undefined index: city in /home/xxxx/public_html/xxxxx/catalog/controller/checkout/payment.php on line 156
Notice: Undefined index: postcode in /home/xxx/public_html/xxxx/catalog/controller/checkout/payment.php on line 157
Notice: Undefined index: zone in /home/xxx/public_html/xxx/catalog/controller/checkout/payment.php on line 158
Notice: Undefined index: country in /home/xxx/public_html/xxx/catalog/controller/checkout/payment.php on line 159
Once I get past all of that my checkout still crashes. I'll do a complete new install and see if that helps.
Re: Upgrade Process
Posted: Wed Jul 01, 2009 7:34 am
by djbrock
I've reinstalled from scratch and all the same problems still exist. Only this time I can't get rid of the ipod crap in the Latest Products. I dropped all the tables in my db then imported my old db and they are still there. Last time deleting the /install directory got rid of them. It's gone but they're not.
Re: Upgrade Process
Posted: Wed Jul 01, 2009 8:46 am
by djbrock
In order to get rid of all the ipod etc. junk you MUST either create a NEW database or delete the old one, recreate it, then import your backup into which ever one you did. That gets rid of the junk in the Latest Products window and gets it back to normal. HOWEVER, I still have all of the other problems described above. Plus this once I check the payment type (Paypal or Check either one)
Warning: mysql_query() [
http://www.mysql.com/doc]: Unknown column 'coupon_id' in 'field list' in /home/xxx/public_html/xxx/system/database/mysql.php on line 19
Error: Unknown column 'coupon_id' in 'field list'
Error No: 1054
Re: Upgrade Process
Posted: Sat Jul 18, 2009 2:10 am
by booksandtoys
This is kind of putting me off upgrading from 1.2.8 to 1.2.9. Am I going to have problems if I stick to 1.2.8 for the minute and upgrade to 1.3 when it comes out? Are there any big security holes I'm not aware of in 1.2.8?
Re: Upgrade Process
Posted: Sat Jul 18, 2009 2:21 am
by Daniel
depending on your knowlege of php and msql you could just over write the the old files replace the config with your old ones and mannually change the db fields.
the upgrade instructions are there for people who are not very good with this sort of thing.
would you be will to have the site upgraded for a price?
Re: Upgrade Process
Posted: Sat Jul 18, 2009 4:32 am
by booksandtoys
Maybe, aye. Depends how much.
Re: Upgrade Process
Posted: Sat Jul 18, 2009 1:56 pm
by readyman
I would make a mirror and test that it's all working and then just import all the data.
1.2.9 has fixes and features that were fixed from 1.2.8 - you might find these later while using 1.2.8.
Another idea (for any upgrade)- You can also use a db compare tool(Toad from Quest) and a file/folder compare tool (winmerge.org) to view any changes from one version of the another.
Re: Upgrade Process
Posted: Sun Jul 19, 2009 3:46 am
by booksandtoys
OK, I've set up a mirror install, deleted the new database and imported the one from the 1.2.8 install. I think that may have been the wrong thing to do, because on my category pages I'm now getting this at the top:
Notice: Undefined index: description in /home/bookshop/public_html/129/catalog/controller/product/category.php on line 52
Warning: Cannot modify header information - headers already sent by (output started at /home/bookshop/public_html/129/catalog/controller/product/category.php:52) in /home/bookshop/public_html/129/system/library/response.php on line 65
Can anyone help?
Re: Upgrade Process
Posted: Sun Jul 19, 2009 4:27 am
by Daniel
the sql you are installling, does it have create tables and drop tables in it?
if so it should not be there!
you only are importing the data.
Re: Upgrade Process
Posted: Sun Jul 19, 2009 4:53 am
by booksandtoys
Yeah, that fixed it, thanks!
It seems to be working pretty much fine now, except for the related products. It's only bringing up one related product instead of the three or four I had set up for some of my products.
Re: Upgrade Process
Posted: Sun Jul 19, 2009 4:54 am
by booksandtoys
Did a search and found the fix. Implementing it now.
Re: Upgrade Process
Posted: Sun Jul 19, 2009 7:08 am
by Daniel
booksandtoys wrote:Yeah, that fixed it, thanks!
It seems to be working pretty much fine now, except for the related products. It's only bringing up one related product instead of the three or four I had set up for some of my products.
this is a bug. It will be fixed in the next release.
Re: Upgrade Process
Posted: Thu Aug 06, 2009 2:23 pm
by deluzione
With all due respect, Daniel. I love what you're doing and the amount of time you spend answering support questions like this, but wouldn't it be quicker for you to write an "upgrade.php"? That way, you know the upgrade works, and you have a lot less questions to answer.. I'm a newbie to OpenCart and ran into a lot of trouble upgrading to 1.3.0, including the above. Just a suggestion..