Bug 8394 - No physical item for this record on records after mysqldump and zebra rebuild
Summary: No physical item for this record on records after mysqldump and zebra rebuild
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: 3.8
Hardware: All Linux
: P2 trivial (vote)
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on: 8393
Blocks:
  Show dependency treegraph
 
Reported: 2012-07-09 15:12 UTC by Eugene Espinoza
Modified: 2014-12-07 20:02 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eugene Espinoza 2012-07-09 15:12:25 UTC
In the OPAC interface as well as Normal interface for catalog holdings, 'There are no physical items for this record' is shown even though there is/are item/s for that record. If in Edit Items, the items are there.
Comment 1 Katrin Fischer 2012-07-09 15:45:03 UTC
Hi, I think this bug and 8393 are probably related and maybe not bugs, but some problem in your configuration. Which version of Koha are you using? Did you update from an earlier version or is this a new installation and the first imports you are doing? Can you provide a sample 952 for one of your items?
Comment 2 Eugene Espinoza 2012-07-09 16:15:46 UTC
I am using Kyle Hall's virtual machine of Koha 3.8.1. For this reported 8394 bug (?), I actually mysqldump my previous mysql data from 3.6. I did not incur problems with regards to missing items or no physical items for records in my koha 3.6 machine (kyle hall's virtual machine) which were imported from 3.2. Here is by the way the 952 field: =952  \\$w2011-10-24$p033073hp$r2011-10-24$40$00$6F__KPM_00041_W55_W54_2000$915302$bLLS$10$o(F) KPM 41 W55 W54 2000$d2002-12-10$70$cGEN$2lcc$g695.00$yBK$aLLS$iMR_02 1177; MD_$kR_; PO_; PD 00668
Comment 3 Eugene Espinoza 2012-07-26 02:35:44 UTC
This problem already solve. What I did was to drop the koha database and then import my previous database (koha 3.6). What I did previously was to just overwrite (?) existing original koha database with mysqldump of my backup database. And when I run zebra rebuilds items were showing up. Is there a way that overwriting of original koha mysql database by previous mysqldump won't affect items not showing up?