Zen Cart Logo
Forums / General Questions / 1054 Unknown column 'c.parent_id' in 'on clause'

1054 Unknown column 'c.parent_id' in 'on clause'

Locked

Views: 1,749

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
21 Dec 2007, 3:47 PM
#1
kimsonvu avatar

kimsonvu

Zen Follower

Join Date:
Aug 2006
Location:
HCMC
Posts:
263
Plugin Contributions:
0

1054 Unknown column 'c.parent_id' in 'on clause'

I got trouble with 1.36

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 handicracategories c, handicracategories_description cd LEFT JOIN handicracategories_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']

My host just upgrade PHP and MYSQL version a few days ago.After upgrade , my website still work but now it have some trouble.

Any ideas about this trouble?