[Mailman-Developers] MysqlMemberships.py [was: Informal "MEP"process, anyone? [was: PHP Wrappers?]]

[Fil]

> If looked at this a bit more closely, and it turns out not to be quite
> that simple. The major issue is the way things currently exist in your
> MysqlMemberships.py, rev 19, 'connection' is a local variable in the
> MysqlMemberships class __init__ method. It is not visible to
> _prodServerConnection() at all.

Yes! Now I understand why I was getting the "ping() does not exist"; it was
applied on a non existent object :)

> I've made a few changes to MysqlMemberships.py, rev 19 which I _think_
> will make it work. I did a test of a highly stripped down version
> which worked, but this didn't come close to the real thing.

I'm running the patch as is, and there's trouble. Here is the error log:

Nov 20 21:04:49 2005 (5788) SHUNTING: 1132460671.983129+5ac04378494de5d308a14cc372ae564cdd20cb3e
Nov 20 21:04:49 2005 (5788) Uncaught runner exception: cursor closed
Nov 20 21:04:49 2005 (5788) Traceback (most recent call last):
  File "/var/local/mailman/Mailman/Queue/Runner.py", line 111, in _oneloop
    self._onefile(msg, msgdata)
  File "/var/local/mailman/Mailman/Queue/Runner.py", line 161, in _onefile
    lang = mlist.getMemberLanguage(sender)
  File "/var/local/mailman/Mailman/MysqlMemberships.py", line 361, in getMemberLanguage
    lang = self.select_on('lang',member)
  File "/var/local/mailman/Mailman/MysqlMemberships.py", line 268, in select_on
    "address='%s'" %(self.escape(address)))
  File "/var/local/mailman/Mailman/MysqlMemberships.py", line 250, in select
    return self.queryall(query + ' ORDER BY address', True)
  File "/var/local/mailman/Mailman/MysqlMemberships.py", line 230, in queryall
    self.query(query)
  File "/var/local/mailman/Mailman/MysqlMemberships.py", line 226, in query
    return self.cursor.execute (query)
  File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 137, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: cursor closed


-- Fil