Hi Beez.
Thanks for the support, it helped me alot. If anybody else also have this problem, you also need to edit the following lines in /includes/classes/shopping_cart.php
Line 742
$value_id =$db->Execute("select products_options_values_id
from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . "
where products_options_id = '" . $option_id . "'
limit 1
")->fields['products_options_values_id'];
change to
$value_id =$db->Execute("select products_options_values_id
from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . "
where products_options_id = '" . $option_id . "'
limit 1
");
$value_id = $value_id->fields['products_options_values_id'];
Line 931
$value_id =$db->Execute("select products_options_values_id
from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . "
where products_options_id = '" . $option_id . "'
limit 1
")->fields['products_options_values_id'];
change to
$value_id =$db->Execute("select products_options_values_id
from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . "
where products_options_id = '" . $option_id . "'
limit 1
");
$value_id = $value_id->fields['products_options_values_id'];
Line 1943
$mod_value_gift_model=$db->Execute($mod_value_gift_model_query)->fields['products_model'];
change to
$mod_value_gift_model=$db->Execute($mod_value_gift_model_query);
$mod_value_gift_model = $mod_value_gift_model->fields['products_model'];
Line 1949
$mod_value_gift_options_id=$db->Execute($mod_value_gift_options_id_query)->fields['options_id'];
change to
$mod_value_gift_options_id=$db->Execute($mod_value_gift_options_id_query);
$mod_value_gift_options_id = $mod_value_gift_options_id->fields['options_id'];
Line 1955
$mod_value_gift_options_type=$db->Execute($mod_value_gift_options_type_query)->fields['products_options_type'];
change to
$mod_value_gift_options_type=$db->Execute($mod_value_gift_options_type_query);
$mod_value_gift_options_type = $mod_value_gift_options_type->fields['products_options_type'];
Line 1986
$mod_value_gift_query_model=$db->Execute($mod_value_gift_query_model_query)->fields['products_model'];
change to
$mod_value_gift_query_model=$db->Execute($mod_value_gift_query_model_query);
$mod_value_gift_query_model = $mod_value_gift_query_model->fields['products_model'];
You also need to edit the file includes/templates/YOUR_TEMPLATE/templates/tpl_shopping_cart_default.php
Line 95
$mod_product_model =$db->Execute($mod_product_model_query)->fields['products_model'];
change to
$mod_product_model =$db->Execute($mod_product_model_query);
$mod_product_model = $mod_product_model->fields['products_model'];
I hope this helps.
http://www.customscripts.co.za - Custom development for open-source applications
http://www.pcservice.co.za - Website Development, Domain Registration, Hosting