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?
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.
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.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
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.
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: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.
http://forum.opencart.com/viewtopic.php ... 87#p530247
You try to repair the database with that program
-peku-
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'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.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.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.
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.pm-netti wrote:Go in PhpMyAdmin to Database.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.
Delete in table setting all imageshow modules, 'banner_module','banner_status','slideshow_module', 'slideshow_status', 'bestseller_module', 'featured_module'..... etc.
Thanks
Cari album edisi luar negeri? Atau dalam negeri juga bisa. Kunjungi saja http://www.sawios.com Semoga bisa membantu.
1. You login Cpanel / PhpMyAdmin.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
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 ).
Last edited by pm-netti on Fri Dec 19, 2014 7:25 pm, edited 1 time in total.
Thank you so much for your instruction. Now, my front store looking so fine.... LOVEEEE.pm-netti wrote:1. You login Cpanel / PhpMyAdmin.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
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 ).
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.
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.
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.
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?
Route? What do you have for the default layout?
And then for Modules below that, one just adds in whatever modules are wanted, correct?
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.
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.
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.
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.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.
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.
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.pm-netti wrote:Go in PhpMyAdmin to Database.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.
Delete in table setting all imageshow modules, 'banner_module','banner_status','slideshow_module', 'slideshow_status', 'bestseller_module', 'featured_module'..... etc.
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.
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.
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 earlierDIHI 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.
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 NULL4. 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.
Who is online
Users browsing this forum: No registered users and 8 guests
