[Bug 33472] New: Error 500 when many items attached to bib record
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 Bug ID: 33472 Summary: Error 500 when many items attached to bib record Change sponsored?: --- Product: Koha Version: 22.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard@myacpl.org Reporter: david.roberts@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org We have a customer that has bibliographic records with several hundred items attached to each. When searching for these records, an error 500 is displayed instead. Lowering OpacMaxItemsToDisplay from 750 to 75 enables the records to display, although now when you click on the link to view all physical records an error 500 is still generated. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nick@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 Janet McGowan <janet.mcgowan@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |janet.mcgowan@ptfs-europe.c | |om -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=33568 CC| |martin.renvoize@ptfs-europe | |.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart+koha@gmail. | |com --- Comment #1 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- What is the error you have in Koha logs? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|oleonard@myacpl.org |koha-bugs@lists.koha-commun | |ity.org Severity|enhancement |normal -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 --- Comment #2 from David Roberts <david.roberts@ptfs-europe.com> --- I can't see a great deal in the logs that is meaningful: [2024/01/23 03:06:39] [WARN] item-level_itypes set but no itemtype set for item (121386) at /usr/share/koha/lib/Koha/Schema/Result/Item.pm line 979. Template process failed: undef error - The method Koha::Serial::Item->serialseq is not covered by tests! Trace begun at /usr/share/koha/lib/Koha/Object.pm line 900 Koha::Object::AUTOLOAD('Koha::Serial::Item=HASH(0x5640d6589300)') called at /usr /share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-detail.tt line 1340 eval {...} at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-de tail.tt line 1340 eval {...} at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-de tail.tt line 1429 eval {...} at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-de tail.tt line 1183 Template::Provider::__ANON__('Template::Context=HASH(0x5640da2017b0)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Context.pm line 348 eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Context.pm line 321 Template::Context::process('Template::Context=HASH(0x5640da2017b0)', 'items_tabl e', 'HASH(0x5640db784748)', 'localize me!') called at /usr/lib/x86_64-linux-gnu/ perl5/5.32/Template/Context.pm line 409 Template::Context::include('Template::Context=HASH(0x5640da2017b0)', 'items_tabl e', 'HASH(0x5640db784748)') called at /usr/share/koha/opac/htdocs/opac-tmpl/boot strap/en/modules/opac-detail.tt line 534 eval {...} at /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-de tail.tt line 18 Template::Provider::__ANON__('Template::Context=HASH(0x5640da2017b0)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Document.pm line 163 eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Document.pm line 161 Template::Document::process('Template::Document=HASH(0x5640db7180f0)', 'Template ::Context=HASH(0x5640da2017b0)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/ Template/Context.pm line 351 eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Context.pm line 321 Template::Context::process('Template::Context=HASH(0x5640da2017b0)', 'Template:: Document=HASH(0x5640db7180f0)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/T emplate/Service.pm line 94 eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x5640db9c2ce8)', '/usr/share /koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/opac-detail.tt', 'HASH(0x5640db 691e88)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template.pm line 66 Template::process('Template=HASH(0x5640da4e43f8)', '/usr/share/koha/opac/htdocs/ opac-tmpl/bootstrap/en/modules/opac-detail.tt', 'HASH(0x5640db691e88)', 'SCALAR( 0x5640d28a6088)') called at /usr/share/koha/lib/C4/Templates.pm line 127 C4::Templates::output('C4::Templates=HASH(0x5640db9bff98)') called at /usr/share /koha/opac/cgi-bin/opac/opac-detail.pl line 1249 eval {...} at /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl line 2 CGI::Compile::ROOT::usr_share_koha_opac_cgi_2dbin_opac_opac_2ddetail_2epl::__ANO N__('CGI::Compile=HASH(0x5640ce960da8)', '', '/usr/share/koha/opac/cgi-bin/opac/ opac-detail.pl', '/usr/share/koha/opac/cgi-bin/opac', 'ARRAY(0x5640d626ff58)') c alled at /usr/share/perl5/CGI/Compile.pm line 151 CGI::Compile::ROOT::usr_share_koha_opac_cgi_2dbin_opac_opac_2ddetail_2epl::opac_ 2ddetail_2epl at /usr/share/perl5/CGI/Emulate/PSGI.pm line 30 CGI::Emulate::PSGI::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/ Plack/App/WrapCGI.pm line 95 Plack::App::WrapCGI::call('Plack::App::WrapCGI=HASH(0x5640d61b13f0)', 'HASH(0x56 40d632d640)') called at /usr/share/perl5/Plack/Component.pm line 50 Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl ack/App/CGIBin.pm line 50 Plack::App::CGIBin::serve_path('Plack::App::CGIBin=HASH(0x5640ce719e20)', 'HASH( 0x5640d632d640)', '/usr/share/koha/opac/cgi-bin/opac/opac-detail.pl') called at /usr/share/perl5/Plack/App/File.pm line 34 Plack::App::File::call('Plack::App::CGIBin=HASH(0x5640ce719e20)', 'HASH(0x5640d6 32d640)') called at /usr/share/perl5/Plack/Component.pm line 50 Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl ack/Middleware/LogWarn.pm line 22 Plack::Middleware::LogWarn::call('Plack::Middleware::LogWarn=HASH(0x5640d63584c8 )', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Component.pm line 5 0 Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl ack/Middleware/Log4perl.pm line 30 Plack::Middleware::Log4perl::call('Plack::Middleware::Log4perl=HASH(0x5640d63614 00)', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Component.pm line 50 Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl ack/Middleware/HTTPExceptions.pm line 20 Plack::Middleware::HTTPExceptions::try {...} at /usr/share/perl5/Try/Tiny.pm li ne 100 eval {...} at /usr/share/perl5/Try/Tiny.pm line 93 Try::Tiny::try('CODE(0x5640da464628)', 'Try::Tiny::Catch=REF(0x5640db9bfc38)') c alled at /usr/share/perl5/Plack/Middleware/HTTPExceptions.pm line 23 Plack::Middleware::HTTPExceptions::call('Plack::Middleware::HTTPExceptions=HASH( 0x5640d6361610)', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Compo nent.pm line 50 Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl ack/Middleware/ErrorDocument.pm line 15 Plack::Middleware::ErrorDocument::call('Plack::Middleware::ErrorDocument=HASH(0x 5640d6377150)', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Compone nt.pm line 50 Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/perl5/Pl ack/App/URLMap.pm line 71 Plack::App::URLMap::call('Plack::App::URLMap=HASH(0x5640d4f251e0)', 'HASH(0x5640 d632d640)') called at /usr/share/perl5/Plack/Component.pm line 50 Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/koha/lib /Koha/Middleware/RealIP.pm line 64 Koha::Middleware::RealIP::call('Koha::Middleware::RealIP=HASH(0x5640d6360e30)', 'HASH(0x5640d632d640)') called at /usr/share/perl5/Plack/Component.pm line 50 Plack::Component::__ANON__('HASH(0x5640d632d640)') called at /usr/share/koha/lib /Koha/Middleware/SetEnv.pm line 105 Koha::Middleware::SetEnv::call('Koha::Middleware::SetEnv=HASH(0x5640d634f8c0)', 'HASH(0x5640d62a79d8)') called at /usr/share/perl5/Plack/Component.pm line 50 Plack::Component::__ANON__('HASH(0x5640d62a79d8)') called at /usr/share/perl5/Pl ack/Middleware/Static.pm line 18 Plack::Middleware::Static::call('Plack::Middleware::Static=HASH(0x5640d63646f8)' , 'HASH(0x5640d62a79d8)') called at /usr/share/perl5/Plack/Component.pm line 50 Plack::Component::__ANON__('HASH(0x5640d62a79d8)') called at /usr/share/perl5/Pl ack/Middleware/ReverseProxy.pm line 68 Plack::Middleware::ReverseProxy::call('Plack::Middleware::ReverseProxy=HASH(0x56 40d634f5c0)', 'HASH(0x5640d62a79d8)') called at /usr/share/perl5/Plack/Component .pm line 50 Plack::Component::__ANON__('HASH(0x5640d62a79d8)') called at /usr/share/perl5/Pl ack/Middleware/AccessLog.pm line 27 Plack::Middleware::AccessLog::call('Plack::Middleware::AccessLog=HASH(0x5640ce72 b370)', 'HASH(0x5640d62a79d8)') called at /usr/share/perl5/Plack/Component.pm li ne 50 Plack::Component::__ANON__('HASH(0x5640d62a79d8)') called at /usr/share/perl5/Pl ack/Util.pm line 145 eval {...} at /usr/share/perl5/Plack/Util.pm line 145 Plack::Util::run_app('CODE(0x5640ce72b328)', 'HASH(0x5640d62a79d8)') called at / usr/share/perl5/Starman/Server.pm line 195 Starman::Server::dispatch_request('Starman::Server=HASH(0x5640ce133e80)', 'HASH( 0x5640d62a79d8)') called at /usr/share/perl5/Starman/Server.pm line 298 Starman::Server::process_request('Starman::Server=HASH(0x5640ce133e80)', 'Net::S erver::Proto::UNIX=GLOB(0x5640da2413d8)') called at /usr/share/perl5/Net/Server. pm line 72 Net::Server::run_client_connection('Starman::Server=HASH(0x5640ce133e80)') calle d at /usr/share/perl5/Net/Server/PreFork.pm line 225 eval {...} at /usr/share/perl5/Net/Server/PreFork.pm line 225 Net::Server::PreFork::run_child('Starman::Server=HASH(0x5640ce133e80)') called a t /usr/share/perl5/Net/Server/PreFork.pm line 183 Net::Server::PreFork::run_n_children('Starman::Server=HASH(0x5640ce133e80)', 1) called at /usr/share/perl5/Net/Server/PreFork.pm line 373 Net::Server::PreFork::coordinate_children('Starman::Server=HASH(0x5640ce133e80)' ) called at /usr/share/perl5/Net/Server/PreFork.pm line 327 Net::Server::PreFork::run_parent('Starman::Server=HASH(0x5640ce133e80)') called at /usr/share/perl5/Starman/Server.pm line 164 Starman::Server::run_parent('Starman::Server=HASH(0x5640ce133e80)') called at /u sr/share/perl5/Net/Server/PreFork.pm line 109 Net::Server::PreFork::loop('Starman::Server=HASH(0x5640ce133e80)') called at /us r/share/perl5/Net/Server.pm line 58 Net::Server::run('Starman::Server=HASH(0x5640ce133e80)', 'port', 'ARRAY(0x5640ce 6c4750)', 'host', '*', 'proto', 'tcp', 'serialize', 'none', 'min_servers', 6, 'm in_spare_servers', 5, 'max_spare_servers', 5, 'max_servers', 6, 'max_requests', 50, 'user', 'kfc-koha', 'group', 'kfc-koha', 'listen', 1024, 'check_for_waiting' , 1, 'no_client_stdout', 1, 'log_file', '/var/log/koha/kfc/plack-error.log', 'pi d_file', '/var/run/koha/kfc/plack.pid', 'setsid', 1, 'background', 1) called at /usr/share/perl5/Starman/Server.pm line 106 Starman::Server::run('Starman::Server=HASH(0x5640ce133e80)', 'CODE(0x5640ce133d6 0)', 'HASH(0x5640ce133b08)') called at /usr/share/perl5/Plack/Handler/Starman.pm line 25 Plack::Handler::Starman::run('Plack::Handler::Starman=HASH(0x5640ce133d78)', 'CO DE(0x5640ce133d60)') called at /usr/share/perl5/Plack/Loader/Delayed.pm line 20 Plack::Loader::Delayed::run('Plack::Loader::Delayed=HASH(0x5640cdf84120)', 'Plac k::Handler::Starman=HASH(0x5640ce133d78)') called at /usr/share/perl5/Plack/Runn er.pm line 279 Plack::Runner::run('Plack::Runner=HASH(0x5640cdf1e088)') called at /bin/starman line 38 There are 78 items attached to this bib record, all of which have item types associates, together with a valid 942 subfield c. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- The meaningful is right at the beginning: "[2024/01/23 03:06:39] [WARN] item-level_itypes set but no itemtype set for item (121386) at /usr/share/koha/lib/Koha/Schema/Result/Item.pm line 979." You should double check the item with this itemnumber = 121386. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33472 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|NEW |RESOLVED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org