- Status Assigned
- Percent Complete
- 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
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 '='")
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.