Post by lfairban » Tue Dec 02, 2014 4:48 am

Upgrading from 2.0.0 to 2.0.1?

Where can I find instructions on how to upgrade from 2.0.0 to 2.0.1.

Is it enough to just copy folders over the top of 2.0.0 to upgrade to 2.0.1?

From the look of the sql errors, I think a "module" table was added?

User avatar
New member

Posts

Joined
Fri Feb 28, 2014 5:01 am

Post by lfairban » Tue Dec 02, 2014 5:07 am

I think I figured out the install part of it but I have a few errors left.

I copied over the files and entered /install folder. The page then did some stuff (adding tables?) and finished. I closed the browser... and opened it up to the product page and got the following errors.

Code: Select all

Notice: Undefined index: banner_id in C:\inetpub\wwwroot\837oc2\catalog\controller\module\banner.php on line 15Notice: Undefined index: banner_id in C:\inetpub\wwwroot\837oc2\catalog\controller\module\slideshow.php on line 14Notice: Undefined index: limit in C:\inetpub\wwwroot\837oc2\catalog\controller\module\featured.php on line 20Notice: Undefined index: product in C:\inetpub\wwwroot\837oc2\catalog\controller\module\featured.php on line 24Warning: array_slice() expects parameter 1 to be array, null given in C:\inetpub\wwwroot\837oc2\catalog\controller\module\featured.php on line 24Warning: Invalid argument supplied for foreach() in C:\inetpub\wwwroot\837oc2\catalog\controller\module\featured.php on line 26Notice: Undefined index: banner_id in C:\inetpub\wwwroot\837oc2\catalog\controller\module\carousel.php on line 14Notice: Undefined index: banner_id in C:\inetpub\wwwroot\837oc2\catalog\controller\module\slideshow.php on line 14

User avatar
New member

Posts

Joined
Fri Feb 28, 2014 5:01 am

Post by pm-netti » Tue Dec 02, 2014 5:46 am

lfairban wrote:I think I figured out the install part of it but I have a few errors left.

I copied over the files and entered /install folder. The page then did some stuff (adding tables?) and finished. I closed the browser... and opened it up to the product page and got the following errors.

Code: Select all

Notice: Undefined index: banner_id in C:\inetpub\wwwroot\837oc2\catalog\controller\module\banner.php on line 15Notice: Undefined index: banner_id in C:\inetpub\wwwroot\837oc2\catalog\controller\module\slideshow.php on line 14Notice: Undefined index: limit in C:\inetpub\wwwroot\837oc2\catalog\controller\module\featured.php on line 20Notice: Undefined index: product in C:\inetpub\wwwroot\837oc2\catalog\controller\module\featured.php on line 24Warning: array_slice() expects parameter 1 to be array, null given in C:\inetpub\wwwroot\837oc2\catalog\controller\module\featured.php on line 24Warning: Invalid argument supplied for foreach() in C:\inetpub\wwwroot\837oc2\catalog\controller\module\featured.php on line 26Notice: Undefined index: banner_id in C:\inetpub\wwwroot\837oc2\catalog\controller\module\carousel.php on line 14Notice: Undefined index: banner_id in C:\inetpub\wwwroot\837oc2\catalog\controller\module\slideshow.php on line 14
Upgrade of OpenCart Theam is no change module table. Your must install modules again in Admin.

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by lfairban » Tue Dec 02, 2014 5:53 am

Perfect! Thanks. I almost did just that but I thought I'd wait for a reply on the boards.

User avatar
New member

Posts

Joined
Fri Feb 28, 2014 5:01 am

Post by lfairban » Tue Dec 02, 2014 10:49 pm

This is how I upgraded: NOT THAT IT'S CORRECT. Please, if this is incorrect, let me know.
1. Downloaded new version
2. Unzipped
3. Copied all files and folders under the "upload" folder (admin, catalog, image, install, and system + a few files) and copied them over the top of current site.
4. Went to the site/install folder (in browser) which triggers the update. Updating took about 1 minute+ so wait for it. In the case of 2.0.0 to 2.0.1, I think it added some new table/s (perhaps someone else knows what else).
5. Closed browser and deleted cache.
6. Opened upgraded site.

User avatar
New member

Posts

Joined
Fri Feb 28, 2014 5:01 am

