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
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
Hi Ali, this happens if you have a mix of tables in different storage engines. Maybe you have some older MyISAM tables, and now the default setting of MySQL is InnoDB, so that new tables are created in InnoDB? Foreign keys do not work between different engines. You should make sure all tables use the same engine. Best regards, mg Am 30.01.12 08:08, schrieb 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
-- Martin Gruner Senior Developer R&D OTRS AG Europaring 4 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I: www.otrs.com/ Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065 Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn Schalten Sie hoch! Der Turbo für Ihr OTRS - Exklusive Feature Add-Ons: http://www.otrs.com/de/solutions/subscriptions/feature-add-ons/
Hi Martin, thanks for your reply, i am trying to update OTRS 2.2.7 to 3.0.11. i run first script of update 2.3.sql and i am facing this issue of storage engine, but with the guidance of you. This script is run and i made same engine, but i want to preserve data of OTRS 2.2.7. now i think i run "dbupdate to 2.3.pl". but i am confusing about that which place i run this script of ".pl". please reply me soon and also guide following some question: 1 - how i preserve old data ? 2 - where i run .pl script (In linux which path/directory go and run this perl script?) 3 - Also guide me issue face i further. I am using My sql Workbench and perl which built in xampp. Again Thanks alot. Martin Gruner wrote:
Hi Ali,
this happens if you have a mix of tables in different storage engines. Maybe you have some older MyISAM tables, and now the default setting of MySQL is InnoDB, so that new tables are created in InnoDB? Foreign keys do not work between different engines. You should make sure all tables use the same engine.
Best regards, mg
Am 30.01.12 08:08, schrieb 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
-- Martin Gruner Senior Developer R&D
OTRS AG Europaring 4 94315 Straubing
T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I:www.otrs.com/
Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065 Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn
Schalten Sie hoch! Der Turbo für Ihr OTRS - Exklusive Feature Add-Ons:http://www.otrs.com/de/solutions/subscriptions/feature-add-ons/
_______________________________________________ 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
participants (3)
-
Ali Umair -
James Michael DuPont -
Martin Gruner