WordPress.org

Ready to get started?Download WordPress

Forums

Watu
[resolved] SQL Error (7 posts)

  1. aero.roger77
    Member
    Posted 1 year ago #

    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/

  2. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  4. aero.roger77
    Member
    Posted 1 year ago #

    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.

  5. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    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)

  6. aero.roger77
    Member
    Posted 1 year ago #

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

  7. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    You welcome :)

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.