mrk6612 Posted February 7, 2009 Share Posted February 7, 2009 Hello, I purchased an ebook script package and set it up, then added a couple of boxes to the nav columns and some banners to the footer. It appeared to be working fine but when I click on any products in the browse box I get the following error message: "1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '10'" Any ideas on how to fix this? Thanks in advance for your help. mick Link to comment Share on other sites More sharing options...
Guest Posted February 7, 2009 Share Posted February 7, 2009 search the forum - this has been answered 1000s of times before - at least once in the last 24 hrs - so try to help yourself instead of expecting others to do it for you Link to comment Share on other sites More sharing options...
mrk6612 Posted February 7, 2009 Author Share Posted February 7, 2009 Thanks for the smart ass reply. I did search for the answer to this and found nothing and that's why I posted. Perhaps you are so smart you have a link to an answer that I was unable to find? Link to comment Share on other sites More sharing options...
Guest Posted February 7, 2009 Share Posted February 7, 2009 Use Google to search the forum using the prefix site:www.oscommerce.com/forums and you'll get over 1000 answers to your problem (or look through some of the previous threads) Link to comment Share on other sites More sharing options...
mrk6612 Posted February 7, 2009 Author Share Posted February 7, 2009 Use Google to search the forum using the prefix site:www.oscommerce.com/forums and you'll get over 1000 answers to your problem (or look through some of the previous threads) Okay, thanks. I'll do that right away. mick Link to comment Share on other sites More sharing options...
mrk6612 Posted February 7, 2009 Author Share Posted February 7, 2009 I found this thread via Google which some might find helpful: http://www.oscommerce.com/forums/index.php?showtopic=230304 In my case, I reverted to my previous index.php. My problem came when I took a banner from the footer.php and moved it into the body table of the index.php file. That threw something out of whack so I reverted to the previous index.php file I had saved prior to the change and now it's back to working order. I will move the banner back to the footer which is where it was before. Glad I saved the original file before making the wrong edit. Thanks, perfectpassion, for your assistance. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.