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,
Amit Sharma