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

            Bug ID: 13534
           Summary: Deleting staff member who moderated a tag removes tags
                    imcompletely
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: OPAC
          Assignee: oleon...@myacpl.org
          Reporter: katrin.fisc...@bsz-bw.de
        QA Contact: testo...@bugs.koha-community.org

I am trying to wrap my mind around the table structure, but what happens is:

If you add a tag, it will be in tags_all and tags_approval.

tags_approval has a column approved_by, that is linked to the staff patron who
moderated the tag. 

If the staff patron is deleted, the entry in tags_approval is also deleted, but
tags_all remains.

The tag vanishes from the tag moderation tool and from the OPAC.

http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/kohastructure.sql;hb=b4e843615a76d3a9a8516f82a2ebad96aa9c4d1a#l2268

This doesn't feel like intended behaviour. 

I think it maybe it would make sense to set the borrowernumber to NULL when the
staff patron is deleted.

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to