[Koha-bugs] [Bug 20280] Authorised value categories list in bibliographic frameworks has 2 empty entries

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20280

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart at bugs.koha-c
                   |                            |ommunity.org

--- Comment #1 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
installer/data/mysql/mandatory/auth_val_cat.sql:
  1 INSERT IGNORE INTO authorised_value_categories( category_name )
  2     VALUES
  3     (''),

but installer/data/mysql/updatedatabase.pl:
13164     INSERT IGNORE INTO authorised_value_categories( category_name )
13165     VALUES
13166     ('Asort1'),

"" is missing


Moreover:
  commit 62aa3f4292d83bc9304e296de5f0830e28510492
    Bug 17216: Use Koha::AVC from mss.pl
Added this additional blank entry in the template:
+                                <option value=""></option>

Additional info, in admin/authorised_values.pl we have:
215     my @categories = Koha::AuthorisedValueCategories->search({
category_name => { -not_in => ['', 'branches', 'itemtypes', 'cn_source']}}, {
order_by => ['category_name'] } );

So maybe a solution could be to:
- remove all the additional entries in template (if there are others than in
admin/marc_subfields_structure.tt)
- the add the AV category "" to existing install (unless it already exists)

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