Community Add-Ons
| Maintainers: | ozstar |
 Add file to this package |
|
Error Message - 1054 - Unknown column 'p.products_id' in 'on clause'
for osCommerce Online Merchant v2.2
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
Download 
Report
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.