Re: Help me, and guide me
Ali Umair <[email protected]>
| Newsgroups | gmane.comp.otrs.devel |
|---|---|
| Message-ID | <[email protected]> |
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 _______________________________________________ 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