HI stein, Thanks a lot for your reply. I've created the table and it seems ok now. In the screenshot i am getting the id now and also getting the other fields ok.
-Ekram On Thu, Jul 1, 2010 at 4:57 PM, Stein Erik Berget <[email protected]> wrote: > On Wed, 30 Jun 2010 19:23:32 +0200, Ekram <[email protected]> wrote: > > hi, >> >> I mail several times reagrading upgrade issue. I am facing a problem while >> upgrading from 2.04 version to 2.47. >> I followed every steps its upgraded nicely but there is a very big >> problem >> encountered. The image will tell the story. >> > > When upgrading, did you test the consistency of the system for each upgrade > you did? When going from 2.0 -> 2.1 did you check if this upgrade when OK? > > I got the following syslog while selecting any ticket. >> >> *J**Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> >> [Error][Kernel::System::Ticket::TicketAccountedTimeGet][Line:6414]: ERROR: >> relation "time_accounting" does not exist, SQL:* 'SELECT time_unit FROM >> time_accounting WHERE ticket_id = ?' >> > > The above looks like that there is a table missing from the database? I > guess that the others might be a 'follow up' error of this one. Or it might > be that there is some other missing data. From where do you get to the > screen you are seeing this error on? Is the link you click on correct? Does > that one contain a ticket ID? > > > > Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::User::GetUserData][Line:144]: Need User or UserID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::LockIsTicketLocked][Line:4864]: Need >> TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::LockIsTicketLocked][Line:4864]: Need >> TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::LockIsTicketLocked][Line:4864]: Need >> TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::LockIsTicketLocked][Line:4864]: Need >> TicketID! >> Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]: >> [Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID! >> >> Could you help me.Please let me know. >> >> -Ekram >> > > > -- > Stein Erik > > --------------------------------------------------------------------- > 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/
