What table? I have FC3 running great on Oracle 10g, but getting it there required some fixes of core file and manual changes. I'd find the table and add it manually then report this as a possible bug.
-Jake -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jedi Sent: Monday, December 10, 2007 3:19 AM To: farcry-dev Subject: [farcry-dev] News item approval error on FC4.09 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) No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.17/1179 - Release Date: 12/9/2007 11:06 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.17/1179 - Release Date: 12/9/2007 11:06 AM --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
