onesixthdepot Posted March 23, 2009 Share Posted March 23, 2009 The error: 1054 - Unknown column 'p.products_cost' in 'field list' select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_cost, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '18484' and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP] This error report is in place of the shopping cart contents - front end only - IF I look at the customers cart contents via whosonline - I see everything fine. I have searched all of the visible php files for "p.products_cost" - I have not found anything... IS there hidden files in oscommerce? WHERE is the "registry file"? IS there a registry file? I am at a point where I am contemplating starting from scratch - but the fact that I have OVER 6000 different items in stock, keeps me from starting from fresh (ALOT of data entry) HELP? Thanks again... Bear Johnson www.onesixthdepot.com Link to comment Share on other sites More sharing options...
hari_shyam Posted March 23, 2009 Share Posted March 23, 2009 The error: 1054 - Unknown column 'p.products_cost' in 'field list' select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_cost, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '18484' and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP] This error report is in place of the shopping cart contents - front end only - IF I look at the customers cart contents via whosonline - I see everything fine. I have searched all of the visible php files for "p.products_cost" - I have not found anything... IS there hidden files in oscommerce? WHERE is the "registry file"? IS there a registry file? I am at a point where I am contemplating starting from scratch - but the fact that I have OVER 6000 different items in stock, keeps me from starting from fresh (ALOT of data entry) HELP? Thanks again... Bear Johnson www.onesixthdepot.com Hi Please check the dataase for the field. The product_cost is not a standard field. Also, I am not sure of your implementation details ( templates ). but since thereis a specific mention to the products id. check the includes/classes/shopping_cart.php includes/modules/*.php product_info.php shopping_cart.php Regards, Hari Link to comment Share on other sites More sharing options...
onesixthdepot Posted March 23, 2009 Author Share Posted March 23, 2009 Hi Please check the dataase for the field. The product_cost is not a standard field. Also, I am not sure of your implementation details ( templates ). but since thereis a specific mention to the products id. check the includes/classes/shopping_cart.php includes/modules/*.php product_info.php shopping_cart.php Regards, Hari WOOT! I found it! I deleted the line! AND... wait for it! IT WORKS FINE NOW! Hari - it was NOT in modules... It was hiding in classes/order.php I swear I looked there... phew! I do NOT have to relist all that stock... Bye for now - may it be a LONG time before I have the need to visit this forum again! Thank you all for being here! Bear Johnson www.onesixthdepot.com Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.