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 Koha-devel@lists.koha-community.org 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/