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