Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

QTPro Installation Problem


skb52

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...