[Koha] Migration erros from 16.05 to 16.11

[Michael Kuhn]

Hi Jonathan

I have experienced similar errors yesterday when updating from Koha 
16.05.05 to 16.11.00 on Debian GNU/Linux 8 using MySQL 5.5:


Upgrade to 16.06.00.001 done (Bug 16200 - 'Hold waiting too long' fee 
has a translation problem)
DBD::mysql::db do failed: Duplicate column name 'updated_on' [for 
Statement "
         ALTER TABLE borrowers
             ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
             ON UPDATE CURRENT_TIMESTAMP
             AFTER privacy_guarantor_checkouts;
     "] at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl 
line 12626.
DBD::mysql::db do failed: Duplicate column name 'updated_on' [for 
Statement "
         ALTER TABLE deletedborrowers
             ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
             ON UPDATE CURRENT_TIMESTAMP
             AFTER privacy_guarantor_checkouts;
     "] at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl 
line 12632.
Upgrade to 16.06.00.002 done (Bug 10459 - borrowers should have a timestamp)


For the case of José Anjos you wrote:

Am 30.11.2016 um 12:29 schrieb Jonathan Druart:
> The table items_search_fields does not exist whereas it has been created by
> 3.17.00.046.
> You should manually replay this update DB entry ("CREATE TABLE IF NOT
> EXISTS items_search_fields [...]") then redo the whole update process.


Is there something else to do in my case?

As I understand José Anjos would have to do the following. Is this correct?

1. Restore the old Koha 16.05.05 database using "koha-restore"

2. Execute "CREATE TABLE IF NOT EXISTS items_search_fields [...]" in the 
database. What is the complete SQL command?

3. Execute "sudo apt-get install koha-common" again.


Best wishes: Michael
-- 
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch · W www.adminkuhn.ch