SEO ultimage url SQL error

[jeanmichel]

Hi, i need help with this one.

i'v installed the SEO module v.1.3.5 and then i'm now stuck on this error page.

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 devi_categories c, devi_categories_description cd
 LEFT JOIN devi_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']

Seems like it is looking for the c.parent_id column in the database.
So i went there to look for it, in the categories table and it is there. (Actually there is a "parent_id" column)

So i need some assistance here.

i'd wish to give more infos but i guess that's all i can say.

Thanx for helping me out.

[jeanmichel]

so, seems like there is a problem with the cache but i still cant get it to work. My site is unaccessible.

Someone an idea on how to fix it ?

[DrByte]

Is there something about this error in the support thread for the mod?
http://www.zen-cart.com/forum/showthread.php?t=35034

[samad64]

if its related to cache.. simply going to Admin > Configuration > SEO URLs and resetting the cache should fix it

[jeanmichel]

nope.

I read the whole thread from 1 to 34 and nothing about it.

I'm not a sql monk so i dont know, for the moment, what's wrong with the piece of code generated in my error message.

I'm striving to find out.

And related to getyourgames, no, resetting the cache hasnt changed anything about my problem and the same error message is generated.

thanks guys, i'm still looking...

[samad64]

ah.. this seems to be a mysql 5 issue. found a similar one just browsing the web.. maybe someone with better mysql knowledge can help you fix it

http://forums.alwayswebhosting.com/s...ead.php?p=8379
^ note thats for osc

[jeanmichel]

the problem is fixed

Actually, the problem is not fix but a hack has been found in this post to overcome it:

"I had the same problem. I found a workaround by configuring the SEO URLs in the admin page: Configuration / SEO URLs:
Add category parent to beginning of URLs -> set to false.

It seems like a bug,..."

And its a bug. Disabled the Add category parent to beginning of URLs and the error message gone away!

thanks doc!

[DrByte]

Agreed -- appears to be MySQL5-related.

Just taking a quick stab without testing:

/includes/classes/sel.url.php
around line 912:

							FROM ".TABLE_CATEGORIES." c, 
							".TABLE_CATEGORIES_DESCRIPTION." cd 
							LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2

Try changing that to:

							FROM ".TABLE_CATEGORIES_DESCRIPTION." cd, 
							".TABLE_CATEGORIES." c 
							LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2

[jeanmichel]

mmm.

Looks like it doesnt help much. I've also read the post on the PHP/MYSQL forum, and i thought it would be it.

Maybe trying another combination of changes?

na, i dont know mysql enough to know what i'm doing.

but still, the workaround works fine. even though i'd prefer having the category parent to beginning of URLs.

thanks much anyway, let me know if you find something!

;)

[DrByte]

It may or may not matter ... but I'm curious .. which version of MySQL are you using?