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.
Thanks for the response – the reports I am having problems with do all begin with SELECT statements, is there anything else that has changed?
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
See post above – got it sorted, but thanks for your help!