Hi, I'm installing spectra 1.5.3. and I have migrated the MS ACCESS table to ORACLE 9 (9.2.0.5.0) successfully. However, when running the installer, I get the following message:
Security Configuration Error The error message returned is: Application () Security Policy action failed unexpectedly: Add Security Context Error. Security Policy action failed unexpectedly: GetRule. Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle] ORA-00923: FROM keyword not found were expected. I've tracked this down to the _getrule.cfm file (called from cfa_newinternaladminsecurity.cfm) which tries to query the rules.secure_object as resource. This query fails because resource is an ORACLE RESERVED WORD. The solution is of course to add double quotes around it in ALL the queries :-/ Anybody found another way to avoid adapting the source code ?? Thanx, Esther ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5686 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.17 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
