[Koha-devel] Cannot upgrade DB from 16.05 to 18.05.00. Solid crash and burn in updatedatabase.pl

[Philippe Blouin]

Holà!

Currently migrating some 3.0 DB to 18.05.  A single hiccup with 
message_transport, no biggie.  Until...

16.06.00.042

Upgrade to 16.06.00.041 done (Bug 14629 - Add aggressive ISSN matching 
feature equivalent to the aggressive ISBN matcher)
DBD::mysql::st execute failed: Unknown column 'me.p_sep_by_space' in 
'field list' [for Statement "SELECT `me`.`currency`, `me`.`symbol`, 
`me`.`isocode`, `me`.`timestamp`, `me`.`rate`, `me`.`active`, 
`me`.`archived`, `me`.`p_sep_by_space` FROM `currency` `me` WHERE ( 
`active` = ? )" with ParamValues: 0=1] at 
/usr/local/share/perl/5.24.1/DBIx/Class/Storage/DBI.pm line 1836.
DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 
'me.p_sep_by_space' in 'field list' at 
/inlibro/git/koha-csf-prod-inlibro/Koha/Objects.pm line 209

Basically, the update code uses Koha::Number::Price, which in full 
modern object mode goes for its newly added *p_sep_by_space* _in the 
18.05 code_.  But the DB doesn't have it yet (it comes with 17.12.00.022).

Big crash big time.  The process stops.

Any workaround? (didn't see anything in the list, nor bugzilla, did I 
miss it?).

Thanks,

PS this is bound to happen whenever Koha objects are used in 
updatedatabase.pl.

-- 
Philippe Blouin,
Responsable du développement informatique

Tél.  : (888) 604-2627
philippe.blouin at inLibro.com <mailto:philippe.blouin at inLibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20180612/91931bf7/attachment.html>