Created attachment 142078 [details] Erro500 Hello everyone, An error is appearing when the advanced cataloging editor is enabled, it does not allow opening the editor or creating new records, error 500 appears. If the advanced editor is disabled, the system works correctly. The recorded log is as follows: [Tue Oct 18 14:19:17.189372 2022] [cgi:error] [pid 3532853] [client 186.102.58.32:7547] AH01215: {UNKNOWN}: DBI Exception: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',servername' at line 3 at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://intra-archivohistoricopsbdc.org/cgi-bin/koha/cataloguing/addbooks.pl [Tue Oct 18 14:19:17.189604 2022] [cgi:error] [pid 3532853] [client 186.102.58.32:7547] AH01215: \tDBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x55e190abe1f0), "DBI Exception: DBD::mysql::db selectall_arrayref failed: You "...) called at /usr/share/perl5/DBIx/Class/Storage.pm line 113: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://intra-archivohistoricopsbdc.org/cgi-bin/koha/cataloguing/addbooks.pl [Tue Oct 18 14:19:17.189796 2022] [cgi:error] [pid 3532853] [client 186.102.58.32:7547] AH01215: \tDBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x55e190c5a2f8), "DBI Exception: DBD::mysql::db selectall_arrayref failed: You "...) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://intra-archivohistoricopsbdc.org/cgi-bin/koha/cataloguing/addbooks.pl [Tue Oct 18 14:19:17.189985 2022] [cgi:error] [pid 3532853] [client 186.102.58.32:7547] AH01215: \tDBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db selectall_arrayref failed: You have an error i"..., DBI::db=HASH(0x55e192c83040), undef) called at /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl line 80: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://intra-archivohistoricopsbdc.org/cgi-bin/koha/cataloguing/addbooks.pl [Tue Oct 18 14:19:17.189992 2022] [cgi:error] [pid 3532853] [client 186.102.58.32:7547] AH01215: : /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://intra-archivohistoricopsbdc.org/cgi-bin/koha/cataloguing/addbooks.pl [Tue Oct 18 14:19:17.220155 2022] [cgi:error] [pid 3532853] [client 186.102.58.32:7547] End of script output before headers: editor.pl, referer: http://intra-archivohistoricopsbdc.org/cgi-bin/koha/cataloguing/addbooks.pl I appreciate your help in identifying the cause of this error.
Hi Jonathan, what is your exact Koha version? 22.11.XX How did you install Koha?
Hi Katrin, This bug started in version 21.05 and then I did a couple of updates until 22.05. Install a new instance from scratch and the error remains. In the new instance of koha 22.05 I have the following errors recorded in the log: [Thu Nov 17 11:57:22.898804 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: Template process failed: undef error - The method Koha::KeyboardShortcuts->shortcut_keys is not covered by tests!: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.899004 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: : /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.899121 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: Trace begun at /usr/share/koha/lib/Koha/Objects.pm line 572: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.899366 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: Koha::Objects::AUTOLOAD('Koha::KeyboardShortcuts=HASH(0x5574c79f6d20)') called at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/es-ES/modules/cataloguing/editor.tt line 334: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.899522 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: eval {...} at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/es-ES/modules/cataloguing/editor.tt line 334: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.899676 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: eval {...} at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/es-ES/modules/cataloguing/editor.tt line 332: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.899825 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: eval {...} at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/es-ES/modules/cataloguing/editor.tt line 18: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.900009 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: Template::Provider::_ANON_('Template::Context=HASH(0x5574c53f7128)') called at /usr/lib/x86_64-linux-gnu/perl5/5.30/Template/Document.pm line 163: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.900135 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.30/Template/Document.pm line 161: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.900351 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: Template::Document::process('Template::Document=HASH(0x5574c7a69518)', 'Template::Context=HASH(0x5574c53f7128)') called at /usr/lib/x86_64-linux-gnu/perl5/5.30/Template/Context.pm line 351: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.900515 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.30/Template/Context.pm line 321: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.900723 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: Template::Context::process('Template::Context=HASH(0x5574c53f7128)', 'Template::Document=HASH(0x5574c7a69518)') called at /usr/lib/x86_64-linux-gnu/perl5/5.30/Template/Service.pm line 94: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.900845 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.30/Template/Service.pm line 91: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.901089 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: Template::Service::process('Template::Service=HASH(0x5574c53c19d0)', '/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/es-ES/modules/cataloguing/editor.tt', 'HASH(0x5574c7a22a70)') called at /usr/lib/x86_64-linux-gnu/perl5/5.30/Template.pm line 66: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.901340 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: Template::process('Template=HASH(0x5574c53cb398)', '/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/es-ES/modules/cataloguing/editor.tt', 'HASH(0x5574c7a22a70)', 'SCALAR(0x5574c15d4368)') called at /usr/share/koha/lib/C4/Templates.pm line 127: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.901493 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] AH01215: C4::Templates::output('C4::Templates=HASH(0x5574c53caf00)') called at /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl line 86: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl [Thu Nov 17 11:57:22.930560 2022] [cgi:error] [pid 833718] [client 186.102.16.136:36960] End of script output before headers: editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl
I am not sure Jonathan, there are several different errors. [Tue Oct 18 14:19:17.189372 2022] [cgi:error] [pid 3532853] [client 186.102.58.32:7547] AH01215: {UNKNOWN}: DBI Exception: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',servername' at line 3 at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://intra-archivohistoricopsbdc.org/cgi-bin/koha/cataloguing/addbooks.pl Do you have any SRU/Z39.50 sources configured? servername is a column there. 186.102.16.136:36960] AH01215: Template process failed: undef error - The method Koha::KeyboardShortcuts->shortcut_keys is not covered by tests!: /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl, referer: http://archivohistorico-intra.org:82/cgi-bin/koha/cataloguing/addbooks.pl This one also doesn't look good.
How did you install? Using the Debian packages? Looks like several things are going wrong. This one "The method Koha::KeyboardShortcuts->shortcut_keys is not covered by tests" may be fixed if you restart the services.
Hello, Yes, you have a Z39.50 server configuration The installation was done with Debian packages.
Hello, Yes, I have a Z39.50 server setup The installation was done with Debian packages. I am enabling the advanced editor to be able to place the 001 field that is generated automatically. If you know of another way and can tell me while this impasse is solved, I would appreciate it.
Could this be vug 33375?
(In reply to Katrin Fischer from comment #7) > Could this be vug 33375? Bug 33375.
I believe this IS a duplicate to bug 33375: [Tue Oct 18 14:19:17.189372 2022] [cgi:error] [pid 3532853] [client 186.102.58.32:7547] AH01215: {UNKNOWN}: DBI Exception: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',servername' The fix: WHERE recordtype != 'authority' AND servertype = 'zed' - ORDER BY rank,servername + ORDER BY `rank`,servername *** This bug has been marked as a duplicate of bug 33375 ***