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
Results 1 to 7 of 7
-
13 Feb 2008, 04:44 AM #1
New Zenner
- Join Date
- Mar 2005
- Location
- Beaconsfield, Vic, Australia
- Posts
- 27
- Plugin Contributions
- 0
1054 Unknown column 'p.products_id' in 'on_clause'
-
13 Feb 2008, 04:48 AM #2
Totally Zenned
- Join Date
- Mar 2004
- Posts
- 16,042
- Plugin Contributions
- 5
Re: 1054 Unknown column 'p.products_id' in 'on_clause'
system was upgraded to mysql5
-
13 Feb 2008, 04:48 AM #3
Totally Zenned
- Join Date
- Oct 2006
- Posts
- 5,477
- Plugin Contributions
- 11
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, 04:57 AM #4
New Zenner
- Join Date
- Mar 2005
- Location
- Beaconsfield, Vic, Australia
- Posts
- 27
- 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, 05:14 AM #5
Totally Zenned
- Join Date
- Oct 2006
- Posts
- 5,477
- Plugin Contributions
- 11
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, 05:47 AM #6
Totally Zenned
- Join Date
- Mar 2004
- Posts
- 16,042
- Plugin Contributions
- 5
Re: 1054 Unknown column 'p.products_id' in 'on_clause'
php5 not required till 1.4
-
13 Feb 2008, 07:42 AM #7
Totally Zenned
- Join Date
- Apr 2006
- Location
- London, UK
- Posts
- 10,569
- Plugin Contributions
- 25
Re: 1054 Unknown column 'p.products_id' in 'on_clause'
In the tutorials/FAQ section.
Originally Posted by directone
Kuroi Web Design and Development | Twitter
(Questions answered in the forum only - so that any forum member can benefit - not by personal message)
Similar Threads
-
1054 Unknown column 'p.products_id' in 'on clause'
By jeffnord in forum Setting Up Categories, Products, AttributesReplies: 30Last Post: 30 Apr 2009, 05:22 PM -
1054 Unknown column 'p.products_id' in 'on clause'
By phylrust in forum General QuestionsReplies: 3Last Post: 5 Jan 2009, 08:36 PM -
1054 Unknown column 'p.products_id' in 'on clause
By firstwiz in forum General QuestionsReplies: 1Last Post: 28 Aug 2008, 11:47 PM -
1054 Unknown column 'p.products_id' in 'on clause'
By caradelrae in forum General QuestionsReplies: 8Last Post: 8 Oct 2006, 05:41 PM
