Doug, I would love to hear the same. I have been unsuccessfully fighting an upgrade from 19.05 to 20.11.x for two months now. All errors are missing SQL columns that are not fixed by koha-upgrade-schema. Just doing an upgrade using the Debian package manager kills Koha altogether. Hope someone can share this information.
Scott -----Original Message----- From: Koha <koha-boun...@lists.katipo.co.nz> On Behalf Of Doug Dearden Sent: Friday, February 19, 2021 1:22 PM To: Alvaro Cornejo <cornejo.alv...@gmail.com> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Help debugging Internal Server Error Hey Everyone, Thank you Alvaro and Jonathan for your help, I wanted to report back that I got this fixed and what the problem was in case someone else runs into this. An error in the plack-opac-error.log appears, and the same warning appears when I did koha-rebuild-zebra with the –v option: DBD::mysql::st execute failed: Unknown column 'me.exclude_from_local_holds_priority' I created a new instance, and found that column in the items table on the new instance but not on the old instance. I added the column with the SQL command: ALTER TABLE items ADD exclude_from_local_holds_priority tinyint(1) and that fixed it. I’m not sure why koha-upgrade-schema didn’t fix this. I have another instance that we stopped using and combined with an existing one. I tried doing koha-remove, then koha-restore, the koha-upgrade-schema on that instance and it didn’t work. I am concerned that there may be other database alterations between version 19.05 and 20.11.02.000 that also didn’t make it into the database. I found a reference to database changes on the wiki but it ends in the 3.x series. How do I find out what other database schema changes have been implemented between 19.05 and 20.11.02.000? Thanks, Doug Dearden Director / Information Technology School for Advanced Research (SAR) PO Box 2188 / Santa Fe / NM / 87504-2188 505.954.7220 / www.sarweb.org<http://www.sarweb.org/> EXPLORING HUMANITY. UNDERSTANDING OUR WORLD. Receive the SAR monthly E-News: SIGN UP HERE <https://sarweb.org/about/e-news-signup/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
