MoonFaery Posted February 13, 2008 Share Posted February 13, 2008 I know a little about HTML and PHP, enough to get by.. enough to be able to modify.. but I am stumped on this error and apparently those at OSCommerce and even my webhosting doesn't have a clue (no replies). I go to the item in my store and click on "Add To Wishlist".. this is what comes up: My Wish List contains: Image Product Name Price Select 1054 - Unknown column 'p.products_id' in 'on clause' select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '42' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name [TEP STOP] Any ideas? Quote Link to comment Share on other sites More sharing options...
awpti Posted February 13, 2008 Share Posted February 13, 2008 Does the products table contain a field called products_id? Also, this should be in the third-party software forum. Quote Link to comment Share on other sites More sharing options...
MoonFaery Posted February 13, 2008 Author Share Posted February 13, 2008 Also, this should be in the third-party software forum. Oops, I'm sorry. Can a mod move this? Quote Link to comment Share on other sites More sharing options...
MoonFaery Posted February 13, 2008 Author Share Posted February 13, 2008 I'm not sure where to start on that one.. there are quite a few files that I have modified that contain products_id. Quote Link to comment Share on other sites More sharing options...
MoonFaery Posted February 13, 2008 Author Share Posted February 13, 2008 I finally got a reply on the oscommerce forum that helped... Thanks anyways Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.