[Koha-devel] Re: [Koha] uninstalling

[Roger Horne]

On Thu 15 Apr, I wrote:

>[snip]
> Clicking on the title produced a partial display of the Marc entries:
>       
> 020 -INTERNATIONAL STANDARD BOOK NUMBER
> a International Standard Book Number 0406948291
> 
> 852 -LOCATION/CALL NUMBER
> k Call number prefix (NR) TB
>       
> [snip]
> [followed by a box containing]       
> 
> homebranch
> RH
> 
> "TB" stands for text book so the 852 line would seem to be wrong. (If I go
> to edit I am given a drop down box for that line with text book, law report
> etc.)

Further experiment shows that the error in the 852(k) line is *introduced*
by the Item Type Admin page (admin/itemtypes.pl ). Yesterday I got the
daemon to work at least partially and it found the biblio for the Perl
Cookbook at the Library of Congress and added it. But the 852k line was
still TB (ie text book). So I added another "type", BS (for brussells sprout
--- not I admit something usually found in libraries) and searched for the
Cookbook again. When I tried to edit it (aqui.simple/addbiblio.pl ) the 852
line contained text book and the drop down menu now included the item
brussells sprout. And that expression appears in table itemtypes.

But seeing how TB gets into the display is way beyond me. A couple of tables
show the Perl Cookbook:

select biblionumber,author,title from biblio;
+--------------+--------------------+----------------------------------------+
| biblionumber | author             | title                                  |
+--------------+--------------------+----------------------------------------+
|            1 | Gammie             | Tolley Yellow Tax Handbook             |
|            2 | Michael Thomas     | Stamp Duty Land Tax                    |
|            3 | Longrigg Higgins   | Family Breakdown and Trusts            |
|            4 | DuBois, Paul,      | MySQL Cookbook /                       |
|            5 | Petersen, Theo.    | Web development with Apache and Perl / |
|            6 | Christiansen, Tom. | Perl cookbook /                        |
+--------------+--------------------+----------------------------------------+
6 rows in set (0.00 sec)

mysql> select biblionumber,itemtype,isbn from biblioitems;
+------------------+----------+------------+
| biblionumber | itemtype | isbn       |
+--------------+----------+------------+
|            1 | NULL     | 0406939985 |
|            2 | TB       | 0521545153 |
|            3 | TB       | 0406948291 |
|            4 | NULL     | 0596001452 |
|            5 | NULL     | 1930110065 |
|            6 | NULL     | 1565922433 |
+------------------+----------+------------+
6 rows in set (0.00 sec)

The 852 line still shows as TB although the itemtype line in the table is
NULL. It has somehow found its way into marc_subfield_table:

select subfieldid,bibid,tag,subfieldcode,subfieldvalue 
    from marc_subfield__table where bibid='6';
+------------+-------+-----+--------------+------------------------+
| subfieldid | bibid | tag | subfieldcode | subfieldvalue          |
+------------+-------+-----+----+----------------------------------+
|         89 |     6 | 010 | a  |    99176053                      |
|         90 |     6 | 020 | a  | 1565922433                       |
|         91 |     6 | 035 | a  | (DLC)   99176053                 |
|         92 |     6 | 035 | a  | (OCoLC)39872119                  |
|         93 |     6 | 852 | k  | TB                               |
|         94 |     6 | 100 | a  | Christiansen, Tom.               |
|         95 |     6 | 245 | a  | Perl cookbook /                  |
|         96 |     6 | 260 | c  | c1998.                           |
|         97 |     6 | 300 | a  | xxxiv, 757 p. ;                  |
|         98 |     6 | 300 | c  | 24 cm.                           |
|         99 |     6 | 650 | a  | Perl (Computer program language) |
|        100 |     6 | 650 | a  | Perl (Computer program language) |
|        101 |     6 | 090 | c  | 6                                |
|        102 |     6 | 090 | d  | 6                                |
|        103 |     6 | 952 | b  | RH                               |
|        104 |     6 | 952 | d  | RH                               |
|        105 |     6 | 952 | u  | 5                                |
+------------+-------+-----+--------------+------------------------+
17 rows in set (0.00 sec)

Have 852 and 952 got mixed up somewhere? (RH, ie Roger Horne, is what I
would have expected to see in "location" on a search.)

But it turns out to be more complicated ... On a simple search the location
of the Perl Cookbook shows correctly as Roger Horne (although it doesn't in
a Marc search). But the location of the Mysql Cookbook doesn't show as Roger
Horne in a simple search but as a blank (but shows as TB in a full search).
There are very small differences in the marc_subfield_table but nothing that
would appear to cause this:

+------------+-------+-----+--------------+----------------------------------------+
| subfieldid | bibid | tag | subfieldcode | subfieldvalue                       
   |
+------------+-------+-----+--------------+----------------------------------------+
|         69 |     5 | 010 | a            |   2002281940                        
   |
|         70 |     5 | 020 | a            | 1930110065                          
   |
|         71 |     5 | 035 | a            | (OCoLC)ocm49871541                  
   |
|         72 |     5 | 852 | k            | TB                                  
   |
|         73 |     5 | 100 | a            | Petersen, Theo.                     
   |
|         74 |     5 | 245 | a            | Web development with Apache and 
Perl / |
|         75 |     5 | 260 | c            | c2002.                              
   |
|         76 |     5 | 300 | a            | xviii, 410 p. :                     
   |
|         77 |     5 | 300 | b            | ill. ;                              
   |
|         78 |     5 | 300 | c            | 24 cm.                              
   |
|         79 |     5 | 650 | a            | Perl (Computer program language)    
   |
|         80 |     5 | 650 | a            | Web site development.               
   |
|         81 |     5 | 650 | a            | Open source software.               
   |
|         82 |     5 | 650 | a            | Open source software.               
   |
|         83 |     5 | 090 | c            | 5                                   
   |
|         84 |     5 | 090 | d            | 5                                   
   |
|         85 |     5 | 952 | u            | 3                                   
   |
|         86 |     5 | 952 | b            | RH                                  
   |
|         87 |     5 | 952 | d            | RH                                  
   |
|         88 |     5 | 952 | u            | 4                                   
   |

Roger
-- 
Roger Horne, 11 New Square, Lincoln's Inn, London WC2A 3QB
mailto:address@hidden