Hi Zeno, first of all - thanks for testing the update process and your work on fixing the problems.
I think I might have found a solution looking at older updates where we solved a similar problem. In my tests it's looking good so far. Could you take a look at my follow-up patch? Hope it works, Katrin Am 21.11.2015 um 11:57 schrieb Zeno Tajoli: > Hi to all, > > I trying to resolve bug 15207, > Error on upgrade from 3.20.5 to 3.22 beta > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15207. > > The second error (insert defaults in the table 'permissions') > it easy, I change 'INSERT' with 'INSERT IGNORE' and all is OK. > > The first one is much more difficult: > insert a CONSTRAINT but if you update from 3.20.5 this CONSTRAINT > is just present. > > I don't find a similar situation in others parts of > installer/data/mysql/updatedatabase.pl > > I try a solution (check the presence of the CONSTRAINT using > information_schema.table_constraints) > but it doesn't work always. For example it doesn't work for Katrin. > > I don't know what to do now. > Do you have any idea about this topic ? > > Bye > Zeno Tajoli > _______________________________________________ > Koha-devel mailing list > [email protected] > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/ > _______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
