5.96 filters still don't work

[SkayyHH]

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

[SkayyHH]

See this video please:

http://contray.de/!/Video_2021-05-17_230707.wmv

[rpierce]

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.

[SkayyHH]

Yes. permissions set to "owner".

[rpierce]

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?

[Alisson]

I'm also having the same problem that SkayyHH reports.

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

Filter works for Admins but not for other groups.

[Alisson]

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

Code: Select all

$QueryHasWhere = preg_match('/^WHERE\s+/i', $this->QueryWhere);

By commennt this line the filters are working, but I'm not sure if this can cause another problem.

[marchey]

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.

[SkayyHH]

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

[angus]

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?

[a.gneady]

This is fixed now in AppGini 5.97. Please give it a try.

[angus]

thanks for your quick reply Ahmed, always appreciated. I do get a different error now:

error.png (8.36 KiB) Viewed 5203 times

any ideas?

[SkayyHH]

Thanks Ahmed, it´s fine now

Greetings, Kai