Upgrade 1.6 to 1.8 patch problem

[antani]

Zabbix 1.6.1
Hello, i'm having problems applying the patch to mysql:
mysql zabbix < patch.sql
ERROR 1050 (42S01) at line 2: Table 'auditlog_details' already exists

I've dropped the table and reapplyied the patch:
ERROR 1050 (42S01) at line 14: Table 'autoreg_host' already exists

then:
ERROR 1050 (42S01) at line 35: Table 'expressions' already exists
ERROR 1050 (42S01) at line 11: Table 'globalmacro' already exists
ERROR 1050 (42S01) at line 21: Table 'graph_theme' already exists

[emilode]

I have the same problem here. At first run I get "Duplicate key name 'actions_1'. Dropping the table and rerunning the patch gives 'auditlog_details already exists' and I can't drop that table, mysql gives an error 1091 (check that column/key exists).

Running FreeBSD, mysql 5.0.51a.

[antani]

I can't drop that table, mysql gives an error 1091 (check that column/key exists).

Try this:
- backup db
- stop mysql
- remove table from disk /var/lib/mysql/zabbix/
- restart mysql