https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31948 --- Comment #11 from Tomás Cohen Arazi <tomascohen@gmail.com> --- (In reply to Katrin Fischer from comment #9)
(In reply to Marcel de Rooy from comment #8)
+ $dbh->do(q{ALTER TABLE `tmp_holdsqueue` ADD `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP AFTER item_level_request});
Hmm. No check if column exists? Not idempotent..
Resulting in: Upgrade to 22.06.00.075 [09:27:16]: Bug 31948 - Add timestamp to tmp_holdsqueue table ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate column name 'timestamp' at /usr/share/koha/C4/Installer.pm line 739
Hi Marcel, you are right, we should add the check. Sorry for missing it. I probably won't be able to provide the patch today or tomorrow tho :(
Moved the resolution of this to bug 33051 and removed the additional_work_needed keyword. -- You are receiving this mail because: You are watching all bug changes.