Posted by crsd at 2006-07-05 13:48:47
I have problem with renaming ICQ contacts in roster to something with
apostrophes. After restarting pyICQt, it seems to start, but doesn't go online.
Backtrace from debug log (nick in question is -= [_-'//iZARD-_] =- , just to be
the same as in ICQ):
state=func(flap)
File "/usr/local/lib/jabber/pyicq/src/tlib/oscar.py", line
627, in oscar_Data
d.callback(snac)
File
"/usr/local/lib/python2.4/site-packages/twisted/internet/defer.py",
line 252, in callback
self._startRunCallbacks(result)
File
"/usr/local/lib/python2.4/site-packages/twisted/internet/defer.py",
line 313, in _startRunCallbacks
self._runCallbacks()
--- <exception caught here> ---
File
"/usr/local/lib/python2.4/site-packages/twisted/internet/defer.py",
line 338, in _runCallbacks
self.result = callback(self.result, *args, **kw)
File "/usr/local/lib/jabber/pyicq/src/legacy/icqt.py", line
359, in gotBuddyList
self.icqcon.legacyList.updateSSIContact(u.name, nick=u.nick)
File "/usr/local/lib/jabber/pyicq/src/legacy/legacylist.py",
line 202, in updateSSIContact
self.session.pytrans.xdb.setListEntry("roster",
self.session.jabberID, contact.lower(),
payload=self.xdbcontacts[contact.lower()])
File "/usr/local/lib/jabber/pyicq/src/xdb/mysql.py", line
156, in setListEntry
c.execute("INSERT INTO
list_attributes(owner,type,jid,attribute,value)
VALUES('%s','%s','%s','%s','%s')" % (jabberID, type, legacyID, p,
payload[p]
))
File
"/usr/local/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163,
in execute
self.errorhandler(self, exc, value)
File
"/usr/local/lib/python2.4/site-packages/MySQLdb/connections.py", line
35, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for th
e right syntax to use near '/iZARD-_] =-')' at line 1")
Posted by Z_God at 2006-11-04 21:45:51
This should be fixed with the security update, 0.7d (& higher).
Owner: ---