rowlist All generating sql error

Questionsrowlist All generating sql error
Shehzad Ismail asked 6 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.

9 Answers
Abu Ghufran answered 6 years ago

Emailed you an update.

Helmi answered 6 years ago

Abu, I experience the same problem. Let us know when you have time to check this error.

Abu Ghufran answered 6 years ago

Emailing an update

David answered 6 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 6 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 6 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 6 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 6 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

Abu Ghufran answered 6 years ago

Hello David,

I am emailing you build.

Your Answer

20 + 17 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!