Support » Plugin: YOP Poll » WordPress database error: SQL syntax error

  • Resolved crysman

    (@crysman)


    If I select “Expired” or “Started” or “Not Started” filter in “All polls” list, there is a 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 ‘= ‘2013-07-30 17:48:51’ AND ( name like ‘%%’ OR question like ‘%%’ ) OR’ at line 1]
    SELECT * FROM luzwp_yop_polls WHERE end_date <= ‘2013-07-30 17:48:51’ AND ( name like ‘%%’ OR question like ‘%%’ ) ORDER BY name

    I see there is a SQL query containing

    like ‘%%’

    which is very probably wrong.

    I am using latest (4.2) version on WP 3.5.1

    If this is a bug, are you going to patch it?
    Thanks

    http://wordpress.org/plugins/yop-poll/

Viewing 1 replies (of 1 total)
  • Plugin Author YOP

    (@yourownprogrammer)

    Hi crysman,

    It looks like there’s a bug and we will fix it in the future.
    Thanks for reporting.

    Regards,

    YOP Team

Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error: SQL syntax error’ is closed to new replies.