[Mailman-Users] issues after conversion
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 > 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
--
Mailman-Users mailing list
Mailman-Users@python.org
http://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Unsubscribe:
http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
Security Policy:
http://www.python.org/cgi-bin/faqw-mm.py?req=show&file=faq01.027.htp
Re: [Mailman-Users] issues after conversion
At 11:25 AM -0700 2005-10-13, Sean Roe wrote:
> I am in the process of transfering over my lists to a new machine and
> converting them to mysql.
Please keep in mind that the MySQL Member Adapter is an
unsupported third-party patch.
> _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 > 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.
Well, I don't know SQL, but that error message seems pretty explicit.
Have you checked to make sure that the MySQL Member Adapter is
compatible with Exim 4, and the way you have Exim configured?
I think you're more likely to get useful assistance if you
contact the author of the MySQL Member Adapter directly, and/or post
to the Exim mailing lists, read the Exim FAQ and other documentation,
etc
--
Brad Knowles, <[EMAIL PROTECTED]>
"Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety."
-- Benjamin Franklin (1706-1790), reply of the Pennsylvania
Assembly to the Governor, November 11, 1755
SAGE member since 1995. See
