https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31859 Bug ID: 31859 Summary: Error 500 when enabling advanced cataloging editor Change sponsored?: --- Product: Koha Version: 21.05 Hardware: All OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: jcautomatizacion@gmail.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl Created attachment 142078 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=142078&action=edit 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.