[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

Marcel de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |additional_work_needed
                 CC|                            |m.de.rooy at rijksmuseum.nl

--- Comment #8 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
+        $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

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