[Koha-bugs] [Bug 4424] New: MARC Framework deletion incorrectly reports usage count

[bugzilla-daemon at kohaorg.ec2.liblime.com]

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4424

           Summary: MARC Framework deletion incorrectly reports usage count
           Product: Koha
           Version: HEAD
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P5
         Component: MARC Bibliographic data support
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: oleonard at myacpl.org
   Estimated Hours: 0.0
 Change sponsored?: ---


After creating a new framework based on an existing one, I immediately attempt
to delete it and get this message: "Delete framework for DVD Framework (DVD)?
This framework is used 312 times." I assume the meaning of this error is that
312 bibliographic records use the framework, which is impossible because no
records have been created using it.

On the koha-devel list Thomas Dukleth writes:

"If biblio_framework.pl line 94 is changed from:

my $sth = $dbh->prepare("select count(*) as total from marc_tag_structure
where frameworkcode=?");

to

my $sth = $dbh->prepare("select count(*) as total from `biblio` where
frameworkcode=?");

thus counting matching records in the biblio table instead of the
marc_tag_structure table, then all should be well."

I think this is correct: When deleting a framework the check should be for
existing records using that framework.


-- 
Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.