MySQL upgrade crashed site - 1054 Unknown column 'c.parent

8 Mar 2008, 11:09 PM

New Zenner

Join Date:: Mar 2008
Posts:: 2
Plugin Contributions:: 0

MySQL upgrade crashed site - 1054 Unknown column 'c.parent_id' in 'on clause'

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!

9 Mar 2008, 1:35 AM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

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, 1:45 AM

bbrunning

New Zenner

Join Date:: Mar 2008
Posts:: 2
Plugin Contributions:: 0

Re: MySQL upgrade crashed site - 1054 Unknown column 'c.parent_id' in 'on clause'

You're awesome, thanks!