Quantcast

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

big bug

x-Ratchet-xx-Ratchet-x Member Posts: 1

This happened while trying to upload an avatar that met the criteria.

 

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

 

The error occurred in D:mmorpg_newsettings.cfm: line 454

Called from D:mmorpg_newsettings.cfm: line 1

Called from D:mmorpg_newsettings.cfm: line 454

Called from D:mmorpg_newsettings.cfm: line 1



452 :                 set nocount on

453 :                 INSERT INTO ForumAvatars(UserID, Filename, Width, Height, Description)

454 :                 VALUES(#request.session.userID#, '#CFFILE.ServerFile#',#width#,#height#,'#newname#')

@Identity AS newID

456 :             </CFQUERY>



SQLSTATE       22001

@Identity AS newID

VENDORERRORCODE       8152

DATASOURCE       mmorpg

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.8.1.12) Gecko/20080201 Firefox/2.0.0.12

Remote Address       Changed this for my own safety

Referrer       http://www.mmorpg.com/settings.cfm

Date/Time       26-Mar-08 01:36 AM

Stack Trace

at cfsettings2ecfm331258452._factor30(D:mmorpg_newsettings.cfm:454) at cfsettings2ecfm331258452.runPage(D:mmorpg_newsettings.cfm:1) at cfsettings2ecfm331258452._factor30(D:mmorpg_newsettings.cfm:454) at cfsettings2ecfm331258452.runPage(D:mmorpg_newsettings.cfm:1)



java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

    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.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.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:348)

    at coldfusion.sql.Executive.executeQuery(Executive.java:1210)

    at coldfusion.sql.Executive.executeQuery(Executive.java:1008)

    at coldfusion.sql.Executive.executeQuery(Executive.java:939)

    at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)

    at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)

    at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)

    at cfsettings2ecfm331258452._factor30(D:mmorpg_newsettings.cfm:454)

    at cfsettings2ecfm331258452.runPage(D:mmorpg_newsettings.cfm:1)

    at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)

    at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)

    at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)

    at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)

    at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)

    at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)

    at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)

    at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)

    at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)

    at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)

    at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)

    at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)

    at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)

    at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126)

    at coldfusion.CfmServlet.service(CfmServlet.java:175)

    at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)

    at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)

    at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)

    at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

    at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)

    at jrun.servlet.FilterChain.service(FilterChain.java:101)

    at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)

    at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)

    at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284)

    at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)

    at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)

    at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)

    at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)

    at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)

    at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Sign In or Register to comment.