"1054 Unknown column 'attributes_price_factor_onetime_offset' in 'field list'

[jonnyrharper]

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

[DrByte]

...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 think you'll need to explain more of the "long story" ... because whatever you've done has left the table structure incomplete.

I'm not really comfortable with reinstalling Zen Cart fully ...

I'm not sure what exactly you mean by that statement, given the context in which you've stated it.