[Bug 36491] New: 500 error on checkout after upgrade
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36491 Bug ID: 36491 Summary: 500 error on checkout after upgrade Change sponsored?: --- Product: Koha Version: 23.11 Hardware: All OS: Linux Status: NEW Severity: major Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: it.manager@hope.edu.kh QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Created attachment 164268 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=164268&action=edit errormessage Hi, just upgraded to 23.11 then ran koha-rebuild-zebra -v -f Since then, I'm getting a 500 error when checking out. I've confirmed homebranch, holdingbranch, and itype are not null (as suggested when searching this issue). I am really at a loss. Error logs are saturated with what I think are unrelated issues. Although, I am admittedly a novice at Koha so I could be very wrong. I've checked opac-error.log, plack-error.log, zebra-output.log. What could I be missing? Thanks in advance -- 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=36491 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I think the log should definitely have a relevant error - maybe you could share the entries? In general tho this is a support request and as such should be brought up on the mailing list or in the IRC chat as bugzilla shoudl only be used for errors and enhancement requests. Some other things to look at: * Does your calendar for the library look ok? (it has open days?) * Notice templates: CHECKOUT and HOLD can create 500 if they are using Template Toolkit with errors specifically. -- 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=36491 --- Comment #2 from Mike G <it.manager@hope.edu.kh> --- Thanks for the reply. I've checked the calendar and notices, all seems ok. Here are some entries from the plack-error log. The DB connection error baffles me as the other functions querying the database is fine. DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/Koha/Database.pm line 91. at /usr/share/koha/lib/C4/Context.pm line 669 C4::Languages::language_get_description(): DBI Exception: DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/share/koha/lib/C4/Languages.pm line 368 DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.patron_id' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 317 -- 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=36491 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- The last one could point to a problem with the database structure. When you look at the Version system preference (only to be seen in the "Local use" tab), which number is shown? Which number is shown on the About page for the version? To see whats going on in the logs a little easier: tail -f var/log/koha/<yourinstance>/*.log Then create the error in the GUI and check what's showing in the logs. -- 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=36491 --- Comment #4 from Mike G <it.manager@hope.edu.kh> --- It turns out this was the issue: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.patron_id' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 317 The XML version of the schema (https://schema.koha-community.org/23_11/) helped figure out what objects should have patron_id. I found the bookings table was missing columns, which was then able to be re-created from the schema. I'm not sure what steps from the upgrade caused it, or if this was the best route to fix it. Regardless, I figured I'd share in case other run into it. Thanks for the help, cheers! -- 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=36491 Mike G <it.manager@hope.edu.kh> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|NEW |RESOLVED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org