My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 37: pyICQt 0.7b unable to handle nicks with apostrophes
  Back to list
Status:  WontFix
Owner:  ----
Closed:  Dec 2008


 
Reported by jadest...@gmail.com, Dec 9, 2007
 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).


Dec 12, 2008
Project Member #1 r000ns...@gmail.com
(No comment was entered for this change.)
Status: WontFix
Owner: ---

Powered by Google Project Hosting