SuSE 9 - problems upgrading MySQL 4.1 to 5.0
 

I upgraded the client package first and that was succesful then I tried upgrading the server package but ran into problems. This is what I got:

> rpm -Uvh MySQL-client-community-5.0.51a-0.sles9.i586.rpm
warning: MySQL-client-community-5.0.51a-0.sles9.i586.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-client-community ########################################### [100%]

> rpm -Uvh MySQL-server-community-5.0.51a-0.sles9.i586.rpm
warning: MySQL-server-community-5.0.51a-0.sles9.i586.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
Giving mysqld 5 seconds to exit nicely
1:MySQL-server-community ########################################### [100%]
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
ERROR: 1136 Column count doesn't match value count at row 1
080522 15:45:43 [ERROR] Aborting

080522 15:45:43 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!


appreciate the help.