Quote Originally Posted by macson View Post
i have resolve the problem.
just modify the table sort for left join.

SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM ".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd
LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2
ON c.parent_id=cd2.categories_id AND cd2.language_id='".(int)$this->languages_id."'
WHERE c.categories_id=cd.categories_id
AND cd.language_id='".(int)$this->languages_id."'";

change to --->
"SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM
".TABLE_CATEGORIES_DESCRIPTION." cd,
".TABLE_CATEGORIES." c
LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2
ON c.parent_id=cd2.categories_id AND cd2.language_id='".(int)$this->languages_id."'
WHERE c.categories_id=cd.categories_id
AND cd.language_id='".(int)$this->languages_id."'";

I am having the same problem. I have two sites which have been working fine for 2 years. A week or so ago the host went down for a few days. When they finally came up, store was OK. Two days ago, all of a sudden the store disappears and all I get is:

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 zen_categories c, zen_categories_description cd LEFT JOIN zen_categories_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']

I tried to find the code (as advised above) in includes/classes/seo.url.php but I can't find it. Any help would be greatly appreciated! I logged into my admin panel and I saw that SEO URL was turned off (false). I did reset it (cause another post suggested that), still the same. Tried to turn it on and off and nothing.