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