[Koha-bugs] [Bug 2082] New: Duplicate authority keeps records from being searched

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2082 Summary: Duplicate authority keeps records from being searched Product: Koha Version: unspecified Platform: PC URL: http://66.213.124.205:443/cgi- bin/koha/authorities/authorities-home.pl OS/Version: All Status: NEW Severity: normal Priority: P3 Component: MARC Authority data support AssignedTo: galen.charlton@liblime.com ReportedBy: drdrulm@yahoo.com QAContact: koha-bugs@lists.koha.org In our catalog (DevWeek/Zoom) if one searches on PERSONAL NAME saums we get an error. In the MySQL database we have several Saums records and at least 2 are an exact copy. The duplicate may be jamming up the search/indexing/editing. We get the 500 error on this. select * from auth_header where marc LIKE "%Saums%" Gives duplicates: "100098590403" "PNAME" "2007-05-01" \N \N \N "00097 a2200061 4500001001200000001001300012152001000025Saums, Mary100098590403 bPNAME" \N \N "0000-00-00 00:00:00" "100098590404" "PNAME" "2007-05-01" \N \N \N "00125 a2200073 4500001001200000100001600012001001300028152001000041Saums, Mary aSaums, Mary100098590404 bPNAME" \N \N "0000-00-00 00:00:00" "100098590405" "PNAME" "2007-05-01" \N \N \N "00102 a2200061 4500100001700000001001300017152001000030 aSaums, Mary.100098590405 bPNAME" \N \N "0000-00-00 00:00:00" "100098590406" "PNAME" "2007-05-01" \N \N \N "00101 a2200061 4500100001600000001001300016152001000029 aSaums, Mary100098590406 bPNAME" \N \N "0000-00-00 00:00:00" "100098590410" "PNAME" "2007-05-02" \N \N \N "00102 a2200061 4500100001700000001001300017152001000030 aSaums, Mary.100098590410 bPNAME" \N \N "0000-00-00 00:00:00" "100098594901" "PNAME" "2008-04-30" \N \N \N "00101 a2200061 4500100001600000001001300016152001000029 aSaums, Mary100098594901 bPNAME" \N \N "0000-00-00 00:00:00" Thanks ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.