Shehzad Ismail asked 11 years ago
My grid is correctly able to show 100 and 250 records but when I select ALL in the grid, it gives me the error:
"Couldn't execute query. You have an error in your SQL syntax*semicolon* check the manual that corresponds to your MySQL server version for the right syntax to use near 'All OFFSET 0' at line 1 – SELECT i.*, c.name, u.user_name FROM timesheets i INNER JOIN clients c ON c.client_id = i.client_id INNER JOIN users u ON i.user_id = u.user_id WHERE 1=1 ORDER BY timesheet_id desc LIMIT All OFFSET 0"
Looks like its created because of the LIMIT ALL OFFSET 0. Not sure how to get rid of it. I believe I followed this part of the documentation correctly.
Helmi answered 11 years ago
Abu, I experience the same problem. Let us know when you have time to check this error.
David answered 10 years ago
I experience the same problem with full 1.5.
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 'All OFFSET 0' at line 1
do you have a fix for that ?
Thanks
Abu Ghufran answered 10 years ago
Please explain the steps and code config you are using to generate this issue.
Version 1.5 have this issues already fixed. I'll recheck it again after your reply.
Screenshot might help too. You can use http://postimg.org/ for image sharing.
Susan Watt answered 10 years ago
I am getting the same sql error. I have full version 1.4.8. Do I need an update? How do I get regular updates for the full version?
Abu Ghufran answered 10 years ago
Hello Susan,
I'm emailing you latest build.
The major releases are emailed to active subscription customers when released.
For minor builds, they are usually requested via email.
Regards,
David answered 10 years ago
Hi Abu, sorry for late answer but i miss your reply !
here is the error
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 'All OFFSET 0' at line 1 – SELECT *,qty*prix_htva as tot_prix_htva FROM inventaire WHERE 1=1 ORDER BY famille asc, 1 asc LIMIT All OFFSET 0
if i copy query to phpmyadmin it return same error.
i'm using mysql 5.5.16 maybe "limit all" is not working with this version ?
Thanks
