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!
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
Active Member
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=50292EvolveWebHosting wrote:What version are you upgrading from and out of curiosity, why are you interested in the Beta vs. a more stable release?
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.viperarchery wrote: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=50292EvolveWebHosting wrote:What version are you upgrading from and out of curiosity, why are you interested in the Beta vs. a more stable release?
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?
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
Active Member
Who is online
Users browsing this forum: No registered users and 8 guests