Post by floweringmind » Mon Jun 29, 2009 1:23 pm

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??

Newbie

Posts

Joined
Tue Jun 16, 2009 1:30 pm

Post by tifosi » Mon Jun 29, 2009 4:53 pm

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

New member

Posts

Joined
Tue Feb 17, 2009 8:14 am

Post by djbrock » Tue Jun 30, 2009 1:46 pm

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.

New member

Posts

Joined
Thu Dec 04, 2008 10:37 pm

Post by Daniel » Wed Jul 01, 2009 1:43 am

if you did set number 5:

5. Go through the install as normal.

you should not get this error!!

User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by djbrock » Wed Jul 01, 2009 5:15 am

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.

New member

Posts

Joined
Thu Dec 04, 2008 10:37 pm

Post by djbrock » Wed Jul 01, 2009 7:34 am

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.

New member

Posts

Joined
Thu Dec 04, 2008 10:37 pm

Post by djbrock » Wed Jul 01, 2009 8:46 am

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

New member

Posts

Joined
Thu Dec 04, 2008 10:37 pm

Post by booksandtoys » Sat Jul 18, 2009 2:10 am

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?

New member

Posts

Joined
Wed Jun 17, 2009 4:43 am

Post by Daniel » Sat Jul 18, 2009 2:21 am

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?

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by booksandtoys » Sat Jul 18, 2009 4:32 am

Maybe, aye. Depends how much.

New member

Posts

Joined
Wed Jun 17, 2009 4:43 am

Post by readyman » Sat Jul 18, 2009 1:56 pm

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.

http://www.alreadymade.com
Follow me on twitter.com/alreadymade


User avatar
Global Moderator

Posts

Joined
Wed May 20, 2009 5:16 am
Location - Sydney

Post by booksandtoys » Sun Jul 19, 2009 3:46 am

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?

New member

Posts

Joined
Wed Jun 17, 2009 4:43 am

Post by Daniel » Sun Jul 19, 2009 4:27 am

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.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by booksandtoys » Sun Jul 19, 2009 4:53 am

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.

New member

Posts

Joined
Wed Jun 17, 2009 4:43 am

Post by booksandtoys » Sun Jul 19, 2009 4:54 am

Did a search and found the fix. Implementing it now.

New member

Posts

Joined
Wed Jun 17, 2009 4:43 am

Post by Daniel » Sun Jul 19, 2009 7:08 am

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.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by deluzione » Thu Aug 06, 2009 2:23 pm

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..

New member

Posts

Joined
Fri Jun 05, 2009 6:13 am
Who is online

Users browsing this forum: No registered users and 7 guests