error message: 1054 Unknown column 'p.products_id' in 'on clause'

[elnaraniall]

Hi guys!

I use ZEn Cart for my online catalog. It was working fine until 2 hours ago. Suddenly when browsing the catalog, the categories and the products do not display anymore, instead there is an error message:

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


What do I do to fix that?

Thank you so much in advance!

[DrByte]

There are some "related posts" at the bottom of this page which should help you sort it out.

[elnaraniall]

Thank you! I read those, but am a bit confused.

So, do I upgrade the Zen Cart version and then somehow import the databases containing my current information?

[DrByte]

Did your hosting company recently tell you that they were upgrading their PHP or MySQL software?
What version of PHP and MySQL is your site using?

[elnaraniall]

no, they didn't!

The MySQL is : Database: MySQL 5.0.27-standard-log
the PHP is : PHP Version 4.4.7

[Merlinpa1969]

you will need to upgrade your zen cart to a 1.3.x
1.3.7 or higher are the best,

[elnaraniall]

Thanks! I just got off the phone with my hosting, they said the same. They also said I did not have to download the full new version, that there were scripts I could run to do the upgrade?

[DrByte]

Thanks! I just got off the phone with my hosting, they said the same. They also said I did not have to download the full new version, that there were scripts I could run to do the upgrade?

Well, if they believe they are experts in that area, perhaps they can coach you in the process, and help you when their advice fails to work properly.

Here are the normal upgrade instructions:
https://www.zen-cart.com/tutorials/i...hp?article=108

Upgrading is not a task to be taken lightly. Especially if you have a lot of customizations or have a lot of versions to upgrade from.

[elnaraniall]

I will probably have to do a lot of customizations, my previous version is 1.2.6

[DrByte]

When upgrading from v1.2.x to v1.3.x, it is best to plan to rebuild your template and your customizations. There were significant template changes. It'll likely be less work to rebuild than to try to simply convert each file.

A script is supplied to handle your database data.

Follow the tutorial mentioned above. It'll take you through the process.
It's not something you'll likely complete overnight though.