#267
  • Created on
    2011-04-19 18:49
  • Reported by
    joseph.gay
  • Work remaining
    2.25 hours
  • Worked hours
    0.75 hours
  • Status
    New
  • Priority
    Low (4)
  • Assigned to
    -
  • Milestone
    Backlog
  • Plan Level
    -
  • Due Date
    -

Attachments

Edit

Merge Requests

(SQLite) Public Folder ViewableTreeChange handler unsuccessful fixing Public Folder view permissions

Steps to Reproduce:

1.) Create a public folder.
2.) Observe that the Everybody group has "Browse File in Web Preview" and "Download Original File" permissions.
3.) Remove all view permissions for Everybody from the Public Folder directly, or a higher level folder recursively.
4.) Observe the view permissions for Everybody on the Public Folder.

Result:
Original permissions are removed.

Expected Result:
Original permissions should be preserved by the Public Folder ViewableTreeChange event handler.

Workaround:
It is possible to re-enable the Public folder functionality by adding back the two view permissions manually, or by unsetting and resetting the folder's hidden/public status.
User picture
  on 2011-04-19 19:12 *
By joseph.gay
Milestone changed from Backlog to Milestone 34.1
User picture
  on 2011-04-19 19:12 *
By joseph.gay
Status changed from New to Accepted
User picture
  on 2011-04-19 19:12 *
By joseph.gay
Assigned to set to joseph.gay
User picture
  on 2011-04-19 20:04 *
By joseph.gay
Work remaining changed from 3.0 to 2.25
This may be an SQLite specific error due to the use of the user defined REGEXP function by fetchDescendentItemIds. Still need to verify that it works with MySQL.
User picture
  on 2011-05-16 17:57 *
By joseph.gay
Assigned to changed from joseph.gay to -none-
Milestone changed from Milestone 34.1 to Backlog
Priority changed from Normal (3) to Low (4)
Summary changed from Public Folder ViewableTreeChange handler unsuccessful fixing Public Folder view permissions to (SQLite) Public Folder ViewableTreeChange handler unsuccessful fixing Public Folder view permissions
Status changed from Accepted to New
Confirmed as SQLite issue for reasons cited (lack of REGEXP). SQLite provides a facility for user-defined functions, so one fix would be to define our own REGEXP. Moving to backlog.