Forums / Setting Up Categories, Products, Attributes / 1054 Unknown column error when creating option name in attributes.

1054 Unknown column error when creating option name in attributes.

Locked

Views: 935

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
13 Mar 2008, 5:09 PM
#1
jcun45 avatar

jcun45

New Zenner

Join Date:
Feb 2006
Location:
Amsterdam
Posts:
73
Plugin Contributions:
0

1054 Unknown column error when creating option name in attributes.

Hello all,

I sell beer online and need to add a .10 deposit to each bottle, tax free. I am assuming that I can use attributes to make this happen...if not someone please steer me in the correct direction.

When I try to create my 'option name' i get this error:

1054 Unknown column 'products_options_rows' in 'field list'
in:
[insert into products_options (products_options_id, products_options_name, language_id, products_options_sort_order, products_options_type, products_options_images_per_row, products_options_images_style, products_options_rows) values ('20', 'Deposit', '1', '1', '5', '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.

Apparently I am missing a column in my database. I am using 1.3.7 and have many mods installed. I would like to avoid upgrading to 1.3.8 for now if there is a way around this.

Any suggestions?

Cheers,

Jeff

Cracked Kettle Amsterdam: Supporting the Independent Brewer, Wine Producer and Distiller.

13 Mar 2008, 6:15 PM
#2
jcun45 avatar

jcun45

New Zenner

Join Date:
Feb 2006
Location:
Amsterdam
Posts:
73
Plugin Contributions:
0

Re: 1054 Unknown column error when creating option name in attributes.

I just added the column to my database and all seems to be fine now...not sure why it wasn't there though.

Still having trouble adding a 10 cent bottle deposit to my items though. Does anyone have any ideas??

Cheers,

Jeff

Cracked Kettle Amsterdam: Supporting the Independent Brewer, Wine Producer and Distiller.