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’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
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?