WP-Filebase Pro › Forums › General Support › File Permission not working for all roles › Reply To: File Permission not working for all roles
2014-02-21 at 02:25
#1441
Meghan
Participant
Here is how I fixed the issue. It was caused by a mysql default.
[mysqld]
ft_min_word_len=3 change to
[mysqld]
ft_min_word_len=1
However I do not have access to mysql settings on my production server for this project so I used the following to fix the issue.
edit classes/item.php line 557
$permission_sql .= ” OR MATCH($permissions_field) AGAINST (‘{$ur}’ IN BOOLEAN MODE)”;
Changed to:
$permission_sql .= ” OR $permissions_field LIKE ‘%$ur|%’ OR $permissions_field LIKE ‘%|$ur|%’ OR $permissions_field LIKE ‘%$ur|%'”;
Hope this helps if you run into this issue.