HI stein,<div><br></div><div>Thanks a lot for your reply. I&#39;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. </div><div><br></div><div>-Ekram</div>
<div><br><div class="gmail_quote">On Thu, Jul 1, 2010 at 4:57 PM, Stein Erik Berget <span dir="ltr">&lt;<a href="mailto:otrs@berget.org">otrs@berget.org</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Wed, 30 Jun 2010 19:23:32 +0200, Ekram &lt;<a href="mailto:chutygolpo@gmail.com" target="_blank">chutygolpo@gmail.com</a>&gt; wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
hi,<br>
<br>
I mail several times reagrading upgrade issue. I am facing a problem while<br>
upgrading from 2.04 version to 2.47.<br>
I followed every steps  its upgraded nicely but there is a very big problem<br>
encountered. The image will tell the story.<br>
</blockquote>
<br></div>
When upgrading, did you test the consistency of the system for each upgrade you did? When going from 2.0 -&gt; 2.1 did you check if this upgrade when OK?<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
I got the following syslog while selecting any ticket.<br>
<br></div>
*J**Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<div class="im"><br>
[Error][Kernel::System::Ticket::TicketAccountedTimeGet][Line:6414]: ERROR:<br>
relation &quot;time_accounting&quot; does not exist, SQL:* &#39;SELECT time_unit FROM<br>
time_accounting WHERE ticket_id = ?&#39;<br>
</div></blockquote>
<br>
The above looks like that there is a table missing from the database? I guess that the others might be a &#39;follow up&#39; 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?<div>
<div></div><div class="h5"><br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::User::GetUserData][Line:144]: Need User or UserID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::LockIsTicketLocked][Line:4864]: Need<br>
TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::LockIsTicketLocked][Line:4864]: Need<br>
TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::LockIsTicketLocked][Line:4864]: Need<br>
TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::LockIsTicketLocked][Line:4864]: Need<br>
TicketID!<br>
Jun 30 19:04:14 newotrs-oslo OTRS-CGI-1[1429]:<br>
[Error][Kernel::System::Ticket::Permission][Line:3001]: Need TicketID!<br>
<br>
Could you help me.Please let me know.<br>
<br>
-Ekram<br>
</blockquote>
<br>
<br></div></div>
-- <br><font color="#888888">
Stein Erik</font><div><div></div><div class="h5"><br>
---------------------------------------------------------------------<br>
OTRS mailing list: otrs - Webpage: <a href="http://otrs.org/" target="_blank">http://otrs.org/</a><br>
Archive: <a href="http://lists.otrs.org/pipermail/otrs" target="_blank">http://lists.otrs.org/pipermail/otrs</a><br>
To unsubscribe: <a href="http://lists.otrs.org/cgi-bin/listinfo/otrs" target="_blank">http://lists.otrs.org/cgi-bin/listinfo/otrs</a><br>
<br>
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!<br>
<a href="http://www.otrs.com/en/support/enterprise-subscription/" target="_blank">http://www.otrs.com/en/support/enterprise-subscription/</a><br>
</div></div></blockquote></div><br></div>