Well Carlos, I think I did :)
I follow this URL: http://doc.otrs.org/3.1/en/html/upgrading.html

but to tell the truth the last part from "Now you can log into your system." to the end of the document I didn't do that. I didn't know how to do this part. Is it the cause of my issue?

Really appreciate your help.


De: Carlos Rodríguez <carlos.rodriguez@otrs.com>
Para: User questions and discussions about OTRS. <otrs@otrs.org>
CC: Israel Garcia <iga3725@yahoo.com>
Enviado: Lunes 1 de octubre de 2012 16:32
Asunto: Re: [otrs] Queue view are not showing data after upgrade to 3.1

Hi Israel,

Did you follow all upgrade instructions to upgrade OTRS from 3.0 to 3.1?

I mean all steps from "UPGRADING" file?

((enjoy))

Carlos Rodríguez




On Oct 1, 2012, at 9:05 AM, Carlos Andrés Gallego Arboleda <carlos.gallego@itconsultores.com.co> wrote:

OK Israel, 

Please view your table ticket on the database, 

The fields Ticketfreetext, ticketarticlefreetext and ticketfreetime these should not be

If exists you must to use the scripts of migration again, 

2012/10/1 Israel Garcia <iga3725@yahoo.com>
Hi Carlos,

I run the script /opt/otrs/bin/otrs.RebuildTicketIndex.pl, restart all OTRS and no success. Should I check in another place? 
Log file still saying:

[Mon Oct  1 15:52:38 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
[Mon Oct  1 15:52:38 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
[Mon Oct  1 15:52:38 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
[Mon Oct  1 15:52:38 2012][Notice][Kernel::System::Web::InterfaceAgent::Run] Response::Agent: 1s taken (URL:Action=AgentTicketQueue;QueueID=5;View=:igarcia)
[Mon Oct  1 15:52:39 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
[Mon Oct  1 15:52:39 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
[Mon Oct  1 15:52:39 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
[Mon Oct  1 15:52:40 2012][Notice][Kernel::System::Web::InterfaceAgent::Run] Response::Agent: 1s taken (URL:Action=AgentTicketQueue;QueueID=5;Filter=All:igarcia)
[Mon Oct  1 15:52:41 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
[Mon Oct  1 15:52:41 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
[Mon Oct  1 15:52:41 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!

Should you need another info for this issue? I need, if possible, your help to solve this before to touch anything and break it ALL trying to fix it.

Thanks much.




De: Carlos Andrés Gallego Arboleda <carlos.gallego@itconsultores.com.co>

Para: Israel Garcia <iga3725@yahoo.com>; User questions and discussions about OTRS. <otrs@otrs.org>
Enviado: Lunes 1 de octubre de 2012 15:48

Asunto: Re: [otrs] Queue view are not showing data after upgrade to 3.1

Hi Israel, 

You can use the scripts 




2012/10/1 Israel Garcia <iga3725@yahoo.com>
Hi Carlos,

I made a mistake when I said 3.0,16 I meant 3.1.16. Do you think I should reinstall all ITSM* from the Package manager TAB?

Really don't know which I made wrong on the migration. I appreciate your help. Thanks much.

regards,
Israel.


De: Carlos Rodríguez <carlos.rodriguez@otrs.com>
Para: Israel Garcia <iga3725@yahoo.com>; User questions and discussions about OTRS. <otrs@otrs.org>
Enviado: Lunes 1 de octubre de 2012 13:54
Asunto: Re: [otrs] Queue view are not showing data after upgrade to 3.1

Hi Israel,

Sure this is easy ITSM 3.0.x is designed for OTRS 3.0.x, since you already upgrade OTRS to 3.1 you need also to upgrade ITSM packages to 3.1.x

please follow this link to get your packages

OTRS 3.1 introduces a new concept called DynamicFields, that replaces TicketFreeText, TicketFreeTime, ArticleFreeText and ArticleFreeTime, etc fixed fields in the Database.

Que pases un buen día / Have a nice day!

((enjoy))

Carlos Rodríguez




On Oct 1, 2012, at 5:49 AM, Israel Garcia <iga3725@yahoo.com> wrote:


Hi everybody

After an upgrade to version 3.1 of OTRS and upgrade of ITSM addons from 3.0.5 to 3.0.16  'Queue tickets' are not shown:


When clic on 'Queue view' there's no tickets data found. Any idea why?



Log file is showing:



Appreciate your help.

Thanks.




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




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




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