Contributions
Error Message - 1054 - Unknown column 'p.products_id' in 'on clause'
If you get this message it is probably due to your server upgrading to php5 or MySQL5. You get the message when you try a search on your site. The new OSC from around Sept-Oct 2006 or so, doesn't have this problem.
You just need to change one section in index.php and one in advance search_result.php.
Very simple Good Luck!
Ozstar
 How to Fix the 1054 error in any file |
9 Sep 2008 |
The following file is a "how to" guide on fixing the 1054 error in any file in your store.
Some heavily modified stores will require that you fix the code by hand in index.php. In addition, you may have additional files that need to be fixed if you have contribs installed such as Article Manager, Price Breaks contrib, SEO URLs and more.
This file does not show where to fix all the problems in each file, rather is teaches you how to fix the problem (which is very simple) and then guides you where you should look to fix your store.
Error Message - 1054 - Unknown column 'p.products_id' in 'on clause'Note: Contributions are used at own risk.
