Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Moderator: crythias
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Hi,
I am having problems to display/see/sort tickets by Queue on AgentTicketQueue.
I get the following message error:
Can't use an undefined value as an ARRAY reference at /opt/otrs//Kernel/Modules/AgentTicketQueue.pm line 540. ,
Any help?
Regards
I am having problems to display/see/sort tickets by Queue on AgentTicketQueue.
I get the following message error:
Can't use an undefined value as an ARRAY reference at /opt/otrs//Kernel/Modules/AgentTicketQueue.pm line 540. ,
Any help?
Regards
OTRS 6
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
OTRS version?
wich packages are installed?
any code cahnges?
wich packages are installed?
any code cahnges?
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Version: OTRS 5.0.11jojo wrote:OTRS version?
wich packages are installed?
any code cahnges?
Packages:
BetterResponses
ComplementoRepository
DisableOTRSBusinessNotification
FAQ
FAQImportExport
GeneralCatalog
ImportExport
ImportExportDynamicFields
ITSM
ITSMChangeManagement
ITSMConfigurationManagement
ITSMCore
ITSMIncidentProblemManagement
ITSMServiceLevelManagement
MultilevelServiceSelect
MyTicketsDashlet
OTRSCloneDB
OTRSMasterSlave
ServiceImportExport
SlaStop
Survey
SystemMonitoring
TicketChecklist
TicketOverviewHooked
TimeAccounting
ToolbarTicketOwner
UserImportExport
Znuny4OTRS-Repo
I did not make any code changes.
Regards
OTRS 6
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
well a lot of packkages which might not work all togehter. Also an unsecure version of OTRS (last one was 5.0.23)
You should update to the latest version of OTRS, the last version of each package. If the error should persists, please remove the 3rd party packages step by step till you found the one causing the trouble
You should update to the latest version of OTRS, the last version of each package. If the error should persists, please remove the 3rd party packages step by step till you found the one causing the trouble
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Run on the command line to find the files... And you can run to find out which addon provides the module.
Code: Select all
find . -name AgentTicketQueue.pm
Code: Select all
perl bin/otrs.Console.pl Admin::Package::FileSearch Kernel/Modules/AgentTicketQueue.pm
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Simply deleting modules can be dangerous as this could cause data loss... (when the addon creates database tables on installation and deletes them on uninstall).
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
I am getting the following error while running the second code:reneeb wrote:Runon the command line to find the files... And you can runCode: Select all
find . -name AgentTicketQueue.pm
to find out which addon provides the module.Code: Select all
perl bin/otrs.Console.pl Admin::Package::FileSearch Kernel/Modules/AgentTicketQueue.pm
Error: Could not find Kernel::System::Console::Command::Admin::Package::Filesearch.
Can you help me see what am I doing wrong ?
Regards
OTRS 6
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
FileSearch
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Even with the case sentitive I still get the error:reneeb wrote:FileSearch
otrs@OTRSDSI:/opt/otrs/Kernel/Modules> perl /opt/otrs/bin/otrs.Console.pl Admin::Package::FileSearch AgentTicketQueue.pm
Searching in installed OTRS packages...
Error: File AgentTicketQueue.pm was not found in an installed OTRS package.
otrs@OTRSDSI:/opt/otrs/Kernel/Modules> perl /opt/otrs/bin/otrs.Console.pl Admin::Package::FileSearch opt/otrs/Kernel/Modules/AgentTicketQueue.pm
Searching in installed OTRS packages...
Error: File opt/otrs/Kernel/Modules/AgentTicketQueue.pm was not found in an installed OTRS package.
otrs@OTRSDSI:/opt/otrs/Kernel/Modules>
Regards
OTRS 6
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
This is a different "error". It just tells you, that no addon overrides that module... Then run in the terminal.
Is there any other message in the logfile? Something like "Need ...!"?
Code: Select all
grep -r "_MaskQueueView" /opt/otrs/*
Is there any other message in the logfile? Something like "Need ...!"?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
After running grep -r "_MaskQueueView" /opt/otrs/ in the terminal I got this :reneeb wrote:This is a different "error". It just tells you, that no addon overrides that module... Then runin the terminal.Code: Select all
grep -r "_MaskQueueView" /opt/otrs/*
Is there any other message in the logfile? Something like "Need ...!"?
/opt/otrs/Kernel/Modules/AgentTicketQueue.pm: return $Self->_MaskQueueView(
/opt/otrs/Kernel/Modules/AgentTicketQueue.pm:sub _MaskQueueView {
In the System log I am getting the following:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( st.user_id IN (78) ) AND tf1.ticket_key = 'Seen' AND tf1.ticket_valu' at line 1, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN ticket_flag tf1 ON st.id = tf1.ticket_id WHERE 1=1 AND st.ticket_state_id IN ( ) AND ( st.user_id IN (78) ) AND tf1.ticket_key = 'Seen' AND tf1.ticket_value = '1' AND tf1.create_by = 78 LIMIT 10000'
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( st.user_id IN (30) ) AND tf1.ticket_key = 'Seen' AND tf1.ticket_valu' at line 1, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN ticket_flag tf1 ON st.id = tf1.ticket_id WHERE 1=1 AND st.ticket_state_id IN ( ) AND ( st.user_id IN (30) ) AND tf1.ticket_key = 'Seen' AND tf1.ticket_value = '1' AND tf1.create_by = 30 LIMIT 10000'
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( st.user_id IN (30) ) LIMIT 10000' at line 1, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st WHERE 1=1 AND st.ticket_state_id IN ( ) AND ( st.user_id IN (30) ) LIMIT 10000'
OTRS 6
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Did you change state names? Or the state types? Can you check the sysconfig option Ticket::ViewableStateType?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Since I am using Portuguese as the main language of OTRS, the states names changed:reneeb wrote:Did you change state names? Or the state types? Can you check the sysconfig option Ticket::ViewableStateType?
Name | Type
1- Por Tratar | aberto
2- Em Tratamento | aberto
3- Encerrar Caso | removido
Fechado | fechado
Fechado Automaticamente | fechado
Pendente Ext | pendente com lembrete
Pendente User | pendente com fecho automático
Reaberto | aberto
Resolvido | fechado
Submetido - Por Abrir | novo
NOTE: The name states are custom, but the State type are Just translated from English to Portuguese.
The states i see in the Ticket::ViewableStateType are:
new
open
pending reminder
pending auto
Regards
OTRS 6
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Are those state types translated in the database or with translation files? If you changed the values in the database, you have to use the translated values in the SysConfig as well.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
I did not change the database I just changed OTRS DefaultLanguage on Framework → Core and the state types showed up like that.reneeb wrote:Are those state types translated in the database or with translation files? If you changed the values in the database, you have to use the translated values in the SysConfig as well.
What files should I check in the Database?
Regards
OTRS 6
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Hi,
check table ticket_state
Flo
check table ticket_state
Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
In SQL I ran SELECT * FROM ticket_state and I have found the following:wurzel wrote:Hi,
check table ticket_state
Flo
id |name |type_id |valid_id
1 |Submetido - Por Abrir |1 |1
2 |Fechado |3 |1
3 |closed unsuccessful |3 |2
4 |1- Por Tratar |2 |1
5 |3- Encerrar Caso |6 |1
6 |Pendente Ext |4 |1
7 |Resolvido |3 |1
8 |Pendente User |5 |1
9 |2- Em Tratamento |2 |1
10 |closed with workaround |3 |2
================================================
Then I ran SELECT * FROM ticket_state_type
id name
1 new
2 open
3 closed
4 pending reminder
5 pending auto
6 removed
7 merged
OTRS 6
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Hi,
you see? You actually changed the state names in ticket_state
So you have to change them in sysconfig accordingly
or reset to default names and check sysconfig accordingly.
Florian
you see? You actually changed the state names in ticket_state
So you have to change them in sysconfig accordingly
or reset to default names and check sysconfig accordingly.
Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
Re: Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Yes now I see.wurzel wrote:Hi,
you see? You actually changed the state names in ticket_state
So you have to change them in sysconfig accordingly
or reset to default names and check sysconfig accordingly.
Florian
Since my DefaultLanguage is pt (Portuguese) I should change The Ticket::ViewableStateType to the ones I have in State ?
Regards
OTRS 6
-
- Znuny advanced
- Posts: 100
- Joined: 31 Mar 2016, 10:30
- Znuny Version: OTRS 6.0.30
- Real Name: Claude Chelene
[SOLVED]Cant Acess/Display/sort tickets by Queue on AgentTicketQueue
Thanks everyone , issue Solved.
Following instructions on the following Link:
https://translate.google.com/translate? ... 3Ft%3D7842
1- I went to the following directory /opt/otrs/var/tmp
2- I renamed the folder CacheFileStorable
3- And it was working again.
Regards
Following instructions on the following Link:
https://translate.google.com/translate? ... 3Ft%3D7842
1- I went to the following directory /opt/otrs/var/tmp
2- I renamed the folder CacheFileStorable
3- And it was working again.
Regards
OTRS 6