Re: [otrs] Errors while upgrading OTRS from 2.4.7 to 3.0.1

2012-06-21 Thread Michiel Beijen
Hi, You did not only update OTRS, but you probably upgraded MySQL from 5.0 or 5.1 to 5.5 as well. What this does, is usually change the default table type to InnoDB. It now tries to add references between tables using the legacy MyISAM and the newer InnoDB types; this will generate this error.

[otrs] Errors while upgrading OTRS from 2.4.7 to 3.0.1

2012-06-20 Thread 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