"WordPress database error You have an error in your SQL syntax; check...error

Discussion in 'MySQL' started by ROOFIS, Aug 22, 2011.

0
  1. #1
    Howdy all, :) got a bit of a MySQL problem (a couple really) but this one I can't figure out what to do, and keeps poping up in the error log quite persistently. I tried repair table in phpmyadmin but it seems to have done little good.
    Any advice welcome, thanks.







    ROOFIS
     
    ROOFIS, Aug 22, 2011 IP
  2. mccomf

    mccomf Active Member

    Messages:
    517
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #2
    Where does the error appear.My guess is on a post page.Try to disable the plugins one by one and see if it works.I think this is not an issue with WordPress, but with a plugin.
     
    mccomf, Aug 22, 2011 IP
  3. ROOFIS

    ROOFIS Well-Known Member

    Messages:
    1,234
    Likes Received:
    30
    Best Answers:
    5
    Trophy Points:
    120
    #3
    Yeah I was thinking this as well. I just deactivated 59 of the 60 plugins installed (except article directory), surfed though the sites pages then checked the error log. apart from the "PHP Warning: require(/home/articleb/public_html/wp-includes/load.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/articleb/public_html/wp-settings.php on line 19" warning (ironically enough the file is indeed located where it's suppose to be) no MySql error has popped up. To fix the latter I'll try with a .htaccess entry. I'll activate the plugins one by one to see which one is causing the problem with Mysql. Hopefully all smooth sailing from here on.







    ROOFIS
     
    ROOFIS, Aug 22, 2011 IP
  4. freelanceinphp

    freelanceinphp Member

    Messages:
    134
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    48
    #4
    I think, you should activate minimum wordpress plugins requirments.
     
    freelanceinphp, Aug 25, 2011 IP
  5. DrDave

    DrDave Peon

    Messages:
    20
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I believe that table wp_avhec_category_groups belongs to a plugin called AVH extended categories widgets, so that is probably the only plugin you would need to deactivate.

    If you go to the plugin page on "wordpress.org" for that plugin, you can click on "See what others are saying" and post a comment about it letting the author know about the issue. He seems to be replying fairly quickly.
     
    DrDave, Aug 25, 2011 IP
    ROOFIS likes this.