Hey,
That problem I have solved, in the mysql database script, in some of the
tables there are a "," to much removed them, and it would import the scheme
just fine....:-)
Now I want to migrate all my users, witht the new script where its possible
to move one user at a time, fine with me, I only got about 20 users. The
script runs just fine, takes the users ans aliases table, but then it fails
with the following error.
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 "./sql/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/p
ython2.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/p
ython2.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/p
ython2.2/site-packages/MySQLdb/connections.py", line 33, in
defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1136, "Column count doesn't match value
cou
nt at row 1")
I'm moving from PostGreSQL to MySQL...... Really hope there are someone who
can help me....
// ouT
>-----Oprindelig meddelelse-----
>Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>På vegne af Roel Rozendaal - IC&S
>Sendt: 31. januar 2004 11:35
>Til: [email protected]
>Emne: Re: [Dbmail] I'm trying the new 2.0 rc1, but have some
>problems....
>
>are you using mysql or postgresql?
>
>Op 30-jan-04 om 20:56 heeft Mikael Syska het volgende geschreven:
>
>> Hey,
>>
>> When I'm trying to import the new scheme for 2.0 its gives me the
>> following error...
>>
>> ERROR 1064 at line 35: You have an error in your SQL syntax near ')'
>> at line
>> 12
>>
>> And now I'm lost, aint no Database guru, so I hope there are someone
>> who can help me here....
>>
>> Thanks in advance....
>>
>> _______________________________________________
>> Dbmail mailing list
>> [email protected]
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>
>_________________________
>R.A. Rozendaal
>IC&S
>T: +31 30 63 55 736
>F: +31 30 63 55 731
>www.ic-s.nl
>
>_______________________________________________
>Dbmail mailing list
>[email protected]
>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
