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.On Wed, 30 Nov 2016 at 12:13 anjoze <josean...@gmail.com> wrote: > Just to leave some feedback. > > *Migration from* > Koha 16.05 > OS: Ubuntu 16.04 64bits > Mysql 5.7 with: > > sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION > > *To:* > Koha 16.11 > OS Ubuntu 16.04 64bits > MariaDB > > First I've tried to upgrade on the same machine and had tons of problems > maybe because Mysql 5.7 > Then on a new VM machine with MariaDB I've imported the sql backup and had > this erros: > > DBD::mysql::db do failed: Table 'koha_koha.items_search_fields' doesn't > exist [for Statement " > ALTER TABLE items_search_fields > DROP FOREIGN KEY items_search_fields_authorised_values_category; > "] at > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl > line > 13152. > DBD::mysql::db do failed: Table 'koha_koha.items_search_fields' doesn't > exist [for Statement " > ALTER TABLE items_search_fields > ADD CONSTRAINT `items_search_fields_authorised_values_category` FOREIGN > KEY (`authorised_values_category`) REFERENCES `authorised_value_categories` > (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE; > "] at > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl > line > 13157. > > Until now everything look ok... > > > > ----- > Koha version: 16.05.05 > - - > José Anjos > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344.html > Sent from the Koha-general mailing list archive at Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
