[otrs] Errors while upgrading OTRS from 2.4.7 to 3.0.1

[Amit Sharma]

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

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs