Hi guys, I'm getting the following error upon logging in to farcry after a fresh install on Oracle 8.1.7 (Solaris)
====================== "[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
