Server Error in '/' Application.

Data truncated for column 'PARAMPREMDATEITEMID' at row 1

Description: Failed to GetCatalogueItem

Exception Details: MySql.Data.MySqlClient.MySqlException: Data truncated for column 'PARAMPREMDATEITEMID' at row 1

Source Error:


Line 19:     'Response.Write((InStr(Request.UrlReferrer.AbsoluteUri, "old.ableandgame.com/admin/stocklist/premadeitems.asp", CompareMethod.Text) > 0))
Line 20:     ItemID = Request.QueryString("i")
Line 21:     Dim CI As PageCatalogue.CatalogueItem = PageCatalogue.GetCatalogueItem(ItemID)
Line 22:     CI.AppendToControl(spanContent, AdminMode)
Line 23:   End Sub

Source File: E:\web\ableand1\wholesale\ViewItem.aspx.vb    Line: 21

Stack Trace:


[MySqlException (0x80004005): Data truncated for column 'PARAMPREMDATEITEMID' at row 1]
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +309
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +67
   MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) +17
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +110
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +846
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1667
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +138
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +158
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107
   AbleAndGame.Connection.StoredProcedure(StoredProcedureType proc, CommandParameterList paramList, Boolean CleanDB) +540
   AbleAndGame.Connection.GetCataloguePremadeItem(String pPremadeItemID) +109
   AbleAndGame.PageCatalogue.GetItem(String pPremadeItemID) +42
   AbleAndGame.PageCatalogue.GetCatalogueItem(String pPremadeItemID) +116

[Exception: Failed to GetCatalogueItem]
   AbleAndGame.PageCatalogue.GetCatalogueItem(String pPremadeItemID) +1772
   Wholesale_ViewItem.Wholesale_ViewItem_Load(Object sender, EventArgs e) in E:\web\ableand1\wholesale\ViewItem.aspx.vb:21
   System.Web.UI.Control.OnLoad(EventArgs e) +79
   System.Web.UI.Control.LoadRecursive() +130
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2853


INNER EXCEPTION
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'PARAMPREMDATEITEMID' at row 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at AbleAndGame.Connection.StoredProcedure(StoredProcedureType proc, CommandParameterList paramList, Boolean CleanDB) at AbleAndGame.Connection.GetCataloguePremadeItem(String pPremadeItemID) at AbleAndGame.PageCatalogue.GetItem(String pPremadeItemID) at AbleAndGame.PageCatalogue.GetCatalogueItem(String pPremadeItemID)
Referrer http://ableandgame.com.au/wholesale/viewitem.aspx?i=1454
AbsolutePath /wholesale/viewitem.aspx
RawUrl /wholesale/viewitem.aspx?i=1454&i=1454
All HTTP: HTTP_CONNECTION:close HTTP_ACCEPT:*/* HTTP_ACCEPT_ENCODING:gzip, br HTTP_COOKIE:ASP.NET_SessionId=2v1oftakc4gnbijuls35rb4r HTTP_HOST:www.ableandgame.com HTTP_REFERER:http://ableandgame.com.au/wholesale/viewitem.aspx?i=1454 HTTP_USER_AGENT:Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) HTTP_CDN_LOOP:cloudflare HTTP_CF_IPCOUNTRY:US HTTP_X_FORWARDED_FOR:52.15.160.43 HTTP_CF_RAY:885969324a178102-ORD HTTP_X_FORWARDED_PROTO:https HTTP_CF_VISITOR:{"scheme":"https"} HTTP_CF_CONNECTING_IP:52.15.160.43
All HTTP: HTTP_CONNECTION:close HTTP_ACCEPT:*/* HTTP_ACCEPT_ENCODING:gzip, br HTTP_COOKIE:ASP.NET_SessionId=2v1oftakc4gnbijuls35rb4r HTTP_HOST:www.ableandgame.com HTTP_REFERER:http://ableandgame.com.au/wholesale/viewitem.aspx?i=1454 HTTP_USER_AGENT:Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) HTTP_CDN_LOOP:cloudflare HTTP_CF_IPCOUNTRY:US HTTP_X_FORWARDED_FOR:52.15.160.43 HTTP_CF_RAY:885969324a178102-ORD HTTP_X_FORWARDED_PROTO:https HTTP_CF_VISITOR:{"scheme":"https"} HTTP_CF_CONNECTING_IP:52.15.160.43