[Mailman-Users] issues after conversion

[Sean Roe]

Hi All,

I am in the process of transfering over my lists to a new machine and 
converting them to mysql.  I have got the lists created, copied the old 
lists directory over and started to create the aliases for exim4.  But 
whenever I run genaliases, I Iget the following output:

#./bin/genaliases
Traceback (most recent call last):
  File "./bin/genaliases", line 116, in ?
    main()
  File "./bin/genaliases", line 94, in main
    mlist = MailList.MailList(listname, lock=False)
  File "/var/lib/mailman/Mailman/MailList.py", line 105, in __init__
    self._memberadaptor = MysqlMemberships(self)
  File "/var/lib/mailman/Mailman/MysqlMemberships.py", line 118, in __init__
    self.cursor.execute ("""CREATE TABLE IF NOT EXISTS %s (
  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
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your 
SQL syntax; check the manual that corresponds to your MySQL server 
version for the right syntax to use near '-child (\n  address 
varchar(255) NOT NULL,\n  hide enum('Y','N') N")
Exception exceptions.AttributeError: "MysqlMemberships instance has no 
attribute 'conn'" in <bound method MysqlMemberships.__del__ of 
<Mailman.MysqlMemberships.MysqlMemberships instance at 0x406250ec>> ignored

I checked the tables on the mysql server and they all appear to be 
there, so I am confused.  Any guidance would be helpful.

Thanks,
Sean