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
- 
				DevOpsEngineer
 - Znuny newbie
 - Posts: 1
 - Joined: 18 Sep 2023, 13:34
 - Znuny Version: 6.3.4
 - Real Name: Marius