Post by pm-netti » Tue Dec 02, 2014 11:05 pm

lfairban wrote:This is how I upgraded: NOT THAT IT'S CORRECT. Please, if this is incorrect, let me know.
1. Downloaded new version
2. Unzipped
3. Copied all files and folders under the "upload" folder (admin, catalog, image, install, and system + a few files) and copied them over the top of current site.
4. Went to the site/install folder (in browser) which triggers the update. Updating took about 1 minute+ so wait for it. In the case of 2.0.0 to 2.0.1, I think it added some new table/s (perhaps someone else knows what else).
5. Closed browser and deleted cache.
6. Opened upgraded site.
I say same than this:
http://forum.opencart.com/viewtopic.php ... 87#p530247

You try to repair the database with that program :)

-peku-

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by lfairban » Wed Dec 03, 2014 5:31 am

When these modules (banners, slideshow...) fail with ver. 2.0.1, is this a bug or just some bad data in the database? Both?

I'm wondering if this is something that's going to be addressed (fixed)? I'd rather not go through and do a reinstall.

User avatar
New member

Posts

Joined
Fri Feb 28, 2014 5:01 am

Post by Deeds4life » Wed Dec 03, 2014 6:03 am

lfairban wrote:When these modules (banners, slideshow...) fail with ver. 2.0.1, is this a bug or just some bad data in the database? Both?

I'm wondering if this is something that's going to be addressed (fixed)? I'd rather not go through and do a reinstall.
I had similar issues but it broke the site completely. Anything below the menu bar was gone. Tried uninstalling and installing slideshow, banner, ect. with no resolution. Restored a backup for the time being.

Newbie

Posts

Joined
Wed Dec 03, 2014 5:18 am

Post by pm-netti » Wed Dec 03, 2014 4:59 pm

lfairban wrote:When these modules (banners, slideshow...) fail with ver. 2.0.1, is this a bug or just some bad data in the database? Both?

I'm wondering if this is something that's going to be addressed (fixed)? I'd rather not go through and do a reinstall.
Go in PhpMyAdmin to Database.
Delete in table setting all imageshow modules, 'banner_module','banner_status','slideshow_module', 'slideshow_status', 'bestseller_module', 'featured_module'..... etc.

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by jurpro » Wed Dec 03, 2014 8:23 pm

pm-netti wrote:
lfairban wrote:When these modules (banners, slideshow...) fail with ver. 2.0.1, is this a bug or just some bad data in the database? Both?

I'm wondering if this is something that's going to be addressed (fixed)? I'd rather not go through and do a reinstall.
Go in PhpMyAdmin to Database.
Delete in table setting all imageshow modules, 'banner_module','banner_status','slideshow_module', 'slideshow_status', 'bestseller_module', 'featured_module'..... etc.
How to delete database? It's make me confuse. Sorry because I don't want after delete on some table, I loose my data. Please give me an instruction that I can understand.
Thanks

Cari album edisi luar negeri? Atau dalam negeri juga bisa. Kunjungi saja http://www.sawios.com Semoga bisa membantu. :)


User avatar
Active Member

Posts

Joined
Wed Jun 06, 2012 6:17 pm

Post by pm-netti » Wed Dec 03, 2014 8:48 pm

jurpro wrote:
pm-netti wrote: How to delete database? It's make me confuse. Sorry because I don't want after delete on some table, I loose my data. Please give me an instruction that I can understand.
Thanks
1. You login Cpanel / PhpMyAdmin.
2. Go to table 'setting'
3. Find field 'key' imagemodules slideshow, carousel, bestseller, featured, latest and special.
4. Remove those module settings in setting table.

Easier option:
Download that Opencart Coverter Dashboard and use it. ( See my signature ). 8)
Last edited by pm-netti on Fri Dec 19, 2014 7:25 pm, edited 1 time in total.

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by jurpro » Wed Dec 03, 2014 9:33 pm

pm-netti wrote:
jurpro wrote:
pm-netti wrote: How to delete database? It's make me confuse. Sorry because I don't want after delete on some table, I loose my data. Please give me an instruction that I can understand.
Thanks
1. You login Cpanel / PhpMyAdmin.
2. Go to table 'setting'
3. Find field 'key' imagemodules slideshow, caraousel, bestseller, featured, latest and special.
4. Remove those module settings in setting table.

