[Koha-bugs] [Bug 29973] New: SQL syntax error in Cataloging when accessing pages "Advanced editor" and "New record"
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Jan 28 22:26:54 CET 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29973
Bug ID: 29973
Summary: SQL syntax error in Cataloging when accessing pages
"Advanced editor" and "New record"
Change sponsored?: ---
Product: Koha
Version: 21.11
Hardware: All
OS: Linux
Status: NEW
Severity: normal
Priority: P5 - low
Component: Cataloging
Assignee: koha-bugs at lists.koha-community.org
Reporter: dhodgins at coloradovirtuallibrary.org
QA Contact: testopia at bugs.koha-community.org
CC: m.de.rooy at rijksmuseum.nl
Recently upgraded to 21.11.01 and the "Advanced editor" page
https://chnc-koha-intra.domain/cgi-bin/koha/cataloguing/editor.pl now returns
Error 500. The intranet-error.log reports the following SQL syntax error:
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
AH01215:
\tDBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x561f387caed8), "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
AH01215:
\tDBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x561f389880d8),
"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
AH01215: \tDBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db
selectall_arrayref failed: You have an error i"...,
DBI::db=HASH(0x561f3a9a8f90), undef) called at
/usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl line 80:
/usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl
AH01215: : /usr/share/koha/intranet/cgi-bin/cataloguing/editor.pl
Koha 21.11.01.000
MySQL 8.0.27
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list