Hi,

 

We are trying to upgrade OTRS 2.4.7 to 3.0.1 and getting the follwoing errors when we are running :

 

DBUpdate-to-3.0.mysql.sql

 

Command :-

ALTER TABLE ticket_flag ADD CONSTRAINT FK_ticket_flag_ticket_id_id FOREIGN KEY (ticket_id) REFERENCES ticket (id);

 

Error :-

Can't create table 'otrs.#sql-7108_7d' (errno: 150)

 

 

Command :-

ALTER TABLE ticket_flag ADD CONSTRAINT FK_ticket_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id);

 

Error :-

Can't create table 'otrs.#sql-7108_7c' (errno: 150)

 

 

Command :-

ALTER TABLE virtual_fs_preferences ADD CONSTRAINT FK_virtual_fs_preferences_virtual_fs_id_id FOREIGN KEY (virtual_fs_id) REFERENCES virtual_fs (id);

 

Error :-

Can't create table 'otrs.#sql-7108_7b' (errno: 150)

 

All the tables mentioned after ALTER TABLE  exists in OTRS DB.

 

Please Help!

Thanks and Regards,