[Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB

[bugzilla-daemon at wilbur.katipo.co.nz]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=599





------- Additional Comments From paul.poulain at free.fr  2003-09-23 21:32 -------
A few hours of digging later...
MY opinion is that the imported datas were a little bit corrupted BEFORE
importing process.
Let me explain :
1 ----------------
try this request :
FROM marc_subfield_table, marc_biblio
LEFT JOIN items ON items.barcode = marc_subfield_table.subfieldvalue
WHERE tag = "952" AND subfieldcode = "p" AND items.biblionumber <>
marc_biblio.biblionumber AND marc_biblio.bibid = marc_subfield_table.bibid

("translation" of this request : search barcode in marc & non marc table, search
marc & non-marc biblio number, show those who are differents => those records
have a problem)
It gives me 87 results. It means that 87 items are connected to marc data X and
to non-marc data Y

to be continued soon >>>



------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.