Hi, I apologize for my first post on the forum.
But I've been searching for a solution online for quite a while and couldn't find a solution to the problem described below. I kindly request your technical support. Centos 7.9 znuny-6.3.4/PGSQL 9.2 Error description: After step-by-step migration from otrs-5.0.42 to znuny-6.3.4, there is an issue with long login times, and the following entry is recorded in the log:
Sep 18 12:13:27 otrs-prod01-otrs01 OTRS-CGI-10[28097]: [Error][Kernel::System::Ticket::TicketSearch::TicketCountByAttribute][Line:2867]: number of parameters must be between 0 and 65535, SQL: 'SELECT COUNT(*), queue_id FROM ticket WHERE id IN AND queue_id IS NOT NULL GROUP BY queue_id LIMIT 10000'
[Mon Sep 18 12:13:27 2023] -e: DBD::Pg::st execute failed: number of parameters must be between 0 and 65535 at /opt/otrs//Kernel/System/DB.pm line 695.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Sep 18 12:13:27 2023
Message: number of parameters must be between 0 and 65535, SQL: 'SELECT COUNT(*), queue_id FROM ticket WHERE id IN
RemoteAddress: ::1
RequestURI: /otrs/index.pl?
Traceback (28097):
Module: Kernel::System::Ticket::TicketSearch::TicketCountByAttribute Line: 2867
Module: Kernel::Output::HTML::Dashboard::TicketQueueOverview::Run Line: 178
Module: Kernel::Modules::AgentDashboardCommon::_Element Line: 981
Module: Kernel::Modules::AgentDashboardCommon::Run Line: 611
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1144
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 39
Module: (eval) (v1.99) Line: 207
Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
Module: ModPerl::Registry
Error migration from otrs-5.0.42 to znuny-6.3.4
Moderator: crythias
-
- Znuny newbie
- Posts: 1
- Joined: 18 Sep 2023, 13:34
- Znuny Version: 6.3.4
- Real Name: Marius