QTPro Installation Problem

[skb52]

I am wanting where coding is concerned. I have a shop that I am building for a friend, this contribution is badly needed. I used Beyond Compare to compare coding between my existing shop which I have install just a few contribution and the coding for QTPro, there didn't seem to be any conflicts in coding so I figured when I did my sql import and overwrote the appropriate files with the updated one everything should work fine. When I check the check box to allow tracking of the only 2 attributes I need (size and color) I get the following error:

 

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

 

update products_options set products_options_track_stock='1',products_options_name = 'Color' where products_options_id = '8' and language_id = '1'

 

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

 

update products_options set products_options_track_stock='1',products_options_name = 'Size' where products_options_id = '2' and language_id = '1'

 

I'm hoping this is something simple and that I will have no further problem once corrected however, I don't quite understand what needs to be done, please help.

 

I have tried searching for an answer to this question in this forum but haven't been able to find anything.

 

Thanks

Sharon

[k2tec]

I am wanting where coding is concerned. I have a shop that I am building for a friend, this contribution is badly needed. I used Beyond Compare to compare coding between my existing shop which I have install just a few contribution and the coding for QTPro, there didn't seem to be any conflicts in coding so I figured when I did my sql import and overwrote the appropriate files with the updated one everything should work fine. When I check the check box to allow tracking of the only 2 attributes I need (size and color) I get the following error:

 

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

 

update products_options set products_options_track_stock='1',products_options_name = 'Color' where products_options_id = '8' and language_id = '1'

 

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

 

update products_options set products_options_track_stock='1',products_options_name = 'Size' where products_options_id = '2' and language_id = '1'

 

I'm hoping this is something simple and that I will have no further problem once corrected however, I don't quite understand what needs to be done, please help.

 

I have tried searching for an answer to this question in this forum but haven't been able to find anything.

 

Thanks

Sharon

 

Look in your SQL in product_options and see if you have the following tabels.

products_options_id int(11) Nee 0 Browse distinct values Veranderen Verwijderen Primaire sleutel Unieke waarde Index Volledige tekst

language_id int(11) Nee 1 Browse distinct values Veranderen Verwijderen Primaire sleutel Unieke waarde Index Volledige tekst

products_options_name varchar(32) latin1_general_ci Nee Browse distinct values Veranderen Verwijderen Primaire sleutel Unieke waarde Index Volledige tekst

products_options_track_stock tinyint(4) Nee 0 Browse distinct values Veranderen Verwijderen Primaire sleutel Unieke waarde Index Volledige tekst

 

if not change your SQL First install SQL new install and than conf.

 

Tom