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