1054 Unknown column 'p.products_id' in 'on clause'

[JayCali]

Hi All,

I just moved my ZenCart to a different web host. But now I am getting the following error message, "1054 Unknown column 'p.products_id' in 'on clause' ".

How do I fix this?

Please help as I have been struggling with this.. :-(

Thanks,
Jerome

[DrByte]

Zen Cart Version 1.2.x wasn't built for compatibility with MySQL 5, but your new host appears to be using MySQL 5.
Either that or you've done an upgrade and didn't complete the database table-structure upgrade.

[AngelT]

Hello,

I am Having the same problem: "1054 Unknown column 'p.products_id' in 'on clause' " but I have not move to any other host and I am using the same MYSQL version. It is I have not done any change to the database and I am having this problem.

Could you help me with this please?

Thank you!

Radhames Lopez

[DrByte]

1. Did you recently make any changes or customizations to your site?
2. Did you recently install any mods/contributions/addons? If so, which ones?
3. Please go to Admin->Tools->Server Info and post all the information you see there above the blue PHP logo/bar.

[AngelT]

Hi DrByte,

I have not installed anything new.

The customization I did was to the text files controling the main page, page 2, page 3 and page 4. And also I did changes to the files where the Shipping & Returns, Privacy Notice, Conditions of Use, Contact Us, Gift Certificate FAQ and Newsletter Unsubscribe are already.

All those changes are working find. This was only text change.

What you say about admin/Tools/Server Info. I do not see any information to post there above the blue PHP Logo/Bar, but it seems to be that changes were done to MYSQL database. I see there the following:

[FONT="Tahoma"]Server Host: neptune (192.168.1.21)
Database Host: mysql.catalog.com (209.217.33.160)
Server OS: SunOS 5.9 Database: MySQL 5.0.27-standard-log
Server Date: 03/09/2007 15:45:29 Database Date: 03/09/2007 15:45:24
Server Up Time: 3:45pm up 7 day(s), 11:27, 1 user, load average: 35.79, 21.12, 25.50
PHP Version: 4.4.4 (Zend: 1.3.0)
HTTP Server: Apache[/FONT]


Please let me know what and how can I post the information you told me is on admin/Tools/Serfer info. Because all the information over there is just as display only. Or if there is another actions I could take.

Best Regards,

Radhames Lopez

[DrByte]

The only other information you missed was the Zen Cart version history information shown between the info you copied and the blue bar containing the PHP version number ... you see the Zen Cart logo, and then Zen Cart and Zen Cart Database version information. What's in there?

[DrByte]

I am Having the same problem: "1054 Unknown column 'p.products_id' in 'on clause' " but I have not move to any other host and I am using the same MYSQL version. It is I have not done any change to the database and I am having this problem.

it seems to be that changes were done to MYSQL database. I see there the following:

Server OS: SunOS 5.9                          Database: MySQL 5.0.27-standard-log  
Server Date: 03/09/2007 15:45:29        Database Date: 03/09/2007 15:45:24  
Server Up Time: 3:45pm up 7 day(s), 11:27, 1 user, load average: 35.79, 21.12, 25.50 
PHP Version: 4.4.4 (Zend: 1.3.0)

1. Please talk to your host or webserver administrator and find out when they upgraded to MySQL 5.0
It looks like the server was last rebooted a week ago.

2. Note that there are known problems with older versions of Zen Cart having incompatibilities when running under MySQL 5.
Upgrading to the latest version of Zen Cart is an ideal starting point, as all the known issues have been addressed there. Currently the latest is v1.3.7.