[Koha-bugs] [Bug 32399] Database update for bug 30483 is failing

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

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

--- Comment #3 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
Created attachment 144428
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=144428&action=edit
Bug 32399: Unset foreign key checks while changing issues constraint

Some users have reported that the dbrev of bug 30483 fails. This might
depend on bad data, SQL server version, etc.
The easiest workaround is now to unset the check temporarily.
Maybe we should also warn for issues without itemnumber or
borrowernumber on About? Or remove them?

Test plan:
Reset your version in order to pass this dbrev again. So below
22.06.00.041.
* update systempreferences set value='22.0600040' where variable = 'Version';
Run updatedatabase.

Bonus: Create an issues record with invalid itemnumber (set FK check
off when doing so). Verify that dbrev prints warning about it.

Signed-off-by: Marcel de Rooy <m.de.rooy at rijksmuseum.nl>

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