Hi
OAI is not working well, list records is just listing deleted articles.
OAI URL: https://www.revistas.usp.br/sausoc/oai?verb=ListRecords&metadataPrefix=oai_dc
Maybe it’s a search related problem? The search is not working also.
Regards,
Tarcisio Pereira
Hi @asmecher
Yes, the OAI is enable Settings > Distribution > Access.
But just listing the deleted articles.
Regards,
Tarcisio Pereira
Hi @Tarcisio_Pereira,
Have you enabled the DRIVER plugin?
Regards,
Alec Smecher
Public Knowledge Project Team
Hi @asmecher
No. It was not enabled.
Now I enabled the DRIVER plugin, but still listing deleted ones only.
Regards,
Tarcisio Pereira
1 Like
Hi @asmecher
I change the line 235 in file ‘classes/oai/ojs/OAIDAO.inc.php’ from:
JOIN issues i ON (CAST(i.issue_id AS CHAR) = psissue.setting_value)
to:
JOIN issues i ON (CAST(i.issue_id AS TEXT) = psissue.setting_value)
Now the OAI is working again, but I don’t know if this change is ok.
Regards,
Tarcisio Pereira
Hi @Tarcisio_Pereira,
Thanks for tracking this down! I believe it’s already filed here: [OJS] CAST AS CHAR i postgres · Issue #6320 · pkp/pkp-lib · GitHub
I’ll need to double-check whether that syntax works for MySQL – please watch that issue for updates.
Thanks,
Alec Smecher
Public Knowledge Project Team
1 Like
Hi @Tarcisio_Pereira/all,
I’ve posted some pull requests that should resolve this over at pkp/pkp-lib#6320. I’ve tested it locally with my sample data set but confirmation on real-world data would be very welcome!
Thanks,
Alec Smecher
Public Knowledge Project Team
Hi,
could not reproduce that on OJS-3.2.1-2 and OAI-PMH is working fine on our installation.
Is this patch only for installation that use PostgreSQL?
Thanks, Martin
Hi @mpbraendle,
Sorry, I should have specified – yes, this is only expected to affect PostgreSQL users.
Regards,
Alec Smecher
Public Knowledge Project Team
ty @asmecher.
Upgraded our test installation(multi-lang/multi-journal) to OJS 3.2.1.-2 today, looks fine and works fluently, after final test soon migration of our production platform.
1 Like
Hi @asmecher
Looks ok.
Tested and your solution is faster than mine.
Regards,
Tarcisio Pereira
Hi @Tarcisio_Pereira,
Great, this is committed for the next release – and thanks for tracking down the original problem!
Regards,
Alec Smecher
Public Knowledge Project Team
1 Like
Hi @asmecher
The page (oai?verb=ListRecords&metadataPrefix=oai_dc) of my journal is entirely blank, it is showing nothing. Please help me to solve this problem.
I am using OJS 3.3.0.5