OAI not working OJS 3.2.1-1

Software Support
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

2

Hi @Tarcisio_Pereira,

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

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi @asmecher

Yes, the OAI is enable Settings > Distribution > Access.
But just listing the deleted articles.

Regards,
Tarcisio Pereira

4

Hi @Tarcisio_Pereira,

Have you enabled the DRIVER plugin?

Regards,
Alec Smecher
Public Knowledge Project Team

5

Hi @asmecher

No. It was not enabled.
Now I enabled the DRIVER plugin, but still listing deleted ones only.

Regards,
Tarcisio Pereira

1 Like
6

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

7

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
8

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

9

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

10

Hi @mpbraendle,

Sorry, I should have specified – yes, this is only expected to affect PostgreSQL users.

Regards,
Alec Smecher
Public Knowledge Project Team

11

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
12

Hi @asmecher

Looks ok.
Tested and your solution is faster than mine.

Regards,
Tarcisio Pereira

13

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
14

How to Solved it

15

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