[Koha-bugs] [Bug 31948] Add timestamp to tmp_holdsqueue

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

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

--- Comment #9 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(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 :(

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