MantisBT - Piwigo
View Issue Details
0003057Piwigousers & groupspublic2014.03.18 23:302014.03.25 13:29
plg 
plg 
highminorsometimes
closedfixed 
2.6.0 
2.6.22.6.2 
any
Apache 1.3.x
0003057: incoherent permissions lead to SQL query crash
http://piwigo.org/forum/viewtopic.php?id=23482 [^]

Some new code in Piwigo 2.6 is much more sensitive when facing an incoherent permission and hierarchy. For example when user U1 has access to private album "A/A1" but not to private album "A".

It's hard to know when and how the incoherence was created but it exists on many Piwigo databases. It was not a real problem until now because it was not generating such a SQL crash with a, invalid value for user_cache.forbidden_categories.
No tags attached.
Issue History
2014.03.18 23:30plgNew Issue
2014.03.18 23:30plgStatusnew => assigned
2014.03.18 23:30plgAssigned To => plg
2014.03.18 23:30plgbrowser => any
2014.03.18 23:30plgWeb server => Apache 1.3.x
2014.03.24 21:19svnCheckin
2014.03.24 21:19svnNote Added: 0007378
2014.03.24 21:22svnCheckin
2014.03.24 21:22svnNote Added: 0007379
2014.03.25 13:29plgNote Added: 0007380
2014.03.25 13:29plgStatusassigned => closed
2014.03.25 13:29plgResolutionopen => fixed
2014.03.25 13:29plgFixed in Version => 2.6.2

Notes
(0007378)
svn   
2014.03.24 21:19   
[Subversion] r27925 by plg on branch 2.6

-----[Subversion commit log]----------------------------------------------------
bug 3057: avoid warnings and SQL crash when encountering inconsistent
permissions + rewrite permissions consistancy check when setting albums
to private status.
(0007379)
svn   
2014.03.24 21:22   
[Subversion] r27926 by plg on trunk

-----[Subversion commit log]----------------------------------------------------
merge r27925 from branch 2.6 to trunk

bug 3057: avoid warnings and SQL crash when encountering inconsistent
permissions + rewrite permissions consistancy check when setting albums
to private status.

(0007380)
plg   
2014.03.25 13:29   
Tested by rvelices http://piwigo.org/forum/viewtopic.php?pid=150653#p150653 [^]