OAI not working OJS 3.2.1-1

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 @Tarcisio_Pereira,

See: OAI ListRecords report 'This record has been deleted.' in all articles

Regards,
Alec Smecher
Public Knowledge Project Team

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: https://github.com/pkp/pkp-lib/issues/6320
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