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 <[email protected]> wrote: > 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/ > --------------------------------------------------------------------- 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/
