no such column: jid_id in unread_messages
Hello to all of you, habiles Gajim developers!
An issue and a workaround of the svn:
Here is the Traceback (most recent call last): File "/home/beraudog/loisirs/linux/gajim/src/common/xmpp/idlequeue.py", line 133, in process_events File "/home/beraudog/usr/src/gajim/src/common/xmpp/transports_nb.py", line 143, in pollin self._do_receive() File "/home/beraudog/usr/src/gajim/src/common/xmpp/transports_nb.py", line 245, in _do_receive self.on_receive(received) File "/home/beraudog/usr/src/gajim/src/common/xmpp/dispatcher_nb.py", line 347, in dispatch handler'func' File "/home/beraudog/usr/src/gajim/src/common/connection_handlers.py", line 1584, in _getRosterCB self.connection.getRoster(self._on_roster_set) File "/home/beraudog/loisirs/linux/gajim/src/common/xmpp/roster_nb.py", line 56, in getRoster File "/home/beraudog/usr/src/gajim/src/common/connection_handlers.py", line 1617, in _on_roster_set self.dispatch('ROSTER', roster) File "/home/beraudog/usr/src/gajim/src/common/connection.py", line 98, in dispatch self.put_event((event, data)) File "/home/beraudog/usr/src/gajim/src/common/connection.py", line 94, in put_event gajim.handlersev[0] File "gajim.py", line 203, in handle_event_roster self.roster.fire_up_unread_messages_events(account) File "/home/beraudog/usr/src/gajim/src/roster_window.py", line 897, in fire_up_unread_messages_events results = gajim.logger.get_unread_msgs_for_jid(jid) File "/home/beraudog/usr/src/gajim/src/common/logger.py", line 238, in get_unread_msgs_for_jid self.cur.execute( pysqlite2.dbapi2.OperationalError: no such column: jid_id
Workaround; solution? on linux OS (maybe you need to install sqlite3 package) Launch "sqlite3 logs.db" in .gajim directory, type and press enter: ALTER TABLE unread_messages ADD jid_id INTEGER;
Then: .quit
I guess Gajim should be completly closed before processing. En route for Gajim 0.10!
Guillaume