[TYPO3-dev] Pagetree Error with Oracle

[lambdaoe]

Hi,

there is no &-Operator (see  
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/fundamentals.htm)
I believe the &1, &1 was once in Ver 4 or 5 to pass paramters to Batch-SQL  
Statements.

Depending on what should be done there should be a function.

Regards


Am 08.11.2006, 17:40 Uhr, schrieb Volkmar K. Lecke <typo3 at lenectis.de>:

> Hi,
>
>
> I'm trying to get a site running with TYPO3 4.0.2 and Oracle as its  
> database system.
>
> Unfortunately, the page tree isn't renderd for non-admin users in the  
> backend. I found the following hint in the error log of dbal:
>
>
> SELECT "uid" FROM "pages" WHERE "deleted" = 0 AND "uid" IN (1,6,8) AND  
> (("pages"."perms_everybody"&1 = 1) OR ("pages"."perms_userid" = 2 AND  
> "pages"."perms_user"&1 = 1) OR ("pages"."perms_groupid" in (1,2,3) AND  
> "pages"."perms_group"&1 = 1))
>
> ORA-00920: invalid relational operator
>
>
> The added "&1" cause the error that finally leads to the code not being  
> executed.
>
> Does anyone know where the error comes from and what could be done to  
> solve it?
>
>
> Thanks
> Volkmar



-- 
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/