
Originally Posted by
boinkit
Hi,
I installed this before on a test shop and it worked fine.
I have just installed on another site and I get the following error:
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 categories c, categories_description cd LEFT JOIN 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']
If I view source it gives a little more info and says:
<div class="systemError">1054 Unknown column 'c.parent_id' in 'on clause'<br />in:<br />[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM categories c,
categories_description cd
LEFT JOIN 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']<br /></div>
I have gone into the Admin section and turned off SEO, but still get this error when I try to go to my store. The store is the in the root of the domain, so I changed the .htaccess to be just / (instead of /shop/)
Can anyone tell me what I am donig wrong? I am using ZenCart v1.38a (whereas the previous shop was in v1.37)
Bookmarks