History search bug with simple quotes.
Hi !
When searching for a single quote in a history window, an error occurs about a wrong paired '.
Seems pretty straightforward to fix :
Index: logger.py
===================================================================
--- logger.py (revision 8065)
+++ logger.py (working copy)
@@ -484,7 +484,7 @@
else: # user just typed something, we search in message column
where_sql = self._build_contact_where(account, jid)
- like_sql = '%' + query + '%'
+ like_sql = '%' + query.replace("'", "''") + '%'
self.cur.execute('''
SELECT contact_name, time, kind, show, message, subject FROM logs
WHERE (%s) AND message LIKE '%s'
Thanks for this neat software.
Michael.