[Koha-bugs] [Bug 15207] Error on upgrade from 3.20.5 to 3.22 beta

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15207

--- Comment #3 from Zeno Tajoli <z.tajoli at cineca.it> ---
The second error is present because the update 3.21.00.027 starts so:

dbh->do(q|
        INSERT INTO permissions (module_bit, code, description)
        VALUES (1, 'self_checkout', 'Perform self checkout at the OPAC. It
should be used for the patron matching the AutoSelfCheckID')
    |);

But in 3.20.5 in file  installer/data/mysql/en/mandatory/userpermissions.sql I
see: 

INSERT INTO permissions (module_bit, code, description) VALUES
[...]   
( 1, 'self_checkout', 'Perform self checkout at the OPAC. It should be used for
the patron matching the AutoSelfCheckID'),

So in 3.20.x the code 'self_checkout' could be present.

I don't know if it is better to 'INSERT IGNORE' or other statement.
A discussion on the topic here:
http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update

Tecnaly speaking also this error is not blocking, the code 'self_checkout' is
present in the table permissions with a correct value.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.