Bug 16564

Summary: New Patron Category cannot be created. Bounces with error: 'The Category might already exist'.
Product: Koha Reporter: Gopalakrishna <gk.bmsit>
Component: System AdministrationAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: blocker    
Priority: P5 - low CC: bgkriegel, dpavlin, gmcharlt, jonathan.druart, magnus
Version: 3.22   
Hardware: HP   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Patron Category Administration

Description Gopalakrishna 2016-05-22 08:43:24 UTC
Created attachment 51696 [details]
Patron Category Administration

OS: lubuntu 16.04
Koha: 3.22.06
System: HP Desktop
Mysql: 5.7

On creating a new pattern category, though no category exists, bounces with an error message - 'An error occured when inserting this pattern category.  The patron category might already exist.'
Comment 1 Gopalakrishna 2016-05-23 05:10:29 UTC
There is a need to check the kohastructure.sql thoroughly to comply with MySql 5.7
Comment 2 Magnus Enger 2016-05-23 07:38:47 UTC
Could this be a duplicate of bug 16402?
Comment 3 Bernardo Gonzalez Kriegel 2016-05-24 02:29:27 UTC
See Bug 16572 and Bug 16573
Comment 4 Jonathan Druart 2016-05-26 10:43:04 UTC
Cannot recreate on master and 3.22.06 (I do not have MySql 5.7)
Comment 5 Katrin Fischer 2016-06-09 05:41:46 UTC
I can confirm this problem. It goes away if you deactivate all the modes - so tihs is a duplicate to bug 16584 I think.

*** This bug has been marked as a duplicate of bug 16584 ***