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 <amit_...@yahoo.com> wrote: > 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 >
--------------------------------------------------------------------- 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
