Page MenuHomePhabricator

Emoji in command arguments crashes the bot
Closed, ResolvedPublic

Description

2021-02-01 01:40:43,420 [5] DEBUG Stwalkerster.IrcClient.IrcClient.Freenode.NetworkClient.Inbound [(null)] - :perry!~perry@wikipedia/perryprog PRIVMSG #wikipedia-en-helpers :!other💩exists

2021-02-01 01:40:43,421 [Thread Pool Worker] INFO  Stwalkerster.Bot.CommandLib.Services.CommandParser [(null)] - Creating command object of type Helpmebot.Brain.Commands.BrainRetrievalCommand

2021-02-01 01:40:43,437 [Thread Pool Worker] DEBUG Helpmebot.CoreServices.Services.AccessControl.AccessControlAuthorisationService [(null)] - Found flag groups Advanced,Normal (consisting of +aFcPSBISBI-) apply to perryprog [perry!~perry@wikipedia/perryprog]

2021-02-01 01:40:43,463 [Thread Pool Worker] DEBUG Helpmebot.Brain.Commands.BrainRetrievalCommand [(null)] - Found method: Execute

2021-02-01 01:40:43,482 [Thread Pool Worker] DEBUG Helpmebot.CoreServices.Services.AccessControl.AccessControlAuthorisationService [(null)] - Found flag groups Advanced,Normal (consisting of +aFcPSBISBI-) apply to perryprog [perry!~perry@wikipedia/perryprog]

2021-02-01 01:40:43,524 [6] DEBUG Stwalkerster.IrcClient.IrcClient.Freenode.NetworkClient.Outbound [(null)] - PING :GNU Terry Pratchett 1612143643524.59

2021-02-01 01:40:43,533 [5] DEBUG Stwalkerster.IrcClient.IrcClient.Freenode.NetworkClient.Inbound [(null)] - :orwell.freenode.net PONG orwell.freenode.net :GNU Terry Pratchett 1612143643524.59

2021-02-01 01:40:43,536 [Thread Pool Worker] DEBUG Helpmebot.CoreServices.Services.AccessControl.AccessControlAuthorisationService [(null)] - Found flag groups Advanced,Normal (consisting of +aFcPSBISBI-) apply to perryprog [perry!~perry@wikipedia/perryprog]

2021-02-01 01:40:43,589 [Thread Pool Worker] ERROR NHibernate.AdoNet.AbstractBatcher [(null)] - Could not execute command: INSERT INTO flagaccesslog (Timestamp, Class, Invocation, Nickname, Username, Hostname, Account, Context, AvailableFlags, requiredmain, requiredsub, Result) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11)
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value: '\xF0\x9F\x92\xA9ex...' for column 'invocation' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00026] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int64& insertedId) [0x00000] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00023] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00205] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00315] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <8051f3898298485d9e8510b51445dcd7>:0 
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () [0x00033] in <8051f3898298485d9e8510b51445dcd7>:0 
  at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery (System.Data.IDbCommand cmd) [0x00029] in <761c4b8735ac4799a664f1a013202a0c>:0

Revisions and Commits

Event Timeline

stwalkerster shifted this object from the Restricted Space space to the S1 Default space.Feb 1 2021, 2:17 AM
stwalkerster updated the task description. (Show Details)
stwalkerster edited projects, added Helpmebot; removed Restricted Project.
stwalkerster shifted this object from the S1 Default space to the Restricted Space space.Feb 1 2021, 9:32 AM
stwalkerster moved this task from Backlog to Bugs on the Helpmebot board.
stwalkerster closed this task as Resolved by committing Restricted Diffusion Commit.Feb 12 2021, 12:12 AM
stwalkerster added a commit: Restricted Diffusion Commit.
stwalkerster shifted this object from the Restricted Space space to the S1 Default space.Feb 12 2021, 12:13 AM
stwalkerster mentioned this in Unknown Object (Maniphest Task).Feb 16 2021, 12:46 AM
stwalkerster merged a task: Unknown Object (Maniphest Task).