ZenCart Error: 1054 Unknown column ‘c.parent

Jun 29 2009

ZenCart Error: 1054 Unknown column ‘c.parent_id’ in ‘on clause’

Posted by alex in Errors at 4:25 PM

0

The error in the title causes all pages on a ZenCart installation to display this followed by a SQL select statement. The error is related to the Ultimate SEO URL’s ZenCart addon. The issue could be caused by one of two things which are the SEO URL cache is corrupted for some reason or the installed version of Ultimate SEO URL’s is old.

Error: 1054 Unknown column ‘c.parent_id’ in ‘on clause’

Resolution:

The first resolution should be to upgrade Ultimate SEO URL’s to the latest release. This can be completed by downloading the ZenCart addon here and then following the instructions that come with the release.

The second resolution will be to clear the Ultimate SEO URL cache. It appears that once this error occurs that it gets stuck in the cache and can continue to cause issues. Clear the Ultimate SEO URL cache by following the below instructions.

ZenCart Admin: First login to the ZenCart admin.
Open SEO URL’s: Now hover over Configuration in the top navigation menu and select SEO URLs from the drop down.
Clear SEO URL Cache: The last option in the SEO URLs configuration window is the “Reset SEO URLs Cache”. Click that option and it will open in the top of the right column. Switch the radial to Reset and then click the Update button. This should clear the SEO URLs cache.

After the completing the above two steps your site should be fully operational again.

Kindle Wireless Reading Device (6″ Display, U.S. Wireless)

Amazon.com 2009, Electronics, $259.00

Apple iPod touch 8 GB (2nd Generation–without iPhone OS 3.1 Software) [Previous Model]

Apple Computer, Electronics, $178.95

More Questions? --> Ask --> Read --> Answer --> Gain --> Engage!

Related posts:

Adding Redmine Project Error: ActiveRecord::StatementInvalid (Mysql::Error: Unknown column projects_count in field list I was working on a project today for a client...
How To Easily Install ZenCart Design Templates Installing ZenCart design templates is easy. I ended up installing...
ZenCart Ecommerce Store: Web Page Redirect Loop Error, CEON advshipper During verifying some upgrades I had made to a ZenCart...
Manually Change the ZenCart Admin Password If you have lost your ZenCart admin password it can...
Add a WYSIWYG Editor to ZenCart Product Descriptions Adding a WYSIWYG editor interface to the ZenCart admin product...

Tags: Admin, cache, seo, sql, ultimate seo url, upgrade, ZenCart

This entry was posted on Monday, June 29th, 2009 at 4:25 PM and is filed under Errors. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.