Mysql 4.1 problems

[nveid]

I upgraded to mysql 4.1 cause after reviewing threads I heard that plesk was compatible with it. For the most part it seems to work fine at first glance. But, i get this error when i try to add a new email user on any domain.

ERROR Up LevelUp Level

Unable to query database: Duplicate entry '0' for key 1

--------------------------------------------------------------------------------

0: /opt/psa/admin/plib/class.ActionLog.php:516 psaerror(string "Unable to query database: Duplicate entry '0' for key 1")
1: /opt/psa/admin/plib/class.ActionLog.php:468 ActionLog->submitAction_()
2: /opt/psa/admin/plib/mail/MailName.php:1002 ActionLog->submit()
3: /opt/psa/admin/htdocs/domains/mail/mail_name_preferences.php:87 Mailname->update()

 

[nveid]

oooo. I got more, i just downgraded back to 4.0 (after doing the proper steps after dumping a compatible 4.0 database).. And I'm still getting the same problem

 

[eilko]

empty the plesk mysql table action log

 

[murali.r]

Please try reinstatlling the mysql 4 rpms from the atomicrocketturtle.com repository

 

[nveid]

I found my problem, it was from when i upgraded to mysql5 and downgraded back to mysql 4. Apparently mysqldump --all-databases --compatible=mysql40 doesn't dump auto_increment and some other things.

So I had to restore my mysql5 (i had a backup of teh databases in raw format from a tarball), did another mysqldump --all-databases, and manually converted the mysql5 database to mysql4.

-- RLB

 

[interversal]

Found a different fix

Just in case you don't want to stuff around with rps and installers, here's how I fixed going from 4.1 to 4.0,
Just a matter of a big search and replace
http://www.interversal.co.uk/2008/03/18/migrating-from-mysql-41-to-mysql-40-fixing-the-missing-auto_increment-field-error/

Cheers