Where can I put the dbmail 2.0rc1 debian packages?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens
Sent: Sunday, February 01, 2004 7:55 PM
To: [email protected]
Subject: Re: SV: SV: [Dbmail] Easiest way to transfer mails from postgresql 1.x
to mysql 2.x or 1.x does not matter.......
Again,
try putting single-quotes around all the %s.
Mikael Syska wrote:
> Hi Poul,
>
> The alias is "[EMAIL PROTECTED]"
>
> 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 [EMAIL PROTECTED]
> 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/li
> b/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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>>På vegne af Paul J Stevens
>>Sendt: 31. januar 2004 19:06
>>Til: [email protected]
>>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: [EMAIL PROTECTED] or ICQ: 37679058...
>>>
>>>Or just reply to the list.....
>>>
>>>
>>>
>>>
>>>>-----Oprindelig meddelelse-----
>>>>Fra: [EMAIL PROTECTED]
>>
>>[mailto:[EMAIL PROTECTED] På vegne
>>
>>>>af Mikael Syska
>>>>Sendt: 29. januar 2004 17:57
>>>>Til: [email protected]
>>>>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
>>>>[email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>>
>>>>
>>>>
>>>
>>>_______________________________________________
>>>Dbmail mailing list
>>>[email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>
>>>
>>>
>>
>>-- ________________________________________________________________
>> Paul Stevens mailto:[EMAIL PROTECTED]
>> NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
>> The Netherlands________________________________http://www.nfg.nl
>>
>>_______________________________________________
>>Dbmail mailing list
>>[email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>
>
> _______________________________________________
> Dbmail mailing list
> [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
[email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
