Re: SV: Easiest way to transfer mails from postgresql 1.x to mysql 2.x or 1.x does not matter.......

What are the exact aliases that make the script barf?

Try:  

cursor_2.execute("""INSERT INTO auto_notifications
                       (auto_notify_idnr, user_idnr, notify_address)
                       VALUES ('%s', '%s', '%s')""", record)

instead around line 113. Notice the single quotes around the values.

Sorry for not making this a proper diff.  The missing quotes are a generic
problem I notice in this code.  I'm guessing there may be some weird chars
in your aliases that drive python's string interpolation into recursive 
mania.

Also, aside from messages and messageblks you should be able to dump and
load the 1.2 tables straight into the 2.0 db.





Mikael Syska wrote:

> Plese there must be someone how can help me with the errors...
> If, then plese contact me on MSN: mikael@xxxxxxxx or ICQ: 37679058...
>
> Or just reply to the list..... 
>
>  
>
> > -----Oprindelig meddelelse-----
> > Fra: dbmail-admin@xxxxxxxxxx [mailto:dbmail-admin@xxxxxxxxxx] 
> > På vegne af Mikael Syska
> > Sendt: 29. januar 2004 17:57
> > Til: dbmail@xxxxxxxxxx
> > Emne: [Dbmail] Easiest way to transfer mails from postgresql 
> > 1.x to mysql 2.x or 1.x does not matter.......
> >
> > All in the subject, nothing more to say, I have tried the 
> > script in the dbmail 2.0 from 1 to 2, but I can't get it to work.....
> >
> > Here are the output from the script....
> > ------------------------------------------------------
> > LOADING DATABASE DRIVERS
> >
> > loading MySQL driver
> > loading PostgreSQL driver
> > connecting to databases
> > copying aliases table
> > Traceback (most recent call last):
> > File "./migration_1_x_to_2_0alpha.py", line 97, in ?
> >   cursor_2.execute("""INSERT INTO aliases (alias_idnr, alias,
> > File 
> > "/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py", 
> > line 95, in execute
> >   return self._execute(query, args)
> > File 
> > "/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py", 
> > line 114, in _execute
> >   self.errorhandler(self, exc, value)
> > File 
> > "/usr/local/lib/python2.3/site-packages/MySQLdb/connections.py"
> > , line 33, in defaulterrorhandler
> >   raise errorclass, errorvalue
> > RuntimeError: maximum recursion depth exceeded
> > ------------------------------------------------------
> >
> > I'm really desperate, any help would be great....
> >
> > Is there are IRC channel for dbmail?? If where????
> >
> > // ouT
> >
> > _______________________________________________
> > Dbmail mailing list
> > Dbmail@xxxxxxxxxx
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >    
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@xxxxxxxxxx
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>  

--
 ________________________________________________________________
 Paul Stevens                                  mailto:paul@xxxxxx
 NET FACILITIES GROUP                     PGP: finger paul@xxxxxx
 The Netherlands________________________________http://www.nfg.nl