Bug 31859 - Error 500 when enabling advanced cataloging editor
Summary: Error 500 when enabling advanced cataloging editor
Status: RESOLVED DUPLICATE of bug 33375
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: 22.05
Hardware: All Linux
: P3 major (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-10-18 15:15 UTC by Jonathan Cuéllar
Modified: 2023-05-18 08:30 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Erro500 (47.03 KB, image/png)
2022-10-18 15:15 UTC, Jonathan Cuéllar
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Cuéllar 2022-10-18 15:15:49 UTC
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.
Comment 1 Katrin Fischer 2022-11-17 16:31:44 UTC
Hi Jonathan,

what is your exact Koha version? 22.11.XX
How did you install Koha?
Comment 2 Jonathan Cuéllar 2022-11-18 12:47:00 UTC
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
Comment 3 Katrin Fischer 2022-11-19 20:05:29 UTC
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.
Comment 4 Jonathan Druart 2022-11-22 07:52:46 UTC
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.
Comment 5 Jonathan Cuéllar 2022-12-06 15:12:38 UTC
Hello,
Yes, you have a Z39.50 server configuration
The installation was done with Debian packages.
Comment 6 Jonathan Cuéllar 2022-12-06 15:15:53 UTC
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.
Comment 7 Katrin Fischer 2023-05-14 11:56:44 UTC
Could this be vug 33375?
Comment 8 Katrin Fischer 2023-05-14 11:57:03 UTC
(In reply to Katrin Fischer from comment #7)
> Could this be vug 33375?
Bug 33375.
Comment 9 Katrin Fischer 2023-05-18 08:30:56 UTC
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 ***