WordPress.org

Support

Support » Plugins and Hacks » Watu » [Resolved] SQL Error

[Resolved] SQL Error

  • My theme generate this error when I activate the quiz pro.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) order by c.name’ at line 1]

    select c.* from wp_terms c,wp_term_taxonomy tt where tt.term_id=c.term_id and tt.taxonomy in (‘placecategory’,’eventcategory’) and count>0 and c.term_id not in () order by c.name

    and this one

    select regions from wp_multicountry where country_id=

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]

    select cities from wp_multicountry where country_id=

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) order by sortorder asc, is_default desc’ at line 1]

    select city_id,cityname,city_slug from wp_multicity where city_id in () order by sortorder asc, is_default desc

    I’m also getting a 500 server error when I try to access my pages from the admin backend. All these problems are gone when I deactivate the plugin.

    http://wordpress.org/extend/plugins/watu/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author prasunsen

    @prasunsen

    Hi Roger,

    These queries are not at all related to Watu. Watu does not use even one of the queries shown above. It’s another plugin that’s causing the errors.

    Plugin Author prasunsen

    @prasunsen

    As watu activates the error display in WordPress, it’s just that the errors from other plugin have become now visible. From what I see it’s some plugin about events. So see what is it and deactivate it, apparently it’s useless and doesn’t work.

    Okay I will try and ask the theme author. Was kind of weird that they were gone when I deactivaed the quiz, but on the same time, they were not there from the beginning of the installationn of the quiz.

    Plugin Author prasunsen

    @prasunsen

    That’s because watu is setting error display to True. If you want I can hide the errors for you, but this is not a great idea – it’s far better to deactivate the non-working plugin. Anyway, if you want errors hidden, pls let me know on email (I think you are already using Pro)

    Thanks for the info 🙂 and sorry for blaming watu 🙂 I was worried cause its the greatest quiz plugin I’ve ever used. 🙂

    Plugin Author prasunsen

    @prasunsen

    You welcome 🙂

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Resolved] SQL Error’ is closed to new replies.
Skip to toolbar