New Zenner
- Join Date:
- Feb 2009
- Posts:
- 1
- Plugin Contributions:
- 0
"1054 Unknown column 'attributes_price_factor_onetime_offset' in 'field list'
Hi,
I'm new to the forum and to Zen Cart. I'm trying to setup a price by volume system for some of the products on my website. I've scoured around and found out that I should use attributes. Anyway to cut a long story short, I had to manually install new tables in my database so that I could even view the attributes page.
I've now created the attributes I want to use but when I press insert I get the error:
"1054 Unknown column 'attributes_price_factor_onetime_offset' in 'field list'
in:
[insert into 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) values (0, '765', '1', '2', '2.6', '-', '0', '1', '0', '+', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."
I was wondering if anybody knew what was wrong. I'm not really comfortable with reinstalling Zen Cart fully so I was hoping I could enter some code like I did previously to solve the error.
Many Thanks in advance
Jonny Harper
My server info says:
Online web traders
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
PHP Version 4.4.9
