1.6.2 -> 1.8 DB Upgrade , Missing Column.

[smallclanger]

Hi all,

I'm upgrading from 1.6.2 to 1.8 and when running the upgrade script, I get the following:

Converting database to UTF-8
Patching the database
ERROR 1072 (42000) at line 46: Key column 'status' doesn't exist in table
Failed to patch Zabbix database. Restore from backup

Line 46 is:

CREATE INDEX escalations_2 on escalations (status,nextcheck);

but running 'desc escalations' on the DB (after the upgrade stops there), produces:

mysql> desc escalations;
+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| escalationid | int(4)      | NO   | PRI | NULL    | auto_increment |
| name         | varchar(64) | NO   | UNI | 0       |                |
| dflt         | int(2)      | NO   |     | 0       |                |
+--------------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

No status column... Any idea what I can do to fix this? (is it safe to comment this index line out until later?)

(Edit: Restored a backup and commented that line out anyway. Patch seemed to apply smoothly and I can't see any problems. Will I need to add this index later?)

Cheers,

Terry.