Attributes error

[marbles]

Apologies if this has been posted in the wrong area.
I set up attributes for drop-down boxes, but when I try to run this in Attributes controller I get the following error message:

1054 Unknown column 'attributes_price_factor_onetime' 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, '1623', '1', '1', '0', '+', '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.

Can anyone tell me where I am going wrong?

I set up both Option name and Option value before using the controller to attatch the attribute to a product. Basically, i just wanted a Size dropdown (sml/med/lrge) but the error keeps appearing.

Thanks for any help you could offer me.

many thanks

marbles

[kobra]

What version of Zen Cart?
What version of php?
What version of mysql?

[marbles]

Hello
Thank you for your reply, Kbra.
These are the details that I have:

Zen Cart = 1.3.8
PHP = 5
Mysql = 5

Hope that this helps.

Cheers
marbles

[marbles]

Sorry, please ignore my last message. Here are the details:
PHP 4.4.8 (cgi) (built: Jan 7 2008 08:46:28)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with the ionCube PHP Loader v3.1.23, Copyright (c) 2002-2006, by ionCube Ltd., and
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies

PHP 5.2.5 (cgi) (built: Jan 7 2008 10:08:57)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies

mysql Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i686) using readline 5.0

Many thanks
marbles

[kobra]

You can not be using both versions of php at the same time???

Check in admin > tools > server ver info > for what is actually being used

[marbles]

PHP Version 4.4.8

Thanks Kobra

[8th-heaven]

I set up attributes for drop-down boxes, but when I try to run this in Attributes controller I get the following error message:

1054 Unknown column 'attributes_price_factor_onetime' in 'field list'

Hello Marbles, did you ever get this sorted? I'm having the exact same problem.