[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB
From: |
bugzilla-daemon |
Subject: |
[Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB |
Date: |
23 Sep 2003 09:32:07 -0000 |
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=599
------- Additional Comments From address@hidden 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.
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/09
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/11
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/11
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/12
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/12
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB,
bugzilla-daemon <=
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/23
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/26
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/26
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/26
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/26
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/30
- [Koha-bugs] [Bug 599] edited items are stored incorrectly in old Koha DB, bugzilla-daemon, 2003/09/30