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.
Please consult your DBA to either upgrade your existing tables to InnoDB or
set the default table type to MyISAM.
See also: http://bugs.otrs.org/show_bug.cgi?id=8528
--
Mike
On Wed, Jun 20, 2012 at 4:17 PM, 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