Easier option:
Download that Opencart Coverter Dashboard and use it. ( See my signature ). 8)
Thank you so much for your instruction. Now, my front store looking so fine.... LOVEEEE.

ready for another level tested, THEME... !!!!! :) :)

Cari album edisi luar negeri? Atau dalam negeri juga bisa. Kunjungi saja http://www.sawios.com Semoga bisa membantu. :)


User avatar
Active Member

Posts

Joined
Wed Jun 06, 2012 6:17 pm

Post by lfairban » Wed Dec 03, 2014 11:16 pm

I deleted these rows:

banner_status
banner_module
slideshow_status
slideshow_module
carousel_status
carousel_module
featured_status
featured_product

I did not see a change when I added a banner back in. The page displays only the top contact menu, search, logo, cart summary, side menu (category box), and footer. I can't get anything else to show up on the index page.

User avatar
New member

Posts

Joined
Fri Feb 28, 2014 5:01 am

Post by lfairban » Wed Dec 03, 2014 11:53 pm

Unless there's a bug, I'm sure I'm just not understanding how this setup in OpenCart works; what should the basic "Default" setup look like in the "Layouts" screen?

Route? What do you have for the default layout?

And then for Modules below that, one just adds in whatever modules are wanted, correct?

User avatar
New member

Posts

Joined
Fri Feb 28, 2014 5:01 am

Post by lfairban » Thu Dec 04, 2014 10:42 pm

VICTORY!

I added in "common/home" to the route for the default layout and the banner appeared. I did this before but there must have been other errors going on at the time. Probably deleting the old modules from the settings table helped.

So, for now, thanks for your help.

Anyone know of a good place to learn about "Routes?" I don't really understand why/how they're used.

User avatar
New member

Posts

Joined
Fri Feb 28, 2014 5:01 am

Post by mindmelt » Fri Dec 05, 2014 8:33 am

Hi all,

Shouldn't this update procedure be made easier? I mean OC2.0 is a major improvement in design and most probably also in code. But when you are not a techie but a simple shop owner you are in for an adventure when you decide to upgrade. And we all know: you need to upgrade to stay safe. Right?

Isn't there a possibility to create an easy update path like in Joomla 3? Of course you need to take care of backups and all but when there is a (minor) update just pushing a button would be great. Going into phpmyadmin to delete some absolete table rows just isn't right.

