Hi Craig, I kicked off some traffic on this last week - it looks like some 8.x revs of Oracle don't support CROSS JOINs (I was running 8.1.7 on Solaris too).
I started down the work-around path then switched to MySQL. If you look back in the archives I mentioned a site that spoke about Oracle cross join work-arounds. cheers David -----Original Message----- From: Craig McDonald [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 1:12 PM To: FarCry Developers Subject: [farcry-dev] Oracle permissions table error Hi guys, I'm getting the following error upon logging in to farcry after a fresh install on Oracle ====================== "[Macromedia][Oracle JDBC Driver][Oracle]ORA-00907: missing right parenthesis The error occurred in C:\FarCry\farcry_core\admin\includes\cfFunctionWrappers.cfm: line 34 Called from C:\FarCry\farcry_core\packages\security\authorisation.cfc: line 907 Called from C:\FarCry\farcry_core\packages\security\authorisation.cfc: line 185 Called from C:\FarCry\farcry_core\tags\navajo\Login.cfm: line 62 Called from C:\FarCry\farcry_core\admin\login.cfm: line 34 Called from C:\FarCry\farcry_core\admin\includes\cfFunctionWrappers.cfm: line 34 Called from C:\FarCry\farcry_core\packages\security\authorisation.cfc: line 907 Called from C:\FarCry\farcry_core\packages\security\authorisation.cfc: line 185 Called from C:\FarCry\farcry_core\tags\navajo\Login.cfm: line 62 Called from C:\FarCry\farcry_core\admin\login.cfm: line 34 SELECT s.policyGroupId, s.permissionId, b.status FROM (SELECT g.policyGroupId, p.permissionId FROM uccms_farcry.dmPolicyGroup g CROSS JOIN dmPermission p WHERE upper(p.PermissionType)='POLICYGROUP' ) s LEFT OUTER JOIN uccms_farcry.dmPermissionBarnacle b ON s.permissionId = b.permissionID AND s.policyGroupId = b.policyGroupId AND upper(b.Reference1)='POLICYGROUP'" ====================== I recall some discussion earlier that certain join syntax wasn't supported on Oracle 8i? Any help appreciated. I get a similar error browsing to the site. Thanks, Craig McDonald --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
