[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