[Koha] Migration erros from 16.05 to 16.11

[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.

On Wed, 30 Nov 2016 at 12:13 anjoze <joseanjos at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>