search

ProjectTako / kparser

Automatically exported from code.google.com/p/kparser
1 stars 3 forks source link

MessageText too long - error #80

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
With spellcast turned on and showequipswaps on, i get long messages to the 
chatlog, it appears that if the text is greater than the default for what its 
expecting, then data isnt just truncated, but it blows up.  Heres the error 
from the error.log:

Wednesday, April 27, 2011 12:39 AM
WaywardGamers.KParser.ParserCore, Version=1.5.12.0, Culture=neutral, 
PublicKeyToken=null
Error severity level: Error

System.ArgumentException
Message: 04,00,00,80a040a0,0000f29d,00012873,0122,00,01,01,00,ü[00:39:50] 
[SpellCast] Midcast - l.ear: Goetia Earring, l.ring: Snow Ring, main: Wind 
Staff, ammo: , body: Teal Saio, feet: Goetia Sabots +1, hands: Wzd. Gloves +1, 
head: , legs: Goet. Chausses +2, neck: Feud Pendant, r.ear: Moldavite Earring, 
r.ring: Diamond Ring, sub: Bugard Strap +1

System.ArgumentException: Cannot set column 'MessageText'. The value violates 
the MaxLength limit of this column.
   at System.Data.DataColumn.CheckMaxLength(DataRow dr)
   at System.Data.DataColumn.CheckColumnConstraint(DataRow row, DataRowAction action)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
   at System.Data.DataRowCollection.Add(DataRow row)
   at WaywardGamers.KParser.KPDatabaseDataSet.RecordLogDataTable.AddRecordLogRow(DateTime Timestamp, String MessageText, Boolean ParseSuccessful)
   at WaywardGamers.KParser.DatabaseManager.AddChatLineToRecordLog(ChatLine chatLine)
   at WaywardGamers.KParser.Parsing.MsgManager.ChatLinesListener(Object sender, ReaderDataEventArgs e)
Wednesday, April 27, 2011 12:39 AM
WaywardGamers.KParser.ParserCore, Version=1.5.12.0, Culture=neutral, 
PublicKeyToken=null

Original issue reported on code.google.com by pvo...@gmail.com on 27 Apr 2011 at 7:57

GoogleCodeExporter commented 8 years ago 
Hm. Interesting.  Well, since we can pretty much consider those invalid a 
priori, given that FFXI will never generate lines that long, I can truncate 
that value before sending it to the database.  You'll just lose the excess in 
the stored info.

Fixed in update r1704.

Original comment by Kinemati...@gmail.com on 6 May 2011 at 8:21

GoogleCodeExporter commented 8 years ago 
Perfect... that solution sounds fine.

Original comment by pvo...@gmail.com on 6 May 2011 at 8:43