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

10 Nov 2007, 7:32 PM

#1

New Zenner

Join Date:: Apr 2007
Location:: Los Angeles, California
Posts:: 9
Plugin Contributions:: 0

1054 Unknown column 'c.parent_id' in 'on clause' - Ultimate SEO Url mod

I've made no changes my web site in weeks, but this morning I received an error when I type in my site's URL: http://www.tenerahome.com

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'm using version 1.3.7 (fresh install). My admin pages work fine.

Any idea what went wrong? Thanks!

===========

My store: www.tenerahome.com

10 Nov 2007, 8:04 PM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: 1054 Unknown column 'c.parent_id' in 'on clause' - Ultimate SEO Url mod

What addons/contributions do you have installed?

The query you quoted isn't part of the core Zen Cart code.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

10 Nov 2007, 10:29 PM

#3

orenrosenthal

New Zenner

Join Date:: Apr 2007
Location:: Los Angeles, California
Posts:: 9
Plugin Contributions:: 0

Re: 1054 Unknown column 'c.parent_id' in 'on clause' - Ultimate SEO Url mod

I installed a bunch of add-ons:

SEO URLs,
Image Handler,
Super Orders,
Quickbooks QBI
Wishlist Module
User Tracking
Google Analytics/Froogle/Sitemap
Ty Package Tracker
Backup Mysql

I think that's it...

===========

My store: www.tenerahome.com

11 Nov 2007, 12:54 AM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: 1054 Unknown column 'c.parent_id' in 'on clause' - Ultimate SEO Url mod

That query is a bug in the Ultimate SEO URL mod that's not compatible with MySQL 5.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

11 Nov 2007, 1:14 AM

#5

jettrue

Totally Zenned

Join Date:: Jan 2005
Location:: USA, St. Louis
Posts:: 3,651
Plugin Contributions:: 5

Re: 1054 Unknown column 'c.parent_id' in 'on clause' - Ultimate SEO Url mod

Save yourself from the loss of entirely too much time and an enormous headache, and delete any and all traces of the SEO mod from your site. I'm a huge supporter of SEO friendly URLs, but this mod is in no way ANYWHERE ready for a live site... heck, its barely ready for a test site.

Jade
Sage Fish

Cherry Zen
Apple Zen
Simple Zen
Nifty Zen
CSS Dropdown Header
Optional Insurance
Short Description for Categories
Category Select

11 Nov 2007, 1:56 AM

#6

orenrosenthal

New Zenner

Join Date:: Apr 2007
Location:: Los Angeles, California
Posts:: 9
Plugin Contributions:: 0

Re: 1054 Unknown column 'c.parent_id' in 'on clause' - Ultimate SEO Url mod

It worked! I've completely disabled that mod. It seems that almost every issue I've had so far was somehow related to the SEO URLs module.

Thank you for your help. I really appreciate it!

===========

My store: www.tenerahome.com