OAI Error for Validation

http://www.openarchives.org/Register/ValidateSite?log=IW3HSOK1

It seems that there are bad characters (character 0) in your metadata
that are not being handled by PKP and make the XML response invalid.
(You can see this in the xmllint output below at line 206.)

Cheers,
Simeon

simeon@RottenApple ~> wget
http://scholarshub.net/index.php/ijcms/oai?verb=ListRecords&metadataPrefix=oai_dc
–2020-05-14 08:14:09–
http://scholarshub.net/index.php/ijcms/oai?verb=ListRecords&metadataPrefix=oai_dc
Resolving scholarshub.net (scholarshub.net)… 166.62.28.145
Connecting to scholarshub.net (scholarshub.net)|166.62.28.145|:80…
connected.
HTTP request sent, awaiting response… 200 OK
Length: unspecified [text/xml]
Saving to: ‘oai?verb=ListRecords&metadataPrefix=oai_dc’

oai?verb=ListRecord [ <=> ] 301.91K 154KB/s in
2.0s

2020-05-14 08:14:15 (154 KB/s) -
‘oai?verb=ListRecords&metadataPrefix=oai_dc’ saved [309158]

simeon@RottenApple ~> xmllint
oai?verb=ListRecords&metadataPrefix=oai_dc
oai?verb=ListRecords&metadataPrefix=oai_dc:206: parser error : Char 0x0
out of allowed range
terest expenses, Operating expenses, Assets) and four output variables
advances

^
oai?verb=ListRecords&metadataPrefix=oai_dc:206: parser error : Premature
end of data in tag description line 206
terest expenses, Operating expenses, Assets) and four output variables
advances

^
oai?verb=ListRecords&metadataPrefix=oai_dc:206: parser error : Premature
end of data in tag dc line 195
terest expenses, Operating expenses, Assets) and four output variables
advances

^
oai?verb=ListRecords&metadataPrefix=oai_dc:206: parser error : Premature
end of data in tag metadata line 194
terest expenses, Operating expenses, Assets) and four output variables
advances

^
oai?verb=ListRecords&metadataPrefix=oai_dc:206: parser error : Premature
end of data in tag record line 188
terest expenses, Operating expenses, Assets) and four output variables
advances

^
oai?verb=ListRecords&metadataPrefix=oai_dc:206: parser error : Premature
end of data in tag ListRecords line 9
terest expenses, Operating expenses, Assets) and four output variables
advances

^
oai?verb=ListRecords&metadataPrefix=oai_dc:206: parser error : Premature
end of data in tag OAI-PMH line 3
terest expenses, Operating expenses, Assets) and four output variables
advances

Hi @drarifanjum,

This is caused by invalid UTF-8 characters in the database, in particular the binary null character in place of ampersands. I’m not sure where these came from – perhaps a batch import or transcoded database? – but they’ll need to be corrected in the database.

Regards,
Alec Smecher
Public Knowledge Project Team

Dear Sir,

Please guide me to solve this problem.

Regards,
Dr. Arif

Hi @drarifanjum,

This is more of a database administration issue than an OJS issue, so you might have better luck on StackOverflow.com – but off the top of my head, you could dump your database to a file (using mysqldump), then use grep to detect invalid sequences. These can be manually corrected in the database dump, then the dump can be reloaded into MySQL.

Regards,
Alec Smecher
Public Knowledge Project Team