[farcry-dev] FU causing errors

[Shib71]

G'day

When I have friendly urls active I have problems whenever I add or update site tree objects. The changes do seem to be implemented, but I get an error like this. I'm also getting points in the FU path getting redirected to home, but I suspect that's a different problem entirely. If anyone knows what the problem is I'd appreciate a hand.

Merry Christmas
Blair McKenzie

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.   The error occurred in E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc: line 85 Called from E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc: line 468 Called from E:\Inetpub\farcry\farcry_core\packages\types\types.cfc: line 484 Called from E:\Inetpub\farcry\farcry_core\packages\types\types.cfc: line 127 Called from E:\Inetpub\farcry\farcry_core\packages\types\_dmhtml\edit.cfm: line 81 Called from E:\Inetpub\farcry\farcry_core\packages\types\dmHTML.cfc: line 46 Called from E:\Inetpub\farcry\farcry_core\tags\navajo\edit.cfm: line 125 Called from E:\Inetpub\farcry\farcry_core\admin\edittabEdit.cfm: line 45 Called from E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc: line 85 Called from E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc: line 468 Called from E:\Inetpub\farcry\farcry_core\packages\types\types.cfc: line 484 Called from E:\Inetpub\farcry\farcry_core\packages\types\types.cfc: line 127 Called from E:\Inetpub\farcry\farcry_core\packages\types\_dmhtml\edit.cfm: line 81 Called from E:\Inetpub\farcry\farcry_core\packages\types\dmHTML.cfc: line 46 Called from E:\Inetpub\farcry\farcry_core\tags\navajo\edit.cfm: line 125 Called from E:\Inetpub\farcry\farcry_core\admin\edittabEdit.cfm: line 45 83 : WHERE refObjectID = <cfqueryparam value="#stLocal.refObjectID#" cfsqltype="cf_sql_varchar">84 : AND friendlyurl = <cfqueryparam value="#stLocal.friendlyURL#" cfsqltype="cf_sql_varchar"> 85 : AND status = <cfqueryparam value="#stLocal.status#" cfsqltype="cf_sql_integer">86 : </cfquery>87 : SQL    SELECT objectid FROM dbo.reffriendlyURL WHERE refObjectID = (param 1) AND friendlyurl = (param 2) AND status = (param 3) DATASOURCE   farcry_intranet VENDORERRORCODE   306 SQLSTATE   HY000 Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser   Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7 Remote Address   192.107.1.11 Referrer   http://deku/farcry/edittabedit.cfm?objectid=0902EA27-F1F6-5DEA-B761C7B671AEDEFA Date/Time   20-Dec-05 02:52 PM Stack Trace at cffu2ecfc1477534282$funcSETMAPPING.runFunction(E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc:85) at cffu2ecfc1477534282$funcSETFU.runFunction(E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc:468) at cftypes2ecfc1981356151$funcSETFRIENDLYURL.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\types.cfc:484) at cftypes2ecfc1981356151$funcSETDATA.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\types.cfc:127) at cfedit2ecfm745389712.runPage(E:\Inetpub\farcry\farcry_core\packages\types\_dmhtml\edit.cfm:81) at cfdmHTML2ecfc1348242857$funcEDIT.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\dmHTML.cfc:46) at cfedit2ecfm1388627506.runPage(E:\Inetpub\farcry\farcry_core\tags\navajo\edit.cfm:125) at cfedittabEdit2ecfm1004681365.runPage(E:\Inetpub\farcry\farcry_core\admin\edittabEdit.cfm:45) at cffu2ecfc1477534282$funcSETMAPPING.runFunction(E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc:85) at cffu2ecfc1477534282$funcSETFU.runFunction(E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc:468) at cftypes2ecfc1981356151$funcSETFRIENDLYURL.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\types.cfc:484) at cftypes2ecfc1981356151$funcSETDATA.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\types.cfc:127) at cfedit2ecfm745389712.runPage(E:\Inetpub\farcry\farcry_core\packages\types\_dmhtml\edit.cfm:81) at cfdmHTML2ecfc1348242857$funcEDIT.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\dmHTML.cfc:46) at cfedit2ecfm1388627506.runPage(E:\Inetpub\farcry\farcry_core\tags\navajo\edit.cfm:125) at cfedittabEdit2ecfm1004681365.runPage(E:\Inetpub\farcry\farcry_core\admin\edittabEdit.cfm:45) java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. at macromedia.jdbc.base.BaseExceptions.createException (Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken (Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType (Unknown Source) at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.postImplExecute (Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:87) at coldfusion.sql.Executive.executeQuery (Executive.java:722) at coldfusion.sql.Executive.executeQuery(Executive.java:652) at coldfusion.sql.Executive.executeQuery(Executive.java:613) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) at coldfusion.tagext.sql.QueryTag.doEndTag (QueryTag.java:499) at cffu2ecfc1477534282$funcSETMAPPING.runFunction(E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc:85) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke (UDFMethod.java:294) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain (UDFMethod.java:211) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:370) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cffu2ecfc1477534282$funcSETFU.runFunction(E:\Inetpub\farcry\farcry_core\packages\farcry\fu.cfc:468) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java :258) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:145) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cftypes2ecfc1981356151$funcSETFRIENDLYURL.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\types.cfc:484) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java :258) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cftypes2ecfc1981356151$funcSETDATA.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\types.cfc:127) at coldfusion.runtime.UDFMethod.invoke (UDFMethod.java:348) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258) at coldfusion.filter.FunctionAccessFilter.invoke (FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:370) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java :1772) at cfedit2ecfm745389712.runPage(E:\Inetpub\farcry\farcry_core\packages\types\_dmhtml\edit.cfm:81) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag (IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfdmHTML2ecfc1348242857$funcEDIT.runFunction(E:\Inetpub\farcry\farcry_core\packages\types\dmHTML.cfc:46) at coldfusion.runtime.UDFMethod.invoke (UDFMethod.java:348) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain (UDFMethod.java:211) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:370) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:156) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cfedit2ecfm1388627506.runPage(E:\Inetpub\farcry\farcry_core\tags\navajo\edit.cfm:125) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255) at cfedittabEdit2ecfm1004681365.runPage(E:\Inetpub\farcry\farcry_core\admin\edittabEdit.cfm:45) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke (ApplicationFilter.java:210) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java :52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java :38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java :204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable (ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)