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? Link to comment https://forums.phpfreaks.com/topic/90820-oscwishlist-error/ 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. Link to comment https://forums.phpfreaks.com/topic/90820-oscwishlist-error/#findComment-465494 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? Link to comment https://forums.phpfreaks.com/topic/90820-oscwishlist-error/#findComment-465504 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. Link to comment https://forums.phpfreaks.com/topic/90820-oscwishlist-error/#findComment-465514 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 Link to comment https://forums.phpfreaks.com/topic/90820-oscwishlist-error/#findComment-465986 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.