1054 - Unknown column 'products_options_type' in '

[Or!]

Here is what I get after having installed Product Attributes - Option Type Feature v1.71:

 

 

1054 - Unknown column 'products_options_type' in 'field list'

 

insert into products_options (products_options_id, language_id, products_options_name, products_options_type, products_options_length, products_options_comment) values ('6', 'dfgdf', '2', '0', '', 'dfgd')

 

[TEP STOP]

 

 

if I check the tables, here is what I get:

 

 

mysql> describe products_options;

+--------------------------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+--------------------------+-------------+------+-----+---------+-------+

| products_options_id | int(11) | | PRI | 0 | |

| language_id | int(11) | | PRI | 1 | |

| products_options_name | varchar(32) | | | | |

| products_options_type | int(5) | | | 0 | |

| products_options_length | smallint(2) | | | 32 | |

| products_options_comment | varchar(32) | YES | | NULL | |

+--------------------------+-------------+------+-----+---------+-------+

6 rows in set (0.00 sec)

 

 

products_options_type DOES exist in products_options ! I don't understand what the problem could be...

does anybody has any ideas?

 

thank you in advance.

[Or!]

sorry for not mentioning: this error I get when I try to add a new option type on the product attributes page.

 

I also tried to reverse language_id and products_options_name in products_attributes.php to have it in the right order (as it is in the mysql table) but it didnot help.

[Or!]

the problem is solbed... thank you guyz.

[Guest]

the problem is solbed... thank you guyz.

<{POST_SNAPBACK}>

hi there noticed you sorted the problem with the error you was having will you be able to take a look at the error below see if it is the same as the error your was getting and if so how you fixed it cheers mate any help will do

 

here is the error

 

1054 - Unknown column 'new_products_category_id21' in 'order clause'

 

select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '22' and p.products_status = '1' order by new_products_category_id21

 

[TEP STOP]