
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.
see http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html
I hope that helps,
mike
On Mon, Jan 30, 2012 at 8:08 AM, 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 * *i**2**c* *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