Bug #16709
closed
Page tree not rendered for Non-Admins (Oracle)
0%
Description
In BE, the page tree cannot be rendered for BE-Users that don't have admin privileges. The reason is the use of the operator "&" instead of BITAND.
(issue imported from #M4494)
Updated by Martin Kutschker over 17 years ago
DBAL could parse the query for the & operator.
OTOH as & is perhaps rarely used it could XLCASS the function in the Core which uses the & and use BITAND for Oracle.
Updated by Volkmar K over 17 years ago
The incompatible code is made by t3lib_userAuthGroup.getPagePermsClause().
Unfortunately, changing the code there to "BITAND" causes the dbal to refuse the translation of the statement.
IMHO either the way of getting user's permission or the capabilities of the dbal to handle bitwise operators have to be changed.
Updated by Sven Limbach over 17 years ago
Is there any workarround for this bug? Or does it need more information or investigation? we have exact the same issue on a ORACLE 10G 10.1.0.4.2 Database
Updated by musked about 17 years ago
We have the same pb on Oracle Database 10g Release 2 (10.2.0.1.0) under Linux . Can we hope for a corrective measure asap?
thanks a lot for this great CMS.
Updated by Administrator Admin about 17 years ago
Hi,
We wish use this cms in our entreprise, but we can't choose this one whith this major bug.
We have to let the project in stand-bye, waiting this fix.
Cordially.
Y.V.
Updated by Martin Kutschker about 17 years ago
Karsten, didn't you have a workaround (if not a fix) in a planning state, or so?
Updated by Karsten Dambekalns about 17 years ago
Fixed in SVN.
Those interested please check out the DBAL extension from TYPO3 SVN trunk and check if ot helps. Mind that it might be best to recreate all tables, as longer text fields are CLOB fields now, as well.