Hey Ilja, Sounds good, sounds likes it comming this week, its that correct understood?? If will there be a announce of that cause its really urgent, I need to upgrade my system and I can't do that until I have moved the mails to the mysql database....
If its that migration script there is in the source right now, it does also fail on my system, so I sure hope you are talking about a new and better one :-P // All from here // ouT > -----Oprindelig meddelelse----- > Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > På vegne af Ilja Booij > Sendt: 2. februar 2004 11:17 > 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....... > > These single quotes should not be necessary for Python DB. > > I'll have another (better ;) ) look at migration scripts this week. > > Ilja > > Paul J Stevens wrote: > > > 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/l > >> ib/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/l > >> ib/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/l > >> ib/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 > >> > > > > -- > IC&S > Stadhouderslaan 57 > 3583 JD Utrecht > > PGP-key: > http://www.ic-s.nl/keys/ilja.txt > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
