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

[Guest]

Hi everyone,

 

 

I am getting this error.

 

 

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

update products_options set products_options_name = 'Memory', products_options_type = '0' where products_options_id = '4' and language_id = '1'

[TEP STOP]

 

 

I have looked in the forums all night and did not find a way to fix it. so i am asking for some help.

 

i just installed oscommerce-2.2rc2a along with STSv4.5.8 and File_Feature_v.8

 

 

thank you

[Guest]

some has to know what this meens...help please.

 

 

 

thank you

[Jan Zonjee]

some has to know what this meens...help please.

You already told us what the problem is:

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

In other words, there is no column products_options_type in the table that you are writing to. Either there is a mistake in one of the files you used (someone wrote this contribution but didn't use a clean osC but one with another contribution added to it already) or you overlooked an instruction to add that column to your database.

[Guest]

Jan zonjee thank you!!!

 

How would i fix this. I really don't know i have been trying to figure it out all day and night. I am new to osC and php.

 

 

thank for the help

[Jan Zonjee]

I am new to osC and php.

And I'm not psychic (no one here by the way). You have those contributions at hand. Try searching for the word products_options_type in the files of those contributions and see what you come up with.

[Guest]

And I'm not psychic (no one here by the way). You have those contributions at hand. Try searching for the word products_options_type in the files of those contributions and see what you come up with.

 

 

ok, sounds like a plan. I did go to MyPhpAdmin and seen that products options type was in there. I well look and let you know what i find. i well most likley need some help.

 

thanks Zonjee for the good start on what to look for.

 

N

[Jan Zonjee]

I did go to MyPhpAdmin and seen that products options type was in there.

In the table products_options? If so you shouldn't get that error I guess. No typos like product_option_type?

[Guest]

In the table products_options? If so you shouldn't get that error I guess. No typos like product_option_type?

 

 

thank you!!!!

 

After i read this last post i added products_options_type to product option in MyPhpAdmin. And guess what....it worked!!! thanks for all the help Zonjee! Now i have to go wash. i well try and set everything up when i get back.....

 

 

thank you

 

 

N

[Guest]

In the table products_options? If so you shouldn't get that error I guess. No typos like product_option_type?

 

 

Now, I am getting this!! I don't know what i am doing wrong!!! please help me!!!!

 

 

1054 - Unknown column 'popt.products_options_length' in 'field list'

 

select distinct popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment from products_options popt, products_attributes patrib where patrib.products_id='28' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by popt.products_options_name