[BETA3] Upgrade Script 14x to 1.5.1.2 PLUS PRODUCT OPTIONS!

Code: Select all

STEP 4a. UNZIP AND UPLOAD ALL THE NEW OPENCART FILES OVER YOUR EXISTING FILES

Code: Select all

[highlight]SyntaxError: JSON.parse: unexpected non-whitespace character after JSON data

OK

{"country_id":"229","name":"Venezuela","iso_code_2":"VE","iso_code_3":"VEN","address_format":"","postcode_required":"0","zone":[{"zone_id":"3726","country_id":"229","code":"AM","name":"Amazonas","status":"1"},{"zone_id":"3727","country_id":"229","code":"AN","name":"Anzoategui","status":"1"},{"zone_id":"3728","country_id":"229","code":"AP","name":"Apure","status":"1"},{"zone_id":"3729","country_id":"229","code":"AR","name":"Aragua","status":"1"},{"zone_id":"3730","country_id":"229","code":"BA","name":"Barinas","status":"1"},{"zone_id":"3731","country_id":"229","code":"BO","name":"Bolivar","status":"1"},{"zone_id":"3732","country_id":"229","code":"CA","name":"Carabobo","status":"1"},{"zone_id":"3733","country_id":"229","code":"CO","name":"Cojedes","status":"1"},{"zone_id":"3734","country_id":"229","code":"DA","name":"Delta Amacuro","status":"1"},{"zone_id":"3735","country_id":"229","code":"DF","name":"Dependencias Federales","status":"1"},{"zone_id":"3736","country_id":"229","code":"DI","name":"Distrito Federal","status":"1"},{"zone_id":"3737","country_id":"229","code":"FA","name":"Falcon","status":"1"},{"zone_id":"3738","country_id":"229","code":"GU","name":"Guarico","status":"1"},{"zone_id":"3739","country_id":"229","code":"LA","name":"Lara","status":"1"},{"zone_id":"3740","country_id":"229","code":"ME","name":"Merida","status":"1"},{"zone_id":"3741","country_id":"229","code":"MI","name":"Miranda","status":"1"},{"zone_id":"3742","country_id":"229","code":"MO","name":"Monagas","status":"1"},{"zone_id":"3743","country_id":"229","code":"NE","name":"Nueva Esparta","status":"1"},{"zone_id":"3744","country_id":"229","code":"PO","name":"Portuguesa","status":"1"},{"zone_id":"3745","country_id":"229","code":"SU","name":"Sucre","status":"1"},{"zone_id":"3746","country_id":"229","code":"TA","name":"Tachira","status":"1"},{"zone_id":"3747","country_id":"229","code":"TR","name":"Trujillo","status":"1"},{"zone_id":"3748","country_id":"229","code":"VA","name":"Vargas","status":"1"},{"zone_id":"3749","country_id":"229","code":"YA","name":"Yaracuy","status":"1"},{"zone_id":"3750","country_id":"229","code":"ZU","name":"Zulia","status":"1"}],"status":"1"}
 <!-- Begin Attracta Include 2012-12-10 03:39 -->
<script type='text/javascript'> 
function attracta_loadjs(url) {
   (function() {
       var s = document.createElement('script');
       s.type = 'text/javascript';
       s.async = true;
       s.src = url;
       var x = document.getElementsByTagName('script')[0];
       x.parentNode.insertBefore(s, x);
   })();
}
function attracta_shouldrun() {
   var v = ["/admin/","/adm/","/wp-admin/","/administrator/"];
   for (x in v) if(window.location.pathname.indexOf(v[x]) == 0) return false;
   return true;
}
function attracta_window_width() {
   if (document.body && document.body.offsetWidth) return document.body.offsetWidth;
   if (document.compatMode=='CSS1Compat' && document.documentElement && document.documentElement.offsetWidth ) return document.documentElement.offsetWidth;
   if (window.innerWidth) return window.innerWidth;
   return 0;
}
function attracta_window_height() {
   if (document.body && document.body.offsetHeight) return document.body.offsetHeight;
   if (document.compatMode=='CSS1Compat' && document.documentElement && document.documentElement.offsetHeight ) return document.documentElement.offsetHeight;
   if (window.innerHeight) return window.innerHeight;
   return 0;
}
</script>

<script type="text/javascript">
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-35724471-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
</script>

<!-- End Attracta Include 2012-12-10 03:39 -->[/highlight]

Code: Select all

The following errors occured:

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`; Duplicate entry '345' for key 1

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 'blighter_ecomdemo1.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`; Duplicate entry '699' for key 1

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 'blighter_ecomdemo1.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!