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 m...@adminkuhn.ch · W www.adminkuhn.ch
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha