I am positive. So I found something very interesting now. If I remove my class aliases and use the class instead I instead get an error that catalog.categories.title is an invalid field. The strange thing is that it is definetly a valid field in the database, and in the transfer.xml file. So it seems that the error came because the SQL couldn't find the column title, and transfer took that as the class alias doesn't exist.
On Sep 30, 4:38 pm, Mark Mandel <[email protected]> wrote: > I can't see anything from with your SQL syntax. > > You sure that is the right TQL query that is failing? > > Mark > > On Fri, Oct 1, 2010 at 6:33 AM, David Long <[email protected]> wrote: > > I am sure. I run another transfer call just before this one and that > > one works just fine. Nothing is wrong in my TQL syntax? > > > On Sep 30, 4:32 pm, Mark Mandel <[email protected]> wrote: > > > That looks like it should work. > > > > You sure you're not pointing it at the wrong config file, or anything > > silly > > > like that? > > > > Mark > > > > On Fri, Oct 1, 2010 at 6:25 AM, David Long <[email protected]> > > wrote: > > > > The exact error message from ACF > > > > > Exception - struct > > > > Detail Could not find 'category' in '/home/david/opt/coldfusion/8/ > > > > wwwroot/config/transfer.xml'. > > > > ErrorCode [empty string] > > > > ExtendedInfo [empty string] > > > > Message The requested object could not be found in the config > > file > > > > StackTrace coldfusion.runtime.CustomException: The requested > > object > > > > could not be found in the config file at > > > > coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:124) at > > > > coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at > > > > cfObjectDAO2ecfc95842874$funcTHROW.runFunction(/home/david/opt/ > > > > coldfusion/8/wwwroot/transfer/com/object/ObjectDAO.cfc:637) at > > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2471) at > > > > cfObjectDAO2ecfc95842874$funcGETOBJECT.runFunction(/home/david/opt/ > > > > coldfusion/8/wwwroot/transfer/com/object/ObjectDAO.cfc:72) at > > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > > cfObjectManager2ecfc211571543$funcGETOBJECT.runFunction(/home/david/ > > > > opt/coldfusion/8/wwwroot/transfer/com/object/ObjectManager.cfc:63) at > > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > > cfProperty2ecfc2086165857$funcEVALUATEPROPERTYIDENTIFIER.runFunction(/ > > > > home/david/opt/coldfusion/8/wwwroot/transfer/com/tql/walkers/ > > > > Property.cfc:56) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java: > > > > 418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > > cfSelectColumn2ecfc650005570$funcEVALUATESELECTAST.runFunction(/home/ > > > > david/opt/coldfusion/8/wwwroot/transfer/com/tql/walkers/ > > > > SelectColumn.cfc:43) at > > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2471) at > > > > cfSelectColumn2ecfc650005570$funcEVALUATESELECTAST.runFunction(/home/ > > > > david/opt/coldfusion/8/wwwroot/transfer/com/tql/walkers/ > > > > SelectColumn.cfc:105) at > > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > cfSelectStatement2ecfc1551394529$funcEVALUATESELECTSTATEMENT.runFunction(/ > > > > home/david/opt/coldfusion/8/wwwroot/transfer/com/tql/ > > > > SelectStatement.cfc:154) at > > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2471) at > > > > cfSelectStatement2ecfc1551394529$funcSELECTSTATEMENT.runFunction(/home/ > > > > david/opt/coldfusion/8/wwwroot/transfer/com/tql/SelectStatement.cfc: > > > > 102) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at > > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222) at > > > > cfTQLManager2ecfc624316183$funcEVALUATEQUERY.runFunction(/home/david/ > > > > opt/coldfusion/8/wwwroot/transfer/com/tql/TQLManager.cfc:28) at > > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > > cfTransfer2ecfc1685525181$funcLISTBYQUERY.runFunction(/home/david/opt/ > > > > coldfusion/8/wwwroot/transfer/com/Transfer.cfc:562) at > > > > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > > > > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at > > > > coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java: > > > > 360) at coldfusion.runtime.UDFMethod > > > > $ArgumentCollectionFilter.invoke(UDFMethod.java:324) at > > > coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: > > > > 59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > > > > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at > > > > coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at > > > > coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at > > > > cfvariations2ecfc1380500055$funcEDITCUSTOM.runFunction(/home/david/opt/ > > > > coldfusion/8/wwwroot/admin/controllers/variations.cfc:173) at > > ... > > read more » -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 You received this message because you are subscribed to the Google Groups "transfer-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/transfer-dev?hl=en
