Recently my web host upgraded their mySQL to version 5 as well as PHP. Fortunately I can keep my php to version 4.0 with the control panel, but the mysql 5 seems to have crashed my site.
http://www.thepostcarddepot.com
I get this error message;
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 novanets_postcardcategories c, novanets_postcardcategories_description cd LEFT JOIN novanets_postcardcategories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id=cd.categories_id AND cd.language_id='1']
Anyone know how to fix this?
Thanks in advance!
Results 1 to 3 of 3
Hybrid View
-
9 Mar 2008, 12:09 AM #1
New Zenner
- Join Date
- Mar 2008
- Posts
- 1
- Plugin Contributions
- 0
MySQL upgrade crashed site - 1054 Unknown column 'c.parent_id' in 'on clause'
-
9 Mar 2008, 02:35 AM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
Re: MySQL upgrade crashed site - 1054 Unknown column 'c.parent_id' in 'on clause'
From the "similar threads" list at the bottom of this page:
http://www.zen-cart.com/forum/showthread.php?t=83537.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
9 Mar 2008, 02:45 AM #3
New Zenner
- Join Date
- Mar 2008
- Posts
- 1
- Plugin Contributions
- 0
Re: MySQL upgrade crashed site - 1054 Unknown column 'c.parent_id' in 'on clause'
You're awesome, thanks!
Similar Threads
-
1054 Unknown column 'c.parent_id' in 'on clause'
By darocket in forum General QuestionsReplies: 9Last Post: 21 Jul 2010, 03:56 AM -
Urgent: 1054 Unknown column 'c.parent_id' in 'on clause'
By dealbyethan.com in forum General QuestionsReplies: 3Last Post: 5 Dec 2009, 06:07 PM -
1054 Unknown column 'p.products_id' in 'on clause' -- after mysql upgrade
By rachandcam in forum General QuestionsReplies: 0Last Post: 7 Apr 2008, 04:53 AM -
1054 Unknown column 'c.parent_id' in 'on clause'
By kimsonvu in forum General QuestionsReplies: 1Last Post: 21 Dec 2007, 06:12 PM -
1054 Unknown column 'c.parent_id' in 'on clause'
By linkedla in forum General QuestionsReplies: 2Last Post: 28 Aug 2007, 02:37 PM
