So the easiest to reproduce is to have a table (for example table with name "notes") where you give full permission to admins group (insert, view for all, edit for all, delete for all) and a second group for example clients which have access to the same table with group level (insert, view for group, edit for group, delete for group).
If you are logged in with a user from the clients group and you have the datalist.php from v5.95 and try to filter the table "notes" for example with the regular filter (something simple like ID equals to 1) and you will get this 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 'LIMIT 0, 10' at line 1
Then you can log out and login with an admin account and try to do the same thing and it will all work ok.
Now if you remove this line from datalist.php
Code: Select all
$QueryHasCustomWhere = (strlen($this->QueryWhere) > 0);
and edit this line
Code: Select all
if($WhereNeedsClosing && !$QueryHasCustomWhere)
to be
it all works ok for both groups admins and clients can use filters with no problems.
Something that I think is connected to this issue is the homeLinks[] and navLinks[] arrays in links-home.php hooh and links-navmenu.php hooks.
If you create a link with a group permission like this:
or
custom links are shown OK and everything is fine.
But if you use two groups like this:
Code: Select all
'groups' => array('Admins', 'Lawyers'),
where Lawyers is a group with limited permissions like the clients group from the above example, then home and nav links are not displayed for both groups.
Both problems appeared in two of my apps after update from 5.94 to 5.95.