5.96 filters still don't work

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
SkayyHH
Veteran Member
Posts: 425
Joined: 2015-04-27 21:18

5.96 filters still don't work

Post by SkayyHH » 2021-05-17 21:16

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
Veteran Member
Posts: 425
Joined: 2015-04-27 21:18

Re: 5.96 filters still don't work

Post by SkayyHH » 2021-05-17 21:32


rpierce
Veteran Member
Posts: 255
Joined: 2018-11-26 13:55
Location: Washington State

Re: 5.96 filters still don't work

Post by rpierce » 2021-05-24 16:57

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
Veteran Member
Posts: 425
Joined: 2015-04-27 21:18

Re: 5.96 filters still don't work

Post by SkayyHH » 2021-05-25 14:54

Yes. permissions set to "owner".

rpierce
Veteran Member
Posts: 255
Joined: 2018-11-26 13:55
Location: Washington State

Re: 5.96 filters still don't work

Post by rpierce » 2021-05-26 18:39

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
Veteran Member
Posts: 81
Joined: 2017-02-25 20:32

Re: 5.96 filters still don't work

Post by Alisson » 2021-05-30 16:58

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
Veteran Member
Posts: 81
Joined: 2017-02-25 20:32

Re: 5.96 filters still don't work

Post by Alisson » 2021-05-30 18:20

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
Posts: 2
Joined: 2016-12-21 20:21

Re: 5.96 filters still don't work

Post by marchey » 2021-05-31 07:30

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
Veteran Member
Posts: 425
Joined: 2015-04-27 21:18

Re: 5.96 filters still don't work

Post by SkayyHH » 2021-05-31 14:01

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
Veteran Member
Posts: 128
Joined: 2020-05-28 22:27

Re: 5.96 filters still don't work

Post by angus » 2021-06-14 11:41

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?
AppGini 22.13

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: 5.96 filters still don't work

Post by a.gneady » 2021-06-14 11:52

This is fixed now in AppGini 5.97. Please give it a try.
:idea: 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.

angus
Veteran Member
Posts: 128
Joined: 2020-05-28 22:27

Re: 5.96 filters still don't work

Post by angus » 2021-06-14 16:57

thanks for your quick reply Ahmed, always appreciated. I do get a different error now:
error.png
error.png (8.36 KiB) Viewed 2658 times
any ideas?
AppGini 22.13

SkayyHH
Veteran Member
Posts: 425
Joined: 2015-04-27 21:18

Re: 5.96 filters still don't work

Post by SkayyHH » 2021-06-14 19:52

Thanks Ahmed, it´s fine now :-)

Greetings, Kai

Post Reply