I have gone through this over and over again about this problem and no one
seems to want to help me out. I have had many problems ever since I
upgraded from FC 2.1 to FC 3.0. Content creation just seems to throw errors
left and right from creating to editing. It doesn't set the Label field or
title field when needed. Below is the error I am getting. Please can
someone help me out. If I can't get this resolved I don't think i will
using FC much longer.
-------------
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
'DBO.dmNews_aRelatedIDs'.
The error occurred in E:\Inetpub\Applications\fourq\_fourq\getData.cfm: line
84
Called from E:\Inetpub\Applications\fourq\fourq.cfc: line 206
Called from
E:\Inetpub\Applications\farcry_core\admin\conjuror\invocation.cfm: line 102
Called from E:\Inetpub\Applications\fourq\_fourq\getData.cfm: line 84
Called from E:\Inetpub\Applications\fourq\fourq.cfc: line 206
Called from
E:\Inetpub\Applications\farcry_core\admin\conjuror\invocation.cfm: line 102
82 : <cfquery datasource="#arguments.dsn#" name="qArrayData">
83 : select * from #arguments.dbowner##tablename#_#key#
84 : where objectid = '#arguments.objectID#'
85 : order by seq
86 : </cfquery>
SQL select * from DBO.dmNews_aRelatedIDs where objectid =
'A78E0DF4-FB89-33FF-210125E034785485' order by seq
DATASOURCE bcintra
VENDORERRORCODE 208
SQLSTATE 42S02
Please try the following:
* 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.2; en-US; rv:1.8.0.2)
Gecko/20060308 Firefox/1.5.0.2
Remote Address 10.1.1.106
Referrer http://info/farcry/content/dmnews.cfm
Date/Time 02-May-06 01:59 PM
Stack Trace
at
cfgetData2ecfm2041542578.runPage(E:\Inetpub\Applications\fourq\_fourq\getData.cfm:84)
at
cffourq2ecfc27246940$funcGETDATA.runFunction(E:\Inetpub\Applications\fourq\fourq.cfc:206)
at
cfinvocation2ecfm1336236786.runPage(E:\Inetpub\Applications\farcry_core\admin\conjuror\invocation.cfm:102)
at
cfgetData2ecfm2041542578.runPage(E:\Inetpub\Applications\fourq\_fourq\getData.cfm:84)
at
cffourq2ecfc27246940$funcGETDATA.runFunction(E:\Inetpub\Applications\fourq\fourq.cfc:206)
at
cfinvocation2ecfm1336236786.runPage(E:\Inetpub\Applications\farcry_core\admin\conjuror\invocation.cfm:102)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid
object name 'DBO.dmNews_aRelatedIDs'.
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.TDSRPCCursorExecuteRequest.processReplyToken(Unknown
Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at
macromedia.jdbc.sqlserver.tds.TDSRPCCursorExecuteRequest.commonExecute(Unknown
Source)
at
macromedia.jdbc.sqlserver.tds.TDSRPCCursorExecuteRequest.submitUnpreparedExecute(Unknown
Source)
at macromedia.jdbc.sqlserver.tds.TDSRPCExecuteRequest.execute(Unknown
Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at
coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:974)
at coldfusion.sql.Executive.executeQuery(Executive.java:886)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at
cfgetData2ecfm2041542578.runPage(E:\Inetpub\Applications\fourq\_fourq\getData.cfm:84)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876)
at
cffourq2ecfc27246940$funcGETDATA.runFunction(E:\Inetpub\Applications\fourq\fourq.cfc:206)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:44)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:250)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1587)
at
cfinvocation2ecfm1336236786.runPage(E:\Inetpub\Applications\farcry_core\admin\conjuror\invocation.cfm:102)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
---------------
--
View this message in context:
http://www.nabble.com/Content-creation-view-error-t1545996s621.html#a4199721
Sent from the FarCry - Dev forum at Nabble.com.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
