[Koha-bugs] [Bug 34276] upgrading 23.05 to 23.05.002

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34276

--- Comment #6 from Pedro Amorim <pedro.amorim at ptfs-europe.com> ---
(In reply to Katrin Fischer from comment #2)
> Which version did each of you update from?

The updates I can confirm were successful were from 22.11.06. And I'm not aware
of us having any issues from previous versions either. We're not using 23.05
yet.
Taking a quick look at this, I can't find any obvious issue.(In reply to SOS
from comment #5)

> I'm layman could you please help me with the SQL queries and how to run it.

You could run 'SHOW CREATE TABLE illrequests' and verify it matches what's on
kohastructure.sql

You could also run 
'SELECT * FROM illrequests WHERE biblio.biblionumber IS NULL AND
illrequests.biblio_id IS NOT NULL'
Just to rule out that there aren't any dangling non-existent biblio_ids in your
illrequests table.

If both the above checks out, maybe just removing the dbrev and doing the
update again is an option? The update seems to be idempotent so I'm not sure
what happened here.

-- 
You are receiving this mail because:
You are watching all bug changes.