Hi, I hope someone can help with two, related, problems. (1) Duplicate entries. When I am creating new catalogue entries, I often find I get a 'double' entry, so that I end up with a biblio record with holdings, and one without. I then have to go back and delete the extra entry, otherwise it shows up on catalogue searches as having 'no items' which is confusing for people using the catalogue. This happens when I'm accessing my Koha server via a network; when I have the chance to catalogue straight on to the server, it doesn't happen, so presumably it's a network issue, but can anyone suggest a way of avoiding this problem? (2) 'No title' records. A related problem - in the course of deleting some of the duplicate entries, I mistakenly deleted a couple of records which had items in the holdings, leaving me with some 'no title' records. My question is: how can I delete these 'no title' records, which have apparent items in holdings so are again confusing for people using the catalogue. Many thanks for any advice you can give. Kate Jones Library volunteer National Botanic Garden of Wales On 25/10/10 21:06, koha-request@lists.katipo.co.nz wrote:
Send Koha mailing list submissions to koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."
Today's Topics:
1. Cedarview Library (Marty) 2. Setting up for installation Koha 3.02 (Kevin Jones) 3. Re: Koha 3.2.0 released (Joann Ransom)
----------------------------------------------------------------------
Message: 1 Date: Mon, 25 Oct 2010 12:50:10 -0700 (PDT) From: Marty<ontariowolf64@yahoo.com> Subject: [Koha] Cedarview Library To: koha koha<koha@lists.katipo.co.nz> Message-ID:<455615.54996.qm@web62408.mail.re1.yahoo.com> Content-Type: text/plain; charset="iso-8859-1"
Hi Marie Jane,
I have managed to get Koha partially running again, meaning that it is fully functional, but for now it needs a manual entry in the terminal. I am waiting for somebody to come up with an answer. Basically it's exactly what I thought it was, but? so far no easy solution. Sigh. Life's never easy, is it?
Anyway, in case you need to work with it; After you have started the computer, open a terminal (click on the little foot at the left bottom, the top of the list is accessories, from there you can open a terminal, basically a text window)
In the terminal, type: sudo zebrasrv -D -f /etc/koha/koha-conf.xml (enter) (if it asks for a password, it will be: handsoff) Now it will work.
Hopefully I can get it fixed tomorrow, so you won't need this.
Marty
Hi Kate, Regarding (1): have you been using Internet Explorer when cataloguing? IE is unsupported for the staff interface and has been known to add duplicate biblios. Firefox is recommended. As for (2), the best solution would probably be to remove biblios with no items using MySQL. Emrys ________________________________ From: koha-bounces@lists.katipo.co.nz on behalf of Kate Jones Sent: Mon 25/10/2010 21:29 To: koha@lists.katipo.co.nz Subject: [Koha] problem with duplicate entries Hi, I hope someone can help with two, related, problems. (1) Duplicate entries. When I am creating new catalogue entries, I often find I get a 'double' entry, so that I end up with a biblio record with holdings, and one without. I then have to go back and delete the extra entry, otherwise it shows up on catalogue searches as having 'no items' which is confusing for people using the catalogue. This happens when I'm accessing my Koha server via a network; when I have the chance to catalogue straight on to the server, it doesn't happen, so presumably it's a network issue, but can anyone suggest a way of avoiding this problem? (2) 'No title' records. A related problem - in the course of deleting some of the duplicate entries, I mistakenly deleted a couple of records which had items in the holdings, leaving me with some 'no title' records. My question is: how can I delete these 'no title' records, which have apparent items in holdings so are again confusing for people using the catalogue. Many thanks for any advice you can give. Kate Jones Library volunteer National Botanic Garden of Wales On 25/10/10 21:06, koha-request@lists.katipo.co.nz wrote:
Send Koha mailing list submissions to koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."
Today's Topics:
1. Cedarview Library (Marty) 2. Setting up for installation Koha 3.02 (Kevin Jones) 3. Re: Koha 3.2.0 released (Joann Ransom)
----------------------------------------------------------------------
Message: 1 Date: Mon, 25 Oct 2010 12:50:10 -0700 (PDT) From: Marty<ontariowolf64@yahoo.com> Subject: [Koha] Cedarview Library To: koha koha<koha@lists.katipo.co.nz> Message-ID:<455615.54996.qm@web62408.mail.re1.yahoo.com> Content-Type: text/plain; charset="iso-8859-1"
Hi Marie Jane,
I have managed to get Koha partially running again, meaning that it is fully functional, but for now it needs a manual entry in the terminal. I am waiting for somebody to come up with an answer. Basically it's exactly what I thought it was, but? so far no easy solution. Sigh. Life's never easy, is it?
Anyway, in case you need to work with it; After you have started the computer, open a terminal (click on the little foot at the left bottom, the top of the list is accessories, from there you can open a terminal, basically a text window)
In the terminal, type: sudo zebrasrv -D -f /etc/koha/koha-conf.xml (enter) (if it asks for a password, it will be: handsoff) Now it will work.
Hopefully I can get it fixed tomorrow, so you won't need this.
Marty
Emrys Minnig wrote:
Kate Jones wrote:
(1) Duplicate entries. When I am creating new catalogue entries, I often find I get a 'double' entry, so that I end up with a biblio record with holdings, and one without. I then have to go back and delete the extra entry, otherwise it shows up on catalogue searches as having 'no items' which is confusing for people using the catalogue. This happens when I'm accessing my Koha server via a network; when I have the chance to catalogue straight on to the server, it doesn't happen, so presumably it's a network issue, but can anyone suggest a way of avoiding this problem?
Regarding (1): have you been using Internet Explorer when cataloguing? IE is unsupported for the staff interface and has been known to add duplicate biblios. Firefox is recommended.
I had the opportunity to look at someone's computer that was making duplicates a while ago, as well as create an unduplicated new record with my laptop on their network connection (thereby eliminating "network issue" - a cache doing something stupid, most likely). My current suspicion is that Google Toolbar (installed site-wide by their IT department) causing duplicates somehow, rather than IE8. Can anyone confirm or refute that? Sorry if this is now moot! -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Past Koha Release Manager (2.0), LMS programmer, statistician, webmaster. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha
My experience with duplicate records resulted from a colleague using an unmodified (and untoolbarred) version of IE7 -- not IE8 -- and I also can't entirely rule out network issues. I work in a school, so am always working within the constraints of proxies and content filters. Emrys ________________________________ From: koha-bounces@lists.katipo.co.nz on behalf of MJ Ray Sent: Thu 17/02/2011 10:57 To: koha@lists.katipo.co.nz Cc: kate.garnwen@virgin.net Subject: Re: [Koha] problem with duplicate entries Emrys Minnig wrote:
Kate Jones wrote:
(1) Duplicate entries. When I am creating new catalogue entries, I often find I get a 'double' entry, so that I end up with a biblio record with holdings, and one without. I then have to go back and delete the extra entry, otherwise it shows up on catalogue searches as having 'no items' which is confusing for people using the catalogue. This happens when I'm accessing my Koha server via a network; when I have the chance to catalogue straight on to the server, it doesn't happen, so presumably it's a network issue, but can anyone suggest a way of avoiding this problem?
Regarding (1): have you been using Internet Explorer when cataloguing? IE is unsupported for the staff interface and has been known to add duplicate biblios. Firefox is recommended.
I had the opportunity to look at someone's computer that was making duplicates a while ago, as well as create an unduplicated new record with my laptop on their network connection (thereby eliminating "network issue" - a cache doing something stupid, most likely). My current suspicion is that Google Toolbar (installed site-wide by their IT department) causing duplicates somehow, rather than IE8. Can anyone confirm or refute that? Sorry if this is now moot! -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Past Koha Release Manager (2.0), LMS programmer, statistician, webmaster. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha _______________________________________________ Koha mailing list http://koha-community.org <http://koha-community.org/> Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Emrys Minnig wrote:
My experience with duplicate records resulted from a colleague using an unmodified (and untoolbarred) version of IE7 -- not IE8 -- and I also can't entirely rule out network issues. I work in a school, so am always working within the constraints of proxies and content filters.
Right, I've been running around offices borrowing computers and I've tested the same process that caused a duplicate for someone else. I've tested on IE6 and IE8 and neither duplicated. Sadly, the only machine I found that still had IE7 was so slow that I didn't complete the process on it! (The javascript in the MARC editor thrashed it and then it crashed on the Add Item page.) But the person who reported the duplicate to me was using IE8. What's going on? Anyone else seen duplicated records? Can you tell if they duplicate before or after items are added? Please don't let this be a heisenbug! Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Past Koha Release Manager (2.0), LMS programmer, statistician, webmaster. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha
On Fri, Feb 18, 2011 at 8:19 AM, MJ Ray <mjr@phonecoop.coop> wrote:
Emrys Minnig wrote:
My experience with duplicate records resulted from a colleague using an unmodified (and untoolbarred) version of IE7 -- not IE8 -- and I also can't entirely rule out network issues. I work in a school, so am always working within the constraints of proxies and content filters.
Right, I've been running around offices borrowing computers and I've tested the same process that caused a duplicate for someone else. I've tested on IE6 and IE8 and neither duplicated. Sadly, the only machine I found that still had IE7 was so slow that I didn't complete the process on it! (The javascript in the MARC editor thrashed it and then it crashed on the Add Item page.)
But the person who reported the duplicate to me was using IE8. What's going on? Anyone else seen duplicated records? Can you tell if they duplicate before or after items are added?
We've had duplicated entries using Chrome, it was related to the use of the "back" button on the browser after saving a record and going back for a correction, and saving again. To+
I had at first suspected bad practise (misuse of the 'back' button) to be the cause of our duplicate entries problem in IE7, but then I tested it myself. Upon hitting the 'Save' button on the 'Add MARC Record' screen, two biblios would be created with no warning. It almost seemed as if the 'Save' button was receiving a slow double-click... Of course, this was with the first release candidate of Koha 3, so I'm not sure if that was a factor. Emrys ________________________________ From: koha-bounces@lists.katipo.co.nz on behalf of Tomas Cohen Arazi Sent: Fri 18/02/2011 13:16 To: MJ Ray Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] problem with duplicate entries On Fri, Feb 18, 2011 at 8:19 AM, MJ Ray <mjr@phonecoop.coop> wrote:
Emrys Minnig wrote:
My experience with duplicate records resulted from a colleague using an unmodified (and untoolbarred) version of IE7 -- not IE8 -- and I also can't entirely rule out network issues. I work in a school, so am always working within the constraints of proxies and content filters.
Right, I've been running around offices borrowing computers and I've tested the same process that caused a duplicate for someone else. I've tested on IE6 and IE8 and neither duplicated. Sadly, the only machine I found that still had IE7 was so slow that I didn't complete the process on it! (The javascript in the MARC editor thrashed it and then it crashed on the Add Item page.)
But the person who reported the duplicate to me was using IE8. What's going on? Anyone else seen duplicated records? Can you tell if they duplicate before or after items are added?
We've had duplicated entries using Chrome, it was related to the use of the "back" button on the browser after saving a record and going back for a correction, and saving again. To+ _______________________________________________ Koha mailing list http://koha-community.org <http://koha-community.org/> Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
"Emrys Minnig" <emrysminnig@varndean.co.uk> wrote:
I had at first suspected bad practise (misuse of the 'back' button) to be the cause of our duplicate entries problem in IE7, but then I tested it myself. Upon hitting the 'Save' button on the 'Add MARC Record' screen, two biblios would be created with no warning. It almost seemed as if the 'Save' button was receiving a slow double-click...
Of course, this was with the first release candidate of Koha 3, so I'm not sure if that was a factor.
The thick plottens! I've seen the two biblios created at the time that the item is added and it was IE8 on the latest Koha 3.2. So maybe it's something else in Windows between the browser and the network connection? I'll check Windows versions on the machines I've tested. Or maybe we're experiencing different Microsoft bugs. If only we could study the source code, adapt it to our needs and share it... :-( Regards, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Past Koha Release Manager (2.0), LMS programmer, statistician, webmaster. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha
Emrys Minnig schreef op vr 18-02-2011 om 15:22 [+0000]:
Of course, this was with the first release candidate of Koha 3, so I'm not sure if that was a factor.
A potential fix for this might be to send (and somehow track) an ID along with the request to prevent multiple requests being honoured. You could check your webserver logs to see if two requests were really sent. This would help isolate whether it's a browser or koha issue. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
Robin Sheat wrote:
Emrys Minnig schreef op vr 18-02-2011 om 15:22 [+0000]:
Of course, this was with the first release candidate of Koha 3, so I'm not sure if that was a factor.
A potential fix for this might be to send (and somehow track) an ID along with the request to prevent multiple requests being honoured.
You could check your webserver logs to see if two requests were really sent. This would help isolate whether it's a browser or koha issue.
Yes, I did that. Two requests were really sent. Sorry for forgetting to mention it. The odd thing is that the second requests were sent just before the "Add Item" request, which seems incomprehensible to me. This is why I was not inclined to change Koha to fix it, until/unless it becomes obvious that Koha is triggering the duplication somehow. But yes, I guess a once-only ID would solve this. Do we have something suitable in any of the perl modules we already use? I didn't find one on a quick look in CGI::Session. I'd still like to hear of other instances of this problem... Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. Past Koha Release Manager (2.0), LMS programmer, statistician, webmaster. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha
participants (5)
-
Emrys Minnig -
Kate Jones -
MJ Ray -
Robin Sheat -
Tomas Cohen Arazi