Bug 17292 - Use of DBIx in updatedatabase.pl broke upgrade
authorKyle M Hall <kyle@bywatersolutions.com>
Mon, 12 Sep 2016 14:20:19 +0000 (14:20 +0000)
committerBrendan Gallagher <brendan@bywatersolutions.com>
Mon, 10 Oct 2016 10:20:56 +0000 (10:20 +0000)
commitf11f07a703eca7da2d32c105f8c9f4f46f940b6f
treebea1c655a3853026baae30b56cf65de20a341d6a
parent0599ab00768e7d2ee487c6d02a0230d4a2a96d9e
Bug 17292 - Use of DBIx in updatedatabase.pl broke upgrade

A recent change in the 'subscription' table structure highlighted a
problem in a DBRev upgrade (3.23.00.006). As it adds a new column, when
upgrading from (say) 3.20.00.000 the code/schema (correctly) expects the
subscription.itemtype column to exist. But it is not created until DBRev
16.06.00.025.

To reproduce:
- Have a clean 3.20.00 DB loaded into kohadevbox
- Checkout current master
- Run:
  $ perl installer/data/mysql/updatedatabase.pl
  => FAIL: The upgrade procedure fails due to missing colum.

  The solution: rewrite the updatedatabase.pl entry using plain DBI

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com>
installer/data/mysql/updatedatabase.pl