Post by viperarchery » Wed Oct 21, 2015 1:37 am

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!

Newbie

Posts

Joined
Thu Sep 10, 2015 8:06 pm

Post by EvolveWebHosting » Wed Oct 21, 2015 7:47 am

What version are you upgrading from and out of curiosity, why are you interested in the Beta vs. a more stable release?

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhosting.com


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA

Post by viperarchery » Wed Oct 21, 2015 11:35 am

EvolveWebHosting wrote:What version are you upgrading from and out of curiosity, why are you interested in the Beta vs. a more stable release?
It's the beta update for 14x to 1.5.1.2 heres a link to it. http://forum.opencart.com/viewtopic.php?f=19&t=50292
You have to do this beta update before you can update to the newest version.
I'm at a loss as to what to do next. Do I ignore the errors or what?

Newbie

Posts

Joined
Thu Sep 10, 2015 8:06 pm

Post by EvolveWebHosting » Thu Oct 22, 2015 8:34 am

viperarchery wrote:
EvolveWebHosting wrote:What version are you upgrading from and out of curiosity, why are you interested in the Beta vs. a more stable release?
It's the beta update for 14x to 1.5.1.2 heres a link to it. http://forum.opencart.com/viewtopic.php?f=19&t=50292
You have to do this beta update before you can update to the newest version.
I'm at a loss as to what to do next. Do I ignore the errors or what?
Gotcha. I mis understand which beta it was. I never used v1.4.x but I'm guessing you had some modules installed or other customization's that are throwing the errors. You may want to reach out to Qphoria. I believe he has a lot of experience with the different versions.

Opencart Hosting Plans, Domain Registration, Microsoft and Google Email and More
Visit our website for great deals and most importantly, fast and friendly support - www.evolvewebhosting.com


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA
Who is online

Users browsing this forum: No registered users and 4 guests