1054 Unknown column error when moving store

Hi,

I have moved a store to a new server following these instructions:
https://www.zen-cart.com/tutorials/index.php?article=100.

The new server has SQL 5. The old server was SQL 4.

On the new server I get an error when clicking on any product link:
1054 Unknown column 'p.products_id' in 'on clause'

Is my only option upgrading to 1.3.7?

Is there any other way to fix this problem?

Thank you very much.

What version are you using?

zen-cart-v1.2.6d-full-release-with-security-patch.zip

The v1.2 series code was not written for MySQL 5.
There is some discussion and even some code referenced in the wiki about how to patch some sections of the code for compatibility, but they are far from complete.
v1.3.7 is the most compatible so far.

You lead me in the right direction.

This patch worked great!!!

"www.dataweb.no/dm/index.php/Downloads"

Thanks alot!

YOU NEED TO NOTE: that patch is ONLY a weak bandage. There are MANY other parts of the v1.2.x code that are NOT compatible with MySQL 5 ... and you may end up with missing or invalid data in your store if you continue to use the old code on the newer database.

You should plan for an upgrade sooner than later