[Koha-devel] Help about bug 15207

[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