Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Qtpro 3.1 Problems....


milesdavis

Recommended Posts

Posted

Hello,

 

I'm adding Qtpro to my site, and I'm getting this error when I attempt to adjust the stock:

 

1054 - Unknown column 'products_options.special' in 'where clause'

 

select products_name,products_options_name as _option,products_attributes.options_id as _option_id,products_options_values_name as _value,products_attributes.options_values_id as _value_id from products_description, products_attributes,products_options,products_options_values where products_attributes.products_id=products_description.products_id and products_attributes.products_id=34 and products_attributes.options_id=products_options.products_options_id and products_attributes.options_values_id=products_options_values.products_options_v

alues_id and products_description.language_id=1 and products_options_values.language_id=1 and products_options.special=0 and products_options.language_id=1 order by products_attributes.options_id, products_attributes.options_values_id

 

Now, the only thing I don't think I've done correctly is handled the "stock.sql" file, I'm not sure I know exactly what to do with that. I read somewhere about using phpmyadmin, but I can't find that in my cpanel or in the oscommerce admin area.

 

is this my problem? thanks for the help.

 

-md

Posted
Hello,

 

I'm adding Qtpro to my site, and I'm getting this error when I attempt to adjust the stock:

Now, the only thing I don't think I've done correctly is handled the "stock.sql" file, I'm not sure I know exactly what to do with that. I read somewhere about using phpmyadmin, but I can't find that in my cpanel or in the oscommerce admin area.

 

is this my problem? thanks for the help.

 

-md

 

I think I figured out the phpmyadmin part, so that's okay. I'm checking everything else, thanks.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...