Getting the error:
WARN: Simple Query could not be completedYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=100’ at line 1
This is the query I am using:
SELECT * FROM simple_history1
Just wanting to bring in a simple query into a report and getting this error. I can run this query in the DataBase Query Browser but I get <N/A> in all the columns.
Any help would be appreciated,