Problems upgrading from OTRS 2.3.4 to 2.4.6

Hi, I'm trying to upgrade as per the subject line, but I'm running into several difficulties. I have OTRS 2.3.4 (with ITSM 1.2.3) installed from a tarball on one machine and I'm trying to install the new 2.4.6 version on a new server (with ITSM 1.3.2). I followed the instructions in UPGRADE and it all seems fine, but the problems start as soon as I import the old database from 2.3.4. I ran the two database migration scripts supplied with OTRS 2.4.6 (DBUpdate-to-2.4.pl and DBUpdate-to-2.4-post.mysql.sql), but when I log in to OTRS, I have the following problems: 1) Tickets don't display correctly - the dashboard shows some tickets, but when I click on any of them, the main body of the ticket is missing (just a blank white space). IN any of the list views (Locked Tickets, My Tickets etc), there seems to be an empty list of tickets, i.e. I get multiple "bulk" checkboxes on the page but every other column in the list is blank. 2) I now have several invalid packages that cannot be upgraded or reinstalled (General Catalog, ITSM Core and it's sub packages). If I try to reinstall them, I get a warning about the framework being out of date. If I try and install the latest General Catalog, it throws a SQL error complaining about a missing field in a table. Can anyone help? Regards, Richard Cross.

Hi Richard,
This really sounds like you missed one of the database update scripts.
BTW the order you're supposed to run them is:
* DBUpdate-to-2.4.mysql.sql
* DBUpdate-to-2.4.pl
* DBUpdate-to-2.4-post.mysql.sql
You only mention two out of three scripts.
If you could paste the exact error message about the missing field
(what field is missing?) you can probably also determine what script
you've missed....
Please restore your database from a backup and run the conversion again!
Kindest regards,
--
Michiel Beijen
R&D
Follow me on Twitter: @otrsnl [https://twitter.com/otrsnl]
OTRS AG
Norsk-Data-Str 1.
61352 Bad Homburg
Germany
T: +31 (0) 6457 42418
F: +49 (0) 9421 56818-18
I: http://www.otrs.com/
Business location: Bad Homburg, Country Court: Bad Homburg, HRB 10751,
VAT ID: DE256610065
Chairman: Burchard Steinbild, Managing Board: André Mindermann
CU@ CeBIT 2010 in Hannover (Germany) and get to know more about OTRS
at booth no. C37, in hall 2 from March 2-6, 2010! http://bit.ly/4qLvqm
On Mon, Jan 25, 2010 at 2:42 PM, Richard Cross
Hi,
I'm trying to upgrade as per the subject line, but I'm running into several difficulties. I have OTRS 2.3.4 (with ITSM 1.2.3) installed from a tarball on one machine and I'm trying to install the new 2.4.6 version on a new server (with ITSM 1.3.2).
I followed the instructions in UPGRADE and it all seems fine, but the problems start as soon as I import the old database from 2.3.4. I ran the two database migration scripts supplied with OTRS 2.4.6 (DBUpdate-to-2.4.pl and DBUpdate-to-2.4-post.mysql.sql), but when I log in to OTRS, I have the following problems:
1) Tickets don't display correctly - the dashboard shows some tickets, but when I click on any of them, the main body of the ticket is missing (just a blank white space). IN any of the list views (Locked Tickets, My Tickets etc), there seems to be an empty list of tickets, i.e. I get multiple "bulk" checkboxes on the page but every other column in the list is blank.
2) I now have several invalid packages that cannot be upgraded or reinstalled (General Catalog, ITSM Core and it's sub packages). If I try to reinstall them, I get a warning about the framework being out of date. If I try and install the latest General Catalog, it throws a SQL error complaining about a missing field in a table.
Can anyone help?
Regards,
Richard Cross.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
participants (2)
-
Michiel Beijen
-
Richard Cross