xpcpro Posted October 17, 2007 Share Posted October 17, 2007 when i open a category it show me this error: 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 = '36' [TEP STOP] my site is www.oilpaintingpro.com please help fast... Link to comment Share on other sites More sharing options...
jadeb Posted October 17, 2007 Share Posted October 17, 2007 Why does your osCommerce installation say "Powered by XpcPro.com" in the footer instead of "Powered by osCommerce" Link to comment Share on other sites More sharing options...
Jack_mcs Posted October 17, 2007 Share Posted October 17, 2007 You need to install a few of the patches that were released by previous oscommerce updates. You can download the latest version of oscommerce and compare your index.php and advanced_search_result.php file to find the fix or download the previous oscommerce package from sourceforge, which has update instructions in it. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
xpcpro Posted October 17, 2007 Author Share Posted October 17, 2007 can you explain a little bit more excactly or give me a file etc... Link to comment Share on other sites More sharing options...
Jack_mcs Posted October 18, 2007 Share Posted October 18, 2007 I don't know what I could say that is more specific than what I posted. What part of it did you not understand? Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons 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.