Yes, keep in mind to check the errors when you upgrade your database :) On Wed, 30 Nov 2016 at 17:19 anjoze <joseanjos@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-tp5912... 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