N/APosted on - 07/20/2012
Sometimes, after a website or account transfer, my OSCommerce gives me a 1054 – Unknown column 'p.products_id' in 'on clause' error when browsing your products or when using the search tool in the browser.
Why does it happens?
Oscommerce giving 1054 error on account transfer?
This is an error which occurred because of upgrading that you might have done in your php5 or MySql 5.
There are a ways to resolve this issue but you need to do it in code level. i. e in both index.php and in search_result.php.
What is the fix that you need to give is I am not sure, this is what is the solution which I know. But, If you are using Article manager, SEO URLs then you need to fix in deeper level of those too.
Please contact OScommerce for further assistance on this.
This is the things that you need to follow to resolve the issue.
Make sure you fix it in all the PHP files where ever it is required.