Cannot create Attributes

[Mike_Dean]

Using ZC 1.3.9D

Hi,

I'm trying to create a number of attributes for a limited number of products.

However, after typing the Name, selecting the Order and Option Type, I click on "Insert" on the Attributes Controller Page, and I get the following 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 ('1', 'Color', '1', '1', '1', '0', '0', '1' )]
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


Obviously something is amiss in my database, but I don't know what ?

Any help would be appreciated.

Thanks,
Mike

[Mike_Dean]

Anyone ?

[DrByte]

Evidently you've damaged the products_options table in your database such that it no longer contains the products_options_rows column. Thus when you try to insert new records it fails with the error message you've quoted.

A clean new install of Zen Cart does contain that column.

Why would your database be missing structural things which are built-in to the core of Zen Cart? It's very unlike addons to remove existing structural components, so it suggests that you're doing that yourself.

[Mike_Dean]

Evidently you've damaged the products_options table in your database such that it no longer contains the products_options_rows column. Thus when you try to insert new records it fails with the error message you've quoted.

A clean new install of Zen Cart does contain that column.

Why would your database be missing structural things which are built-in to the core of Zen Cart? It's very unlike addons to remove existing structural components, so it suggests that you're doing that yourself.

Hmmm..

Cant recall every having the need to edit it as such..

But anywho... I checked the database in my test store and the products_options_rows value is in fact missing, so I re-installed that database which corrected it.

So I have just re-added that value into my live site under the products_options field, copying the table details (rather than re-installing the db again), and all seems to work ok..

Thanks Doc..