[Koha-bugs] [Bug 25609] Use of permanent location instead of location
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu May 28 22:55:18 CEST 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25609
--- Comment #6 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
I have dug a bit deeper:
$DBversion = '3.01.00.043';
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
$dbh->do('ALTER TABLE items ADD COLUMN permanent_location VARCHAR(80)
DEFAULT NULL AFTER location');
$dbh->do('UPDATE items SET permanent_location = location');
So if a database set up with a later version shows empty permanent_location
entries, while location is set, this must have happened somewhere after this
updatedatabase entry. Maybe by not setting the permanent_location correctly in
import, editing, adding...?
So maybe we need to make sure that it's now handled correctly everywhere before
we try to get to a clean state again.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list