Oscommerce giving 1054 error on account transfer?

Asked By anonymous 7060 points N/A Posted 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?

• Status: Open
• Question Views: 693
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Internet

Answered By Galaline Samuel 0 points N/A #84086

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.

About Galaline Samuel

Questions
1

Answers
201

Best Answers
54

• Vote Up 0 Vote Down

• Posted on - 07/29/2012
• Question Category: Internet