Hello, I am seeing an error when i set the Action in the news administartion page of a news item to approve and then submitting.
Looking at the error there seems to be a table missing. The install didnt produce any errors so a little confused on why this is happening. Using CF8 IIS and Oracle 10g. Any help is appreciated. Jedi Error is: Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist The error occurred in D:\CFAPPS\farcry\core\packages\farcry\fu.cfc: line 67 Called from D:\CFAPPS\farcry\core\packages\farcry\fu.cfc: line 436 Called from D:\CFAPPS\farcry\core\packages\types\types.cfc: line 1353 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 169 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 114 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 113 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 110 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 1 Called from D:\CFAPPS\farcry\core\admin\navajo\approve.cfm: line 7 Called from D:\CFAPPS\farcry\core\packages\farcry\fu.cfc: line 67 Called from D:\CFAPPS\farcry\core\packages\farcry\fu.cfc: line 436 Called from D:\CFAPPS\farcry\core\packages\types\types.cfc: line 1353 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 169 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 114 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 113 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 110 Called from D:\CFAPPS\farcry\core\tags\navajo\objectStatus.cfm: line 1 Called from D:\CFAPPS\farcry\core\admin\navajo\approve.cfm: line 7 65 : WHERE refObjectID = <cfqueryparam value="#stLocal.refObjectID#" cfsqltype="cf_sql_varchar"> 66 : AND friendlyurl = <cfqueryparam value="#stLocal.friendlyURL#" cfsqltype="cf_sql_varchar"> 67 : AND status = <cfqueryparam value="#stLocal.status#" cfsqltype="cf_sql_integer"> 68 : </cfquery> 69 : -------------------------------------------------------------------------------- SQLSTATE 42S02 SQL SELECT r.objectid FROM reffriendlyURL u inner join refObjects r on r.objectid = u.refobjectid WHERE refObjectID = (param 1) AND friendlyurl = (param 2) AND status = (param 3) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
