Hey,
If i do that, I get the following error and its stops...
-----------------------------------------------
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/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.ProgrammingError: (1064, "You have an error in your SQL
syntax near 'INBOX/BSD/root/crontab'', ''1'', ''1'', ''1'', ''1'',\n
''' at line 6")
-----------------------------------------------
It takes the User and his Aliases just fine and drops into the mysql
database.....
Any one have the same problem.....
>-----Oprindelig meddelelse-----
>Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>På vegne af Paul J Stevens
>Sendt: 1. februar 2004 09:55
>Til: dbmail@dbmail.org
>Emne: 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/li
>> b/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/li
>> b/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: dbmail@dbmail.org
>>>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: dbmail@dbmail.org
>>>>>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@dbmail.org
>>>>>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>>>
>>>>>
>>>>>
>>>>
>>>>_______________________________________________
>>>>Dbmail mailing list
>>>>Dbmail@dbmail.org
>>>>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
>>>Dbmail@dbmail.org
>>>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>
>>
>>
>> _______________________________________________
>> Dbmail mailing list
>> Dbmail@dbmail.org
>> 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
>Dbmail@dbmail.org
>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
