1054 Unknown column 'p.products_id' in 'on

13 Feb 2008, 3:44 AM

#1

directone

New Zenner

Join Date:: Mar 2005
Location:: Beaconsfield, Vic, Australia
Posts:: 15
Plugin Contributions:: 0

1054 Unknown column 'p.products_id' in 'on_clause'

I set up a Zen-cart site that's been working fine for a couple of years. But recently getting this error:

1054 Unknown column 'p.products_id' in 'on_clause'

on catalog pages.

Nothing's changed except probably PHP/MySQL upgrades on the server.

Any clues to this error?

Versions of the systems installed are:
Zen-cart 1.2.4.1
PHP 4.4.7
MySQL 5.0.24

13 Feb 2008, 3:48 AM

#2

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 4

Re: 1054 Unknown column 'p.products_id' in 'on_clause'

system was upgraded to mysql5

Zen cart PCI compliant Hosting

13 Feb 2008, 3:48 AM

#3

yellow1912

Totally Zenned

Join Date:: Oct 2006
Posts:: 5,422
Plugin Contributions:: 0

Re: 1054 Unknown column 'p.products_id' in 'on_clause'

That is probably the cause of the problem (new php and mysql upgrade). Upgrading the store software should solve it.

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

13 Feb 2008, 3:57 AM

#4

directone

New Zenner

Join Date:: Mar 2005
Location:: Beaconsfield, Vic, Australia
Posts:: 15
Plugin Contributions:: 0

Re: 1054 Unknown column 'p.products_id' in 'on_clause'

OK, Thanks

Which version of Zen-cart should I upgrade to? I heard that the latests version requires PHP5 so that won't work for me.

I'm a bit frightened of the upgrade process. Is it likely to produce a cascade of broken things to fix? Where do I find doco on the upgrade procedure?

13 Feb 2008, 4:14 AM

#5

yellow1912

Totally Zenned

Join Date:: Oct 2006
Posts:: 5,422
Plugin Contributions:: 0

Re: 1054 Unknown column 'p.products_id' in 'on_clause'

Latest version will work for you.

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

13 Feb 2008, 4:47 AM

#6

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 4

Re: 1054 Unknown column 'p.products_id' in 'on_clause'

php5 not required till 1.4

Zen cart PCI compliant Hosting

13 Feb 2008, 6:42 AM

#7

kuroi

Totally Zenned

Join Date:: Apr 2006
Location:: London, UK
Posts:: 10,475
Plugin Contributions:: 11

Re: 1054 Unknown column 'p.products_id' in 'on_clause'

directone:

Where do I find doco on the upgrade procedure?In the tutorials/FAQ section.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)