WPBILite 1.0.7 Query returned 0 rows.

  • Resolved olsonea

    (@olsonea)


    11 years, 1 month ago

    There appears to be a defect in the plugin, such that zero rows are returned by the simplest queries.

    I set WP_DEBUG = true in wp-config.php. lo and behold the following error:

    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 ‘;) t’ at line 1]
    select count(*) from (select 1;) t

    Here’s my query:
    `select 1;’

    It seems that the string ‘) t’ is appended to my query.

    https://www.ads-software.com/plugins/wp-business-intelligence-lite/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter olsonea

    (@olsonea)

    Nevermind. It’s my fault. Your plugin is not expecting the ending semicolon, which is valid (and required) by mysql. This is a bit confusing to someone who is expecting to enter a valid mysql statement.

    Hi!
    Yes, you’re right. The semicolon is not required in the query.
    This is mainly due to some library we’re using, but can remove this limitation in future relases.
    cheers,
    c.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WPBILite 1.0.7 Query returned 0 rows.’ is closed to new replies.