Zencart and Ultimate URL - 1054 Unknown column ‘c.parent_id’ in ‘on clause’
Configuration:
Linux
Apache 1.3
Mysql 5
PHP 5
Zencart 1.3.5
Chemo Ultimate URL for Zencart 1.3.5
Problem:
After installation, the error message
1054 Unknown column ‘c.parent_id’ in ‘on clause’
shows up on any page in the catalog.
Fix:
Make the following change to /include/classes/seo.url.php
Original:
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:
“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.”‘”;