I was able to fix it. Please ignore. Thank you!!
Hi,
Has this issue been resolved? I installed the most recent version of the Plugin but the query does not return any data for the report. I tried the Debug option and the query’s Limit variable seems to be causing errors in the MySQL IDE.
‘My query’ is simple and queries a View and generates data via the IDE without issues.
My Query: SELECT * FROM wp_test_db.rpt_60_day;
Debug query generated: SELECT SQL_CALC_FOUND_ROWS * FROM wp_test_db.rpt_60_day; LIMIT 0,25
