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

[jeffnord]

When ever I go to select a category from the main screen or when I try to select an individual product in viewing all products I get this error message: 1054 Unknown column 'p.products_id' in 'on clause'

I'm not the only one with admin rights and I'm not sure what the other person could have done to cause this error.

Does anyone have any idea what this error is and how I can fix it? I can no longer view any products in the catelog.

Any help would be appreciated.

Thanks,

Jeff Nordgren

[wilt]

This problem is usually caused by using mysql5 with zc v1.2.x. If this problem has recently shown up after your site has been working with no problems, then the likelihood is that your Host has upgraded mysql. If that is the case then I would be complaining to my host.

Mysql5 uses a much stricter SQL interpreter and some queries in ZC v1.2.7 and earlier will fail. Fixes were introduced into ZC v1.3.0 to fix this.

[jeffnord]

Wilt,

Thanks for the information.

I upgraded to zc 1.3 and that seemed to fix the problem.

Thanks again,

Jeff

[vanhooffmodelbouw]

I have the same problem, in the category products i get the message: 1054 Unknown column 'p.products_id' in 'on clause'. My host has upgraded to SQL 5. See www.vanhooffmodelbouw.nl

But i am a bit anxious to upgrade my zencart version, because i made a lot of custumizations a while ago.

Is there any simple (temporary) solution to fix this problem.

[vanhooffmodelbouw]

I fixed it, i used the help off this thread: forums.oscommerce.nl/index.php?showtopic=6565. I added some brackets in the default_filter file (in the includes/index_filter map).

[scrapgabbie]

please could you paste the code here, with instructions in english? l have the same problem with my new install, but my norweigian is not that good LOL ;-)

[Vger]

Please note that osCommerce and Zen Cart are not the same but do use some of the same functions. The Bug Fix to make osCommerce compatable with MySQL 5 is listed in full here:

oscommerce.com/ext/update-20051112.html#_Toc119473702

It may help to show you what you need to do to make your version of Zen Cart compatable with MySQL 5. If you can upgrade to the latest vrsion of Zen Cart then do so, and this should also fix the problem.

Vger

[linkedla]

I got this error:

1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM zce_categories c, zce_categories_description cd LEFT JOIN zce_categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='2' WHERE c.categories_id=cd.categories_id AND cd.language_id='2']

I did upgrade to the latest ZenCart 1.3.7 and the MySQL was upgraded to from 4 to 5, now i have did everything you say exept the OsCommerce thing because I am not proficient on the SQL management.
Anyway after the upgrading all seems to be the same, also the original install was 1.3.1 so I think there is something else.
Please HELP.
the site URL is www.electrogeno.com

Thanks in advance for your help.

[erik89]

I get the 1054 error message when I open the attributes controller in the admin area.
I have searched through many forums, but they didn't help.
I cannot update from zc 1.26 to 1.3.x because I have made many changes in the design of the shop.
Does someone know what I have to do so it works again?
Thanks for answers!

[yellow1912]

You will have to update. Most hosts will upgrade to PHP5 soon, and 1.2.x will not run on it. Upgrade now or you will regret later.