[Koha] Help debugging Internal Server Error

[Doug Dearden]

Hey Everyone,

A further update.  I dumped the schema to an xml file for both the new test database and the old database.  I then did a comparison using winmerge and there are multiple differences.  So the catalog is running but I am concerned because the database I am running is not up to the current version.

Any idea why koha-upgrade-schema wouldn't work?  Possibly a permissions issue?  

Thanks,

Doug

-----Original Message-----
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Doug Dearden
Sent: Friday, February 19, 2021 12:22 PM
To: Alvaro Cornejo <cornejo.alvaro at gmail.com>
Cc: koha at 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 at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha