[Koha-bugs] [Bug 23696] build_oai_sets.pl should take biblios from deletedbiblio_metadata too

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23696

--- Comment #5 from Josef Moravec <josef.moravec at gmail.com> ---
(In reply to Katrin Fischer from comment #4)
> This patch appears pretty straight-forward and it works for me, but I am
> having trouble with rerunning the script:
> 
> 1) On running the script a second time, I get a lot of errors:
> DBD::mysql::st execute failed: Duplicate entry '50-1' for key 'PRIMARY' [for
> Statement "
>         INSERT INTO oai_sets_biblios (set_id, biblionumber)
>         VALUES (?,?)
>     " with ParamValues: 0='1', 1=50] at
> /home/vagrant/kohaclone/C4/OAI/Sets.pm line 597.
> DBD::mysql::st execute failed: Duplicate entry '52-1' for key 'PRIMARY' [for
> Statement "
>         INSERT INTO oai_sets_biblios (set_id, biblionumber)
>         VALUES (?,?)
>     " with ParamValues: 0='1', 1=52] at
> /home/vagrant/kohaclone/C4/OAI/Sets.pm line 597.


Hi Katrin, thanks for testing!

when you are running this script more than once, you need to add -r parameter -
it will clean the table before generating it again.


> 
> 2) Also the links for Metadata and Set don't appear to work in our HTML
> representation of the OAI-Server:
> 
> /cgi-bin/koha/oai.pl?verb=ListRecords&metadataPrefix=oai_dc&set=TEST

Can you add more details to this question?

> 
> 3) Even without the patch and after rerunning the script reporting 45
> records (instead of the 46 it should have), I still can see a deleted record
> in the web output of the set.

The access to records are not limited by set, you can use OAI without set
parameter in Koha. And it is OK, because set is optional by standard:
http://www.openarchives.org/OAI/openarchivesprotocol.html#Set

-- 
You are receiving this mail because:
You are watching all bug changes.