TLKC

$q=tep_db_query($sql="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=" . (int)$VARS['product_id'] . " and ". "products_attributes.options_id=products_options.products_options_id and ". "products_attributes.options_values_id=products_options_values.products_opti ons_values_id and ". "products_description.language_id=" . (int)$languages_id . " and ". "products_options_values.language_id=" . (int)$languages_id . " and products_options.products_options_track_stock=1 and ". "products_options.language_id=" . (int)$languages_id . " order by products_attributes.options_id, products_attributes.options_values_id"); //list($product_name,$option_name,$option_id,$value,$value_id) it's exactly this lines who have a error...

yes i have to change de database, but i have doing all what i must doing... and it's always the same error. The page stock.php does not find the table products_description.... because i have a prefix, xoops_shop_products_description. He use only Mydb name_products_description, it's the problem ! But where changed that? i have changed the database.php file, but nothing, ... i don't find where i must changed anything.

Hello everybody, i'm french, so excuse me for my bad english, but i need some help to find a solution at an error of my Os commerce. For information i work with XOS COMMERCE, it's the module for adapted in xoops. The module is very easy to work with him. But recently i have installed the contribution QTpro to track my stock, and an error occure of my "os" home page, : 1146 - La table 'thelostkidscorner.configuration' n'existe pas select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] "the lost kids corner" is the name of my web site. And for my MYSQL data base. Have you some answer for this error? it's very shitting for me, i don't find anything who resolved this. Please give me some help .... Thanks a lot !

Hello everybody, i'm french, so excuse me for my bad english, but i need some help to find a solution at an error of my Os commerce. For information i work with XOS COMMERCE, it's the module for adapted in xoops. The module is very easy to work with him. But recently i have installed the contribution QTpro to track my stock, and an error occure of my "os" home page, : 1146 - La table 'thelostkidscorner.configuration' n'existe pas select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] "the lost kids corner" is the name of my web site. And for my MYSQL data base. Have you some answer for this error? it's very shitting for me, i don't find anything who resolved this. Please give me some help .... Thanks a lot !