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 <aum...@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 * > *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
_______________________________________________ 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
