Finally got it working, i would revert back after i would see the errors in this module and i assume were old modules.
I imagine i have so much old code in the directory from upgrading the software, it would be nice if this was somehow removed during the upgrade.
I did notice that my options all had doubles so i deleted one of them.
thanks for the help.
I imagine i have so much old code in the directory from upgrading the software, it would be nice if this was somehow removed during the upgrade.
I did notice that my options all had doubles so i deleted one of them.
thanks for the help.
Yea sometimes the options are duplicated because in 1.4.x if you haveocartman wrote:Finally got it working, i would revert back after i would see the errors in this module and i assume were old modules.
I imagine i have so much old code in the directory from upgrading the software, it would be nice if this was somehow removed during the upgrade.
I did notice that my options all had doubles so i deleted one of them.
thanks for the help.
Product A
- Color : Red
and
Product B
- Color : Red
The script tries to merge the colors into the option table resulting in 2 Color: Red entries
As far as extra files, you "could" rename the admin, catalog, and system folder before uploading the new files, then copy the config.php file from the renamed admin folder to the new admin folder before continuing with the built in upgrade script that comes with the version you downloaded.
Ok I just did the beta upgrade and I'm getting all these errors. Can someone help me determine what I need to do? Im not sure where to go from here...
Here are the errors:
OpenCart 1.x Upgrade Script (BETA)
The following errors occured:
Could not execute this query: SELECT @dat:=`value` FROM oc_setting WHERE `group` = 'config' and `key` = 'config_description_1'; Unknown column 'group' in 'where clause'
Could not execute this query: SELECT @id:=`setting_id` FROM oc_setting WHERE `group` = 'config' and `key` = 'config_description_1'; Unknown column 'group' in 'where clause'
Could not execute this query: SELECT @dat:=`value` FROM oc_setting WHERE `group` = 'config' and `key` = 'config_welcome_1'; Unknown column 'group' in 'where clause'
Could not execute this query: INSERT INTO `oc_option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `oc_product_option`; Unknown column 'sort_order' in 'field list'
Could not execute this query: INSERT INTO `oc_option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `oc_product_option_description`; Table 'vipera6_ocar197.oc_product_option_description' doesn't exist
Could not execute this query: INSERT INTO `oc_option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `oc_product_option_value`; Unknown column 'sort_order' in 'field list'
Could not execute this query: INSERT INTO `oc_option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `oc_product_option_value_description` AS `povd` INNER JOIN `oc_product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Table 'vipera6_ocar197.oc_product_option_value_description' doesn't exist
The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions!
Here are the errors:
OpenCart 1.x Upgrade Script (BETA)
The following errors occured:
Could not execute this query: SELECT @dat:=`value` FROM oc_setting WHERE `group` = 'config' and `key` = 'config_description_1'; Unknown column 'group' in 'where clause'
Could not execute this query: SELECT @id:=`setting_id` FROM oc_setting WHERE `group` = 'config' and `key` = 'config_description_1'; Unknown column 'group' in 'where clause'
Could not execute this query: SELECT @dat:=`value` FROM oc_setting WHERE `group` = 'config' and `key` = 'config_welcome_1'; Unknown column 'group' in 'where clause'
Could not execute this query: INSERT INTO `oc_option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `oc_product_option`; Unknown column 'sort_order' in 'field list'
Could not execute this query: INSERT INTO `oc_option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `oc_product_option_description`; Table 'vipera6_ocar197.oc_product_option_description' doesn't exist
Could not execute this query: INSERT INTO `oc_option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `oc_product_option_value`; Unknown column 'sort_order' in 'field list'
Could not execute this query: INSERT INTO `oc_option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `oc_product_option_value_description` AS `povd` INNER JOIN `oc_product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Table 'vipera6_ocar197.oc_product_option_value_description' doesn't exist
The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions!
I'm looking to upgrade my current version of Opencart from 1.5.4.6 to version 2 is this the correct tutorial to follow?
not really, but you'll find huge amounts of information on this, if you search this Place by use of Google.
And in any case, you better remove everything on Themes and/or Extensions/VqMods first, and get
your place down to default Values, before even trying. Then, create another Shop and DB, to test it out.
And don't touch your running Place, before everything is tested and works, or you have a good chance
to end up in plain frustration, and no more running Shop.
Still, a version v.1.5.4.6 did not exist, as I recall...
Ernie
And in any case, you better remove everything on Themes and/or Extensions/VqMods first, and get
your place down to default Values, before even trying. Then, create another Shop and DB, to test it out.
And don't touch your running Place, before everything is tested and works, or you have a good chance
to end up in plain frustration, and no more running Shop.
Still, a version v.1.5.4.6 did not exist, as I recall...
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
1.5.4.6 did not exist but 1.5.6.4 was a released version.
2 Week FREE Trial of our Shared Hosting plans (DIrectAdmin or cPanel) for new customers
2 Week FREE Trial of Astra Firewall and Malware Scanner
Visit our website for full details and to start your trial today - www.evolvewebhost.com
Active Member
oops, sorry, I forgot
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Hello.
After upgrading, after step 12, I get the following error.
Any advice?
Fatal error: Uncaught exception 'Exception' with message 'Error: Could not load model total!' in /home2/cnielsen/public_html/new-beat.net/shop/system/engine/loader.php:169 Stack trace: #0 [internal function]: Loader->{closure}(Array, Array) #1 /home2/cnielsen/public_html/new-beat.net/shop/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array) #2 /home2/cnielsen/public_html/new-beat.net/shop/catalog/controller/common/cart.php(37): Proxy->__call('getTotal', Array) #3 /home2/cnielsen/public_html/new-beat.net/shop/catalog/controller/common/cart.php(37): Proxy->getTotal(Array) #4 [internal function]: ControllerCommonCart->index(Array) #5 /home2/cnielsen/public_html/new-beat.net/shop/system/engine/action.php(51): call_user_func_array(Array, Array) #6 /home2/cnielsen/public_html/new-beat.net/shop/system/engine/loader.php(24): Action->execute(Object(Registry), Array) #7 /home2/cnielsen/public_html/new-beat.net/shop/catalog/controller/common/header.php(129): Loader->controller('common/cart') #8 [internal functio in /home2/cnielsen/public_html/new-beat.net/shop/system/engine/loader.php on line 169
After upgrading, after step 12, I get the following error.
Any advice?
Fatal error: Uncaught exception 'Exception' with message 'Error: Could not load model total!' in /home2/cnielsen/public_html/new-beat.net/shop/system/engine/loader.php:169 Stack trace: #0 [internal function]: Loader->{closure}(Array, Array) #1 /home2/cnielsen/public_html/new-beat.net/shop/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array) #2 /home2/cnielsen/public_html/new-beat.net/shop/catalog/controller/common/cart.php(37): Proxy->__call('getTotal', Array) #3 /home2/cnielsen/public_html/new-beat.net/shop/catalog/controller/common/cart.php(37): Proxy->getTotal(Array) #4 [internal function]: ControllerCommonCart->index(Array) #5 /home2/cnielsen/public_html/new-beat.net/shop/system/engine/action.php(51): call_user_func_array(Array, Array) #6 /home2/cnielsen/public_html/new-beat.net/shop/system/engine/loader.php(24): Action->execute(Object(Registry), Array) #7 /home2/cnielsen/public_html/new-beat.net/shop/catalog/controller/common/header.php(129): Loader->controller('common/cart') #8 [internal functio in /home2/cnielsen/public_html/new-beat.net/shop/system/engine/loader.php on line 169
First of, thanks for this script. It does seem like an upgrade is possible.
From the readme I am a bit confused by steps 4a and 4b
4a what is meant by "ALL NEW OPENCART FILES"?
4b shouldn't it read "beta 3 upgrade zipfile"? Or is there a "beta 2 upgrade zipfile" involved?
From the readme I am a bit confused by steps 4a and 4b
4a what is meant by "ALL NEW OPENCART FILES"?
4b shouldn't it read "beta 3 upgrade zipfile"? Or is there a "beta 2 upgrade zipfile" involved?
Hi,
I just tried to upgrade my store from 1.4.9.3 to 1.5.1.2 using this script but I get the following errors:
Could not execute this query: INSERT INTO `option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `product_option`; Duplicate entry '377' for key 'PRIMARY'
Could not execute this query: INSERT INTO `option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `product_option_description`; Table 'Sql969431_1.product_option_description' doesn't exist
Could not execute this query: INSERT INTO `option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `product_option_value`; Duplicate entry '741' for key 'PRIMARY'
Could not execute this query: INSERT INTO `option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `product_option_value_description` AS `povd` INNER JOIN `product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Table 'Sql969431_1.product_option_value_description' doesn't exist
---
I tried to follow these indications in my sql but, for example, there's no duplicate entry 377 as it says for the first error...maybe I'm doing something wrong or I'm looking in the wrong place?
Please let me know what I should do to upgrade, thank you so much
I just tried to upgrade my store from 1.4.9.3 to 1.5.1.2 using this script but I get the following errors:
Could not execute this query: INSERT INTO `option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `product_option`; Duplicate entry '377' for key 'PRIMARY'
Could not execute this query: INSERT INTO `option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `product_option_description`; Table 'Sql969431_1.product_option_description' doesn't exist
Could not execute this query: INSERT INTO `option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `product_option_value`; Duplicate entry '741' for key 'PRIMARY'
Could not execute this query: INSERT INTO `option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `product_option_value_description` AS `povd` INNER JOIN `product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Table 'Sql969431_1.product_option_value_description' doesn't exist
---
I tried to follow these indications in my sql but, for example, there's no duplicate entry 377 as it says for the first error...maybe I'm doing something wrong or I'm looking in the wrong place?
Please let me know what I should do to upgrade, thank you so much
Hello all,
I will be using the [BETA3] Upgrade Script 14x to 1.5.1.2 tools found here:
http://forum.opencart.com/viewtopic.php ... 92#p237960
to upgrade a v1.4.9.3 site to 1.5.1.2, then upgrading that 1.5.1.2 site to OpenCart 3.x (as I understand it, the migration from 1.4.9.3 must occur in two steps ... cannot upgrade directly to 3.x from 1.4.9.3).
In looking at step 4a of the instructions, it says:
STEP 4a. UNZIP AND UPLOAD ALL THE NEW OPENCART FILES OVER YOUR EXISTING FILES
Can I assume that "THE NEW OPENCART FILES" in the statement above is referring to the OpenCart v1.5.1.2 files? Can I use OpenCart 1.5.6.1 instead of 1.5.1.2?
The reason I ask is that the download link on the OpenCart site for previous versions of OpenCart only goes back to v1.5.6.1.
So, can I use v1.5.6.1 OpenCart files for Step 4a, or do I have to find a download of OpenCart v1.5.1.2?
Thanks everyone!
Larry
I will be using the [BETA3] Upgrade Script 14x to 1.5.1.2 tools found here:
http://forum.opencart.com/viewtopic.php ... 92#p237960
to upgrade a v1.4.9.3 site to 1.5.1.2, then upgrading that 1.5.1.2 site to OpenCart 3.x (as I understand it, the migration from 1.4.9.3 must occur in two steps ... cannot upgrade directly to 3.x from 1.4.9.3).
In looking at step 4a of the instructions, it says:
STEP 4a. UNZIP AND UPLOAD ALL THE NEW OPENCART FILES OVER YOUR EXISTING FILES
Can I assume that "THE NEW OPENCART FILES" in the statement above is referring to the OpenCart v1.5.1.2 files? Can I use OpenCart 1.5.6.1 instead of 1.5.1.2?
The reason I ask is that the download link on the OpenCart site for previous versions of OpenCart only goes back to v1.5.6.1.
So, can I use v1.5.6.1 OpenCart files for Step 4a, or do I have to find a download of OpenCart v1.5.1.2?
Thanks everyone!
Larry
Hello all
I have a question is that this script will work for only OC 1.4xx version, right? what if i want to update OC 2.x to OC 3.x? Can anyone help me or suggest me a better way. I shall be very thankful for all of you.
Regards:
Dua
I have a question is that this script will work for only OC 1.4xx version, right? what if i want to update OC 2.x to OC 3.x? Can anyone help me or suggest me a better way. I shall be very thankful for all of you.
Regards:
Dua
Well, better post this in the commercial Forum Section, because nobody willCan anyone help me or suggest me a better way
be willing, to assist you for free, when it comes to upgrading some v.2.x Version
to OC v.3.x. And better make sure, to 'select' a real working v.3.x Version,
because this place is already full of problems, related to v.3.x releases.
I strongly advise you, to stay with an updated OC v.2.3.0.2 anyway, if you don't
plan, to depend of further (usually paid) support, just to keep your shop working,
as it should. This one here belongs to the best so far, as it looks:
https://github.com/IP-CAM/Opencart_2.3.0.2-updated
Good Luck !
Ernie
PS: If you don't believe me, better take some time, and read about it ....
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Who is online
Users browsing this forum: No registered users and 6 guests