|
Hi folks, I found this post on Saturday when I first posted my issue
to the dev list. http://www.houseoffusion.com/cf_lists/messages.cfm/Threadid=41008&forumid=4𳡐 I emailed directly with Seth to see if he had solved his
issue and we are both stumped. In an effort to make sure that we weren’t
just looking at something weird on the 2.3.2 release, we agreed to test the
Glamour Beta to see if the issue was non-existent in the new beta.
Unfortunately, it’s still in there. Hopefully this post will help gain
some insight into this issue. I’m happy to help out trying to resolve
this issue, but would appreciate some hints on where to look to see if I need
to rewrite code. Datasource: <snip> Detail: Data truncation: Data truncated; our of ranger for
column ‘userID’ at row 1 Error Code: 01004 Message: Error Executing Database Query NativeErrorCode: 0 Sql: Insert into DmUserToGroup (userId,groupId) values
(4294967297,6) Stack Trace: coldfusion.tagext.sql.QueryTag$DatabaseQueryException:
Error Executing Database Query. at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:578) at cfcfFunctionWrappers2ecfm1632533092$funcQUERY.runFunction(D:\inetpub\applications\farcry_core\admin\includes\cfFunctionWrappers.cfm:36)
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.CfJspPage._invokeUDF(CfJspPage.java:1765) at
cfauthentication2ecfc1592385958$funcADDUSERTOGROUP.runFunction(D:\inetpub\applications\farcry_core\packages\security\authentication.cfc:50)
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.TemplateProxy.invoke(TemplateProxy.java:196) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:156) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1587) at
cf_installFarcry2ecfm2081433499._factor0(D:\inetpub\applications\farcry_core\admin\install\_installFarcry.cfm:197)
at
cf_installFarcry2ecfm2081433499.runPage(D:\inetpub\applications\farcry_core\admin\install\_installFarcry.cfm:178)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343) at
coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1908) at
cfindex2ecfm80975038.runPage(D:\inetpub\applications\farcry_core\admin\install\index.cfm:176)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343) 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:50) 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.CfmServlet.service(CfmServlet.java:105) 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:527) at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:349)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Type: database QueryError: Data truncation: Data truncated; out of range for column ‘UserId’
at column 1 Where [empty string] What’s interesting is that when I try to run that query from
within my MySQL installation, the database returns the error: [ConMail DB Server] ERROR 1062: Duplicate entry
'2147483647-6' for key 1 That appears to be some type if ID with the GroupID appended
to it, but it doesn’t correspond to the UserId in dmuser table. You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ |
