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.
Plea
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.#sq