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@adminkuhn.ch · W www.adminkuhn.ch