Maybe the devs (and yes I do appreciate them, because I'm not a coder) could come up with such an (auto) update feature or at least an easier way of updating. That would make an already great piece of software even more awesome.

Newbie

Posts

Joined
Mon Dec 05, 2011 4:57 am

Post by steeevo » Sat Dec 06, 2014 9:20 pm

mindmelt wrote:Hi all,

Shouldn't this update procedure be made easier? I mean OC2.0 is a major improvement in design and most probably also in code. But when you are not a techie but a simple shop owner you are in for an adventure when you decide to upgrade. And we all know: you need to upgrade to stay safe. Right?

Isn't there a possibility to create an easy update path like in Joomla 3? Of course you need to take care of backups and all but when there is a (minor) update just pushing a button would be great. Going into phpmyadmin to delete some absolete table rows just isn't right.

Maybe the devs (and yes I do appreciate them, because I'm not a coder) could come up with such an (auto) update feature or at least an easier way of updating. That would make an already great piece of software even more awesome.
Exactly.

Why pitch opencart to people who want to start their own website and then expect them to learn how to build a website?

I am experiencing the problems detailed in this thread, it took me quite a while to learn how to perform the upgrade and now it seems the upgrade itself effectively ruins my website? With all due respect - that is the exact opposite of an upgrade.

The frustration comes not from being challenged to learn new things but from being unable to devote time towards my business.

I am now tasked with trying to assimilate the fixes described in this thread - bang goes my saturday afternoon.

Edit: I can't make it work.

Starting my website again from scratch. First port of call is to look elsewhere - this is not for me.

Newbie

Posts

Joined
Sat Dec 06, 2014 8:52 pm

Post by Qphoria » Wed Dec 31, 2014 2:26 am

pm-netti wrote:
lfairban wrote:When these modules (banners, slideshow...) fail with ver. 2.0.1, is this a bug or just some bad data in the database? Both?

I'm wondering if this is something that's going to be addressed (fixed)? I'd rather not go through and do a reinstall.
Go in PhpMyAdmin to Database.
Delete in table setting all imageshow modules, 'banner_module','banner_status','slideshow_module', 'slideshow_status', 'bestseller_module', 'featured_module'..... etc.
This is the ONLY correct answer, though mainly only the "xxx_status" records are the issue...and only for modules that use the new "submodule" system like latest, featured, banner, etc. Static modules like Category can be left alone.

The problem is that there are left over records in the setting table that aren't cleaned up when uninstalling the latest/featured/bestseller modules because in 2.0.1.1 they are referenced as "code" but in 2.0.0.0 and earlier they are referenced as "group". So when you uninstall, it only delete where "code = latest" but doesn't include where "group = latest". Technically "group" should have been renamed to "code" but the upgrade script doesn't work that way.. instead it just adds code to the table. So now you are stuck with an orphaned record like "latest_status" which makes the module code treat the new Latest "wrapper" shell module as an actual display module, and that is causing the error. The shell module doesn't have any attributes and should never be displayed... only the submodules should be. Perhaps this should be checked for better in the individual module's code. But this new "code" column also affects payments and other extensions because the code now checks for the "code" column and the data in the "group" column is lost.

So it's a tricky fix. You can't really add code to support "group" and "code" because for people who start with 2.0.1.1 and upgrade to later versions, there wouldn't be a "group" column. And it doesn't make sense to add "if exists group, do something" because that is sloppy.

Your only 4 options are to:
1. Uninstall ALL modules, payments, shipping, totals BEFORE upgrading to 2.0.1.1
or
2. Use this mysql command to drop the new "code" column and rename the "group" column to be "code" immediately before (or after) upgrade. But you still need to manually uninstall/re-install modules that have submodules. But at least it should fix payment, shipping, total modules from needing to be uninstalled/reinstalled (in theory)
or
3. Manually delete database entries for modules that now have submodules, as shown in this post, but there could be other custom ones that aren't covered here. Latest, Featured, Banner, Carousel, special, bestseller, welcome, html
or
4. Add code to each individual module to check that the $setting parameter has a valid non-null value for the "status" element.

It is unfortunately not an easily handled issue and there is no real good way that I can think of yet. It's not a hard and fast rule in any case so it can't really be done programatically.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by DIHI » Wed Dec 31, 2014 2:37 am

Qphoria

Thanks for your post, you seems like a helpful person so maybe you could help me out, I have requested support on the other thread announcing the release of 2.0.1.1 but have been ignored.

I have Opencart 2.0 running great, it is an out of the box install with no add ons just modifications to the stylesheet, could you please please please give me a step by step guide to upgrading to 2.0.1.1? I am familiar(ish) with PHPMyadmin and am confident in making changes where they are required I just need some instruction.

I would really appreciate it if you could help me out with this?

Thanks in advance.

New member

Posts

Joined
Sun Nov 30, 2014 12:44 am

Post by Qphoria » Wed Dec 31, 2014 3:04 am

DIHI wrote:Qphoria

Thanks for your post, you seems like a helpful person so maybe you could help me out, I have requested support on the other thread announcing the release of 2.0.1.1 but have been ignored.

I have Opencart 2.0 running great, it is an out of the box install with no add ons just modifications to the stylesheet, could you please please please give me a step by step guide to upgrading to 2.0.1.1? I am familiar(ish) with PHPMyadmin and am confident in making changes where they are required I just need some instruction.

I would really appreciate it if you could help me out with this?

Thanks in advance.
This is what i'm using now. Note this only handles the upgrade from 2.0.0.x to the latest. There are more steps if coming from 1.5.x or earlier

1. Uninstall all modules on 2.0.0.x or older
2. send this command via phpmyadmin. Be sure you change "oc_setting" to match your actual prefix:

Code: Select all

ALTER TABLE  `oc_setting` CHANGE  `group`  `code` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
3. Upload all new 2.0.1.x files over your existing 2.0.0.x store
4. Run the installer by going to http://mysite.com/install
5. After upgrade, login to admin
6. Reinstall your modules.
7. Now everything "should" be ok.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 21 guests