Hi Ali, this happens if you have a mix of tables in different storage engines. Maybe you have some older MyISAM tables, and now the default setting of MySQL is InnoDB, so that new tables are created in InnoDB? Foreign keys do not work between different engines. You should make sure all tables use the same engine.
Best regards, mg Am 30.01.12 08:08, schrieb Ali Umair: > i want to update my OTRS, 2.2 to 3.0, but when i run script of 2.3 > then in alter statements i found this error > > 0 66 12:04:13 ALTER TABLE queue_preferences ADD CONSTRAINT > FK_queue_preferences_queue_id_id FOREIGN KEY (queue_id) REFERENCES > queue (id) Error Code: 1005 > Can't create table 'otrs.#sql-223f_49' (errno: 150) 0.031 sec > > > i am working on mysql workbench and i install otrs on red hat linux, > please guide me as soon as possible. > > Thanks > -- > > -- > > *Best Regards* > > *Ali Umair | Software Engineer * > *i**2**c**Pakistan*| 04-Old FCC, Ferozepur Road, Lahore, PAKISTAN > Ph: 0092-42-111 000 911 X 171 | Cell: +92-334-4556898 > > > > > _______________________________________________ > OTRS mailing list: dev - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/dev > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev -- Martin Gruner Senior Developer R&D OTRS AG Europaring 4 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I: www.otrs.com/ Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065 Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn Schalten Sie hoch! Der Turbo für Ihr OTRS - Exklusive Feature Add-Ons: http://www.otrs.com/de/solutions/subscriptions/feature-add-ons/
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
