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

On Wed, 30 Jun 2010 19:23:32 +0200, Ekram 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/