Submissions count error?

[delfs]

Hi

We have a problem with our OJS 2.1.0-1 installation. When I view a particular journal as an editor it says "» Unassigned (50)" in overview, but when I get the unassigned listed, it says "1 - 0 of 11 Items. Section: all sections" in the bottom. The list tells me there's 11 as well, but why does it say 50 in Editor Home?
Other journals seems to display it correctly, but everywhere it says "x to 0 of y" - why always "to 0"?

We just upgraded from 2.0.2-1 to 2.1.0-1, and some of the articles might be from when we migrated from version 1.1. I know the problem also occured with 2.0.2, but I'm not sure about 1.1.
I've tried to run some queries manually to find out which of the numbers are correct, but can't completely figure out what to query for.

Any suggestions?

Best regards, Jonas

[delfs]

Btw - all the files of our installation is from the package as we would have as clean an installation as possible. The database was upgraded with the supplied SQL queries.

[asmecher]

Hi Jonas,

This sort of problem crops up when migrating from OJS 1.x to 2.x in cases where the 1.x data is inconsistent; check to make sure, for example, that all articles are assigned to sections. You can do this with the following SQL query in the OJS 2.x database:

Code: Select all

SELECT a.article_id FROM articles a LEFT JOIN sections s ON (a.section_id = s.section_id) WHERE s.section_id IS NULL;

If assigning these articles to sections does not correct the problem, please feel free to contact me directly at pkp-support@sfu.ca with specifics and I can examine further.

Regards,
Alec Smecher
Open Journal Systems Team

[delfs]

Hi all

Thanks to Alec the problem seems to be solved:
Submissions that don't have an editor assigned will be counted in the submissions count, but won't be listed as that isn't a valid situation in OJS 2.1 (it probably was in OJS 1.1, which is why we have some old articles without any editors assigned to it).
By adding an editor to each of the articles on the Summary page, the unassigned count decreases and the scheduling count increases.

Best regards, Jonas