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