Article appears repeted with the same ID

Software Support
1

I am working on OJS 2.4.8.1. I have several articles that are in a review process that appear repeted on the list, one example is the following:
imagen

Does anyone have an idea of why this could happen?

2

Hi @jose.galeano,

What version of OJS is this? (Please include this in your posts.)

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi, I have included the version on the question. OJS 2.4.8.1

4

Hi @jose.galeano,

The likeliest cause of this is a data error, probably some database rows that OJS doesn’t expect to be there. Unfortunately there are a lot of joins so it’s difficult to speculate about what is causing this from here. If you’re handy with SQL, the query in question is in classes/submission/editor/EditorSubmissionDAO.inc.php in the _getUnfilteredEditorSubmissions function; I’d suggest capturing the exact query e.g. using a database query log (outside of OJS) or the debug option in config.inc.php and exploring why there are duplicate rows served.

If I were to take a guess, I’d think you might have several authors designated with primary_contact=1 for this article in the authors table. There can be only one.

Regards,
Alec Smecher
Public Knowledge Project Team