There are several active submissions but not visible all are listed

[kakung_mas]

Hello…
We successfully upgraded Open Journal Systems 2.4.8.5 to Open Journal Systems 3.3.0.14, but there was a problem that the total active submissions were not the same as shown.

It looks like the image below. Is the solution we can do?
There are 17 active submissions but only 8 are visible.
Thanks sir.

[asmecher]

Hi @kakung_mas,

It’s likely that there are inconsistencies in your database that are leading to the mismatch. I would suggest starting with the following database query:

SELECT p.submission_id, p.section_id FROM publications p LEFT JOIN sections s ON (p.section_id = s.section_id) WHERE s.section_id IS NULL;

If you get results, it indicates that there are submissions in your system that are registered against sections that have been deleted.

Regards,
Alec Smecher
Public Knowledge Project Team

[kakung_mas]

@asmecher

SELECT p.submission_id, p.section_id FROM publications p LEFT JOIN sections s ON (p.section_id = s.section_id) WHERE s.section_id IS NULL;

Thanks sir, I will try to check it,
The results of the above query do not produce any information

[asmecher]

Hi @kakung_mas,

In your OJS 2.x installation, were the “missing” submissions shown in your submission lists?

Regards,
Alec Smecher
Public Knowledge Project Team

[kakung_mas]

Sorry sir, I didn’t pay attention in detail to whether any submission articles were missing. I discovered this condition after upgrading from OJS 2 to OJS 3.
Is there a way or query to search for lost submitted articles?

[kakung_mas]

In the web browser’s inspect element it looks like this