[Koha-bugs] [Bug 17914] The installer process tries to create borrowers.updated_on twice

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Jan 16 12:00:49 CET 2017


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

--- Comment #1 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Created attachment 59004
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=59004&action=edit
Bug 17914: Do not try and add the updated_on columns to the borrowers and
deletedborrowers table

Bug 10459 has been backported and the DB entry (add borrowers.updated_on and
deletedborrower.updated_on) is now played in
  - 16.06.00.027
  - 16.05.00.002
  - 3.22.08.001

This will raise a MySQL warning if the column already exists.
  DBD::mysql::db do failed: Duplicate column name 'updated_on'

Since bug 17234 we have now a subroutine (C4::Installer::column_exists) to test
if a column exists.
When a DB entry modifying the DB structure is backported, it HAS TO check if
the
column, constraint or table exists before executing the query.

Test plan:
git checkout 3.22.x (16.05.x or 16.11.x)
install Koha
git checkout master
execute the installer
=> Without this patch you will get a warning when adding borrowers.updated_on)
=> With this patch, you should not get it

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


More information about the Koha-bugs mailing list