30 Jan
2012
30 Jan
'12
7:08 a.m.
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