[Koha] Migration erros from 16.05 to 16.11

Jonathan Druart jonathan.druart at bugs.koha-community.org
Thu Dec 1 05:24:50 NZDT 2016


Yes, keep in mind to check the errors when you upgrade your database :)

On Wed, 30 Nov 2016 at 17:19 anjoze <joseanjos at gmail.com> wrote:

> Ok, I've found the sql file on
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql
>
> I've executed:
> CREATE TABLE IF NOT EXISTS items_search_fields (
> name VARCHAR(255) NOT NULL,
> label VARCHAR(255) NOT NULL,
> tagfield CHAR(3) NOT NULL,
> tagsubfield CHAR(1) NULL DEFAULT NULL,
> authorised_values_category VARCHAR(32) NULL DEFAULT NULL,
> PRIMARY KEY(name),
> 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)
> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>
> Then checked if was created: select * from information_schema.columns where
> table_name='items_search_fields';
> Everything ok.
>
> Then executed: koha-upgrade-schema
> It looks that nothing happened...
> Do I have to make something else?
> Thanks
>
>
>
> -----
> 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-tp5912344p5912431.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
>


More information about the Koha mailing list