Error message--1054 Unknown column 'p.products_id' in 'on clause'

[funkyfunnybone]

I am lost and confused and freaking out because this stuff is way over my head and powweb is not offering me any REAL help... I'm just going to post tthe error message my customers keep getting and powweb's response. They said other people were probably having the same problem and here would be the best place to find out how to fix it, so hopefully someone here does :)

Hi there, just wanted to let you know that the code on your site appears to be broken. I can't enter any of the categories, or see any of the new items if I click on the thumbnails.

I get this if I click on any of the items
1054 Unknown column 'p.products_id' in 'on clause'

I tried it on Firefox and IE.

Good luck!

-H

Hello Sasha,

In regards to ticket ********, the version of your store application may not be compatible with PHP/Mysql version 5, you can also contact the relevant application support. If you request , we can roll back to Mysql version 4 temporarily, for you to make the changes needed, be aware that we will still need to upgrade to version 5 within the next 30 days.

Even if they downgrade to version 4 for me, it wouldn't help because I don't know what changes need to be made.. I don't even know what the real problem is. Someone please help me!

Thanks,
Sasha

EDIT-- I'm referring to zencart, btw

[phlembol]

What version of ZenCart?

[funkyfunnybone]

I was going to post that but I have no idea how to figure that out. I knew at some point... it just hasn't been a very good day and my head isn't working properly at the moment... anyway, how do I find out what version it is?

[phlembol]

.. how do I find out what version it is?

On the main admin page there is a Version button at the top.

[HalfaBee]

Upgrading seems to solve the problem.
http://www.zen-cart.com/forum/showthread.php?page=2

[funkyfunnybone]

for me there isn't a version button, that's the first place I checked... It has a "check for update" button and then it tells you the latest version available and a link to d/l it. I was thinking updating to the latest version would probably solve the problem, but I don't exactly know how to do that either...

[phlembol]

How about Admin / Tools / "Server/Version Info"?

[funkyfunnybone]

Zen Cart 1.2.6
Database Patch Level: 1.2.6

PHP Version 4.4.6

[phlembol]

1.3.7 is current. What you have is old.
MySQL 5 has some tighter constraints on various SQL statement constructs. Zen Cart™ v1.2.x requires some coding alterations in order to work in a MySQL5 environment. Zen Cart™ v1.3.x has repaired these constructs and thus is expected to be compatible. Exhaustive testing has not yet been completed. You can use a simple patch until then.
That came from here (http://www.zen-cart.com/wiki/index.php/Installation) and there is a link to the patch. I have not used it. There are other reasons too that you should upgrade ASAP.

[phlembol]

Always do a backup before making a change like that.

And, no, powweb won't help with upgrading an app. That is up to the webmaster, or webslave, whichever the case may be. :D

[funkyfunnybone]

I would like to upgrade, I even downloaded the newest version, but I have no idea what to do after that..

[phlembol]

I would like to upgrade..
Here are a couple of upgrade articles, -1- (http://www.zen-cart.com/wiki/index.php/Installation_-_Upgrade), -2- (http://tutorials.zen-cart.com/index.php?article=108). You should not rush into that if you don't know what you are doing, and for sure you want to have everything backed up (including the database.) It is very possible you will lose customizations and will have to reapply/rebuild them.