[Koha-bugs] [Bug 17914] New: 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 11:57:23 CET 2017


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

            Bug ID: 17914
           Summary: The installer process tries to create
                    borrowers.updated_on twice
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: ASSIGNED
          Severity: major
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: jonathan.druart at bugs.koha-community.org
          Reporter: jonathan.druart at bugs.koha-community.org
        QA Contact: testopia at bugs.koha-community.org
        Depends on: 17234, 10459

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.


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10459
[Bug 10459] borrowers should have a timestamp
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234
[Bug 17234] ALTER IGNORE TABLE is invalid in mysql 5.7.  This breaks
updatedatabase.pl
-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list