Hello Ali,
I did a quick google for you,  error code 150 is from otrs. 

This problem was described here in this posting, it seems to be a problem with they syntax of the references command being changed between mysql versions.

http://lists.otrs.org/pipermail/otrs/2006-January/009885.html

also note:

error code 1005 is from mysql 

1005 (ER_CANT_CREATE_TABLE)Cannot create table. If the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. If the error message refers to error –1, table creation probably failed because the table includes a column name that matched the name of an internal InnoDB table.


I hope that helps, 

mike

On Mon, Jan 30, 2012 at 8:08 AM, Ali Umair <aumair@i2cinc.com> wrote:
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



--
James Michael DuPont
Custom Engineering/Research & Development 
 
OTRS AG
Norsk-Data-Straße 1
D-61352 Bad Homburg

T: +49 (0) 9421 56818 0
F: +49 (0) 9421 56818 18
I: http://www.otrs.com/

Geschäftssitz: Bad Homburg, Amtsgericht Bad Homburg, HRB 10751, USt-Nr.: DE256610065
Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn