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
i2c 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/