QELBot

  • Status Assigned
  • Percent Complete
    0%
  • Task Type Bug Report
  • Category Bot
  • Assigned To
    Krayon
  • Operating System All
  • Severity High
  • Priority Low
  • Reported Version 0.10.0045
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: QELBot
Opened by Krayon - 2010-11-15

QB#93 - Bot crash during "inv"

First seen on 2010-11-14 23:28 EST (UTC - 5:00), from the error log:

File "/home/qelbot/adversary/bot.py", line 848, in process_pm
  price = get_selling_price(requestor, item_name)
File "/home/qelbot/adversary/bot.py", line 1773, in get_selling_price
  my_db.execute(sql,(v.guild, item))
File "/home/qelbot/adversary/database.py", line 44, in execute
  self.cursor.execute(sql, args)
File "/usr/lib/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
  self.errorhandler(self, exc, value)
File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '='")
Admin
Krayon commented on 2010-11-15 14:54

User talking to bot was in guild "Ozรบ!" (the "u" has a lil' accent).

Recreated "Discounts" table as UTF-8, bug appeared to go away.

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing