Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Join Date
    Oct 2006
    Posts
    43
    Plugin Contributions
    0

    SEO ultimage url SQL error

    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.

    Code:
    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.

  2. #2
    Join Date
    Oct 2006
    Posts
    43
    Plugin Contributions
    0

    Default Re: SEO ultimage url SQL error

    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 ?

  3. #3
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: SEO ultimage url SQL error

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

    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.

  4. #4
    Join Date
    May 2006
    Location
    Texas
    Posts
    565
    Plugin Contributions
    4

    Default Re: SEO ultimage url SQL error

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

  5. #5
    Join Date
    Oct 2006
    Posts
    43
    Plugin Contributions
    0

    Default Re: SEO ultimage url SQL error

    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...

  6. #6
    Join Date
    May 2006
    Location
    Texas
    Posts
    565
    Plugin Contributions
    4

    Default Re: SEO ultimage url SQL error

    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

  7. #7
    Join Date
    Oct 2006
    Posts
    43
    Plugin Contributions
    0

    Default Re: SEO ultimage url SQL error

    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!

  8. #8
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: SEO ultimage url SQL error

    Agreed -- appears to be MySQL5-related.

    Just taking a quick stab without testing:

    /includes/classes/sel.url.php
    around line 912:
    Code:
    							FROM ".TABLE_CATEGORIES." c, 
    							".TABLE_CATEGORIES_DESCRIPTION." cd 
    							LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2
    Try changing that to:
    Code:
    							FROM ".TABLE_CATEGORIES_DESCRIPTION." cd, 
    							".TABLE_CATEGORIES." c 
    							LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2
    .

    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.

  9. #9
    Join Date
    Oct 2006
    Posts
    43
    Plugin Contributions
    0

    Default Re: SEO ultimage url SQL error

    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!

    ;)

  10. #10
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: SEO ultimage url SQL error

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

    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.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Simple SEO URL, Ultimate SEO URLs, Ceon URI Mapping SEO
    By pizza392 in forum All Other Contributions/Addons
    Replies: 13
    Last Post: 21 Jan 2015, 10:49 AM
  2. v139h I use seo url . can i install ultimate seo url ?
    By dmagic in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 6 Feb 2014, 11:38 PM
  3. SEO ultimage url error for expand categories
    By ary in forum General Questions
    Replies: 3
    Last Post: 5 Jul 2007, 05:19 PM
  4. SEO ultimage url error for expand categories~~new problem!
    By ary in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 5 Jul 2007, 09:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg