SQL errors

[art]

Hello All,

We are using Zabbix 1.1.6. Decided to upgrade MySQL database from 4.1 to 5.0.45. Did a mysqldump on 4.1 database and then restore dump with 5.0.45.

After upgrade discovered that zabbix reports some mysql errors.

During login:

SQL error: Duplicate entry '0' for key 1
Query: insert into auditlog (userid,clock,action,resourcetype,details) values (1,1193200862,3,0,'Correct login [admin]')

During enabling/disabling trigger:

SQL error: Duplicate entry '0' for key 1
Query: insert into alarms(triggerid,clock,value) values(14703,1193200769,2)


Any ideas how to fix it?

[Aly]

You have duplicate value in fields which are keys. I'm not sure about 1.1.6, but looks like you have problem with table ids.

As i sad, i'm not sure about 1.1.6, but try to delete everything from it. Should help.