[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 #11 from Tomás Cohen Arazi <tomascohen at 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.