Welcome to the FogBugz Knowledge Exchange

Question

2

We have the following error displaying in our Fogbugz:

7/8/2010 10:44 AM (GMT-05:00): The Fog Creek Maintenance Service has reported an error. (200) CCmd: Data too long for column 'sToken' at row 1
SQL:  INSERT    INTO SorterToken          (sToken,          nLatestDoc)  VALUES (?,          ?)
Params: SI
1: FROM:"¨k¤k¶Ê±¡/¤k©Ê¿³¾Ä¶Ê±¡/¤k¥Î¤fªA/¨k©
2: 24555


Wasabi.Runtime.WasabiException (0x80004005): Data too long for column 'sToken' at row 1
SQL:  INSERT    INTO SorterToken          (sToken,          nLatestDoc)  VALUES (?,          ?)
Params: SI
1: FROM:"¨k¤k¶Ê±¡/¤k©Ê¿³¾Ä¶Ê±¡/¤k¥Î¤fªA/¨k©
2: 24555
 ---> MySql.Data.MySqlClient.MySqlException: Data too long for column 'sToken' at row 1
  at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
  at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
  at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
  at Wasabi.Runtime.ADO.Command.ExecuteNonQuery() in c:\src\Wasabi\Wasabi.Runtime\ADO\Command.cs:line 94
  at FogCreek.FogBugz.CCmd.ExecuteNonQuery(Nullable`1 nCacheClearLevel) in c:\src\FogBugz\distribution\src-Website\CCmd.was:line 237
  at Wasabi.Runtime.Error.Raise(Int32 number, String source, String description, String helpfile, Nullable`1 helpcontext) in c:\src\Wasabi\Wasabi.Runtime\Error.cs:line 88
  at FogCreek.FogBugz.CCmd.ExecuteNonQuery(Nullable`1 nCacheClearLevel) in c:\src\FogBugz\distribution\src-Website\CCmd.was:line 247
  at FogCreek.FogBugz.CToken.Insert(String sTokenInit, Int32 nLatestDocInit) in c:\src\FogBugz\distribution\src-Website\CToken.was:line 215
  at FogCreek.FogBugz.CBayesianLearner.LearnTokens(CTokenBag tokenBag, Int32 ixAreaDestinationInit, Int32 ixAreaSourceInit, Boolean bUndoPreviousInit, Boolean bBinaryClassificationInit) in c:\src\FogBugz\distribution\src-Website\CBayesianLearner.was:line 251
  at FogCreek.FogBugz.CBug.Train(Int32 ixAreaFrom, Int32 ixAreaTo) in c:\src\FogBugz\distribution\src-Website\CBug.was:line 3131
  at FogCreek.FogBugz.CTrainingRequest.PerformRequest() in c:\src\FogBugz\distribution\src-Website\CTrainingRequest.was:line 276
  at FogCreek.FogBugz.__Global.SingleHeartbeatFogBugz(Int32 cMaxBayesianRequests, Int32 cMaxMailMessages, Int32 nEmailTimeout) in c:\src\FogBugz\distribution\src-Website\singleHeartbeat.was:line 93
  at FogCreek.FogBugz.__Global.SingleHeartbeatPlatform(Int32 cMaxBayesianRequests, Int32 cMaxMailMessages, Int32 nEmailTimeout) in c:\src\FogBugz\distribution\src-Website\singleHeartbeat.was:line 45
  at FogCreek.FogBugz.__Global.StartHeartbeat() in c:\src\FogBugz\distribution\src-Website\heartbeat.was:line 70

Can you please assist?

edited Sep 24 2010 at 21:10

adambox♦♦
20.9k●14●46

asked Jul 8 2010 at 16:09

Becky Goodman
21●1

	Hi Becky, can you e-mail this error to customer-service@fogcreek.com? – Rob Sobers Jul 10 2010 at 15:48
	Yes, done and solved. Thank you. – Becky Goodman Jul 16 2010 at 19:48

adambox · Answer 1 · 2010-07-27 21:13:32Z UTC

For posterity, the problem Rich uncovered was that some spam email you have in your box is using Unicode, which is being encoded so we can stick it in your FogBugz database, and that is making it outstrip the field length.

The fix was to modify the sorter token table to allow longer token values

ALTER TABLE SorterToken MODIFY COLUMN sToken varchar(240);

and to empty the TrainingRequest table.

Data too long for column ‘sToken’ at row 1

1 Answer