• Resolved Grousha

    (@grousha)


    I updated the plugin to the latest version yesterday and now my reports are not working. Instead of the results tables I see the following:

    Query returned 673 rows in 11.123 seconds.

    Query affected 673 rows!

    Array ( [0] =>

    [1] =>
    [2] =>

    )

    Any ideas what is causing this?

    https://wordpress.org/plugins/elisqlreports/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Eli

    (@scheeeli)

    This is due to need to conform to using the global $wpdb object and the fact that you cannot perform the get_results function on a query that is not a SELECT or SHOW query. So my plugin is now checking the beginning of your query and only returning results if it starts with SELECT or SHOW.

    Please make sure your reports don’t start with comments. If you are expecting results from another type of query please let me know what that is so I can work it into the validation routine.

    Thread Starter Grousha

    (@grousha)

    Thanks for the response – the reports I am having problems with do all begin with SELECT statements, is there anything else that has changed?

    Thread Starter Grousha

    (@grousha)

    It’s okay – looks like the ones that didn’t work have a return after SELECT but before the query. I’ve removed this and it seems to work.

    Plugin Author Eli

    (@scheeeli)

    Oh, ok, great. I’m glad you were able to figure it out. I’ll try to make the syntax inspection more forgiving in the next release.

    Aloha, Eli

    Thread Starter Grousha

    (@grousha)

    See post above – got it sorted, but thanks for your help!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Reports no longer working since update’ is closed to new replies.