Knowledge Base Article

I'm getting a 1054 error in my osCommerce after a website/account transfer

Sometimes, after a website or account transfer, your osCommerce may give a 1054 - Unknown column 'p.products_id' in 'on clause' error when browsing your products  or when using the search tool.

 

The most common reason for this issue is that your account has been moved from a server running MySQL 4 to a server running MySQL 5.

 

As a solution, you can try applying this osCommerce contribution.

 

In most cases, this will resolve the 1054 problem. If, however, the problem persists, the best solution would be to have your account  migrated to a server running MySQL 4.

 

If you are a SiteGround customer, you can request this migration by posting a support ticket.


_______________

Find expert osCommerce hosting services at SiteGround.com: osCom-optimized servers, expert in support team, free installation of osCommerce, free osCommerce tutorial, and more.


Rating

Please indicate if this article was helpful for you.

rating :  5.0 from 5
views :  91
votes :  1

Valid XHTML 1.0 Strict Valid CSS!