Knowledgebase: General
Can't Add Product Attributes in Zen Cart After Installing QBI
Posted by Adam Liberman on 18 June 2008 04:38 AM
Problem: Can't add product attributes after installing QBI

Cause: Poor code in the shopping cart fails when fields are added by QBI to the products_attributes and products_options_values_to_products_options tables.

Applies to: Zen-Cart 1.3.7 and below. This issue has been fixed in Zen-Cart 1.3.8

Solution:
1) Upgrade to Zen-Cart 1.3.8 or above.
or 2) In the file /admin/attributes_controller.php, find
$db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . "

and replace it with:
$db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required)

QBI Versions: 3.50 >
(130 vote(s))
Helpful
Not helpful