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

Hi Poul,

The alias is "mikael@xxxxxxxx"

Nope did not help to solve the problem.

I have now tried to get the newest version that includes the
"./migrate_singe_user.py" and it still fails..... 

I'm trying to migrate from PostGreSQL to MySQL version 3.23.57.

If there are more information need just ask.....

I want to get the database moved ASAP.


Here are output from the new single user migration script are a down:
LOADING DATABASE DRIVERS

loading MySQL driver
loading MySQL driver
connecting to databases
Name of user to copy data for?mikael@xxxxxxxx
finding user in database
1 =nieuwe user
copying aliases table
copied 5 records from aliases table
copying mailboxes, messages and messageblocks table
Traceback (most recent call last):
  File "./migrate_singe_user.py", line 141, in ?
    cursor_2.execute("""INSERT INTO mailboxes
  File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/cursors.py", line 95, in execute
    return self._execute(query, args)
  File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/cursors.py", line 114, in _execute
    self.errorhandler(self, exc, value)
  File
"/usr/ports/databases/py-mysql/w-py-mysql-0.9.2/fake-i386/usr/local/lib/pyth
on2.2/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1136, "Column count doesn't match value
count at row 1")
fw#



>-----Oprindelig meddelelse-----
>Fra: dbmail-admin@xxxxxxxxxx [mailto:dbmail-admin@xxxxxxxxxx] 
>På vegne af Paul J Stevens
>Sendt: 31. januar 2004 19:06
>Til: dbmail@xxxxxxxxxx
>Emne: Re: SV: [Dbmail] 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
>
>_______________________________________________
>Dbmail mailing list
>Dbmail@xxxxxxxxxx
>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>