Hello, from some time (I’ve upgraded mysql server to version 8, but I don’t know if it depends on this) there are problems with export function.
If I use the option
$opt[“export”][“paged”] = “1”;
I get an error like this:
Couldn’t execute query. 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 ‘0’ at line 1 – SELECT * FROM elenco_reparti WHERE 1=1 ORDER BY 1 LIMIT OFFSET 0
Instead, if I use the option $opt[“export”][“range”] = “filtered”;
the export work BUT the records are NOT filtered (the entire table will be exported)
Thanks
Hello,
This could be due to php session reset.
When you load the grid, it keep few configration in session and when doing export, it reads from session to make export query.
Here it looks like LIMIT variable is somehow missed in query.
If you can email me code ([email protected]) i can review.