Hi,
filters still don't work in 5.96. The error only occurs with a user who is not admin or is not in the admin group. The error has existed since 5.95.
Error: 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 'order by 3 asc LIMIT 0, 10' at line 1
Many greetings, Kai
5.96 filters still don't work
Re: 5.96 filters still don't work
Whenever I get that error it seems to have something to do with record ownership permissions and what the admin is allowing others to view. Maybe not in your instance, but something to check out.
Re: 5.96 filters still don't work
Yes. permissions set to "owner".
Re: 5.96 filters still don't work
Is it possible that the username you're testing on has "Special Permissions" set that are over riding the group settings. Or is it possible that the username you're testing on doesn't Own the records that are being filtered?
Re: 5.96 filters still don't work
I'm also having the same problem that SkayyHH reports.
Filter works for Admins but not for other groups.
Code: Select all
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 25' at line 1
Re: 5.96 filters still don't work
It's seems the problem in in the datalist.php file around line 497 there is a new line of code that is causing the problem
By commennt this line the filters are working, but I'm not sure if this can cause another problem.
Code: Select all
$QueryHasWhere = preg_match('/^WHERE\s+/i', $this->QueryWhere);
Re: 5.96 filters still don't work
This is super annoying! I am building my first application, I need to make it available this week and now I find out that even a simple filter like selecting active/non active memebers in my database produces this error. Unacceptable! And yes, the user is the owner of the records and has all rights on the table except delete. There are some restrictions for the group the user belongs to on related tables. I will just see if tweaking in that area makes a difference.
Re: 5.96 filters still don't work
What in my opinion should also be changed / fixed is the displayed options at the bottom of the filter page.
Here there is a selection which data records should be displayed. Here I can, for example, select "all" or "group" records, although I only have "own records" as permission.
This irritates some users.
Many greetings, Kai
Here there is a selection which data records should be displayed. Here I can, for example, select "all" or "group" records, although I only have "own records" as permission.
This irritates some users.
Many greetings, Kai
Re: 5.96 filters still don't work
this is a really frustrating bug. I have records that are permission based, this works ok when the table does not have a predefined filter. But where i have defined the filter in the hooks file. i get the error.
Ahmed do you know when we are likely to get a fix for this?
Ahmed do you know when we are likely to get a fix for this?
AppGini 22.13
Re: 5.96 filters still don't work
This is fixed now in AppGini 5.97. Please give it a try.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: 5.96 filters still don't work
thanks for your quick reply Ahmed, always appreciated. I do get a different error now:
any ideas?
any ideas?
AppGini 22.13
Re: 5.96 filters still don't work
Thanks Ahmed, it´s fine now
Greetings, Kai
Greetings, Kai