You are viewing the PKP Support Forum | PKP Home Wiki

Submissions count error?

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

Submissions count error?

Postby delfs » Tue Apr 04, 2006 1:03 am


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
Posts: 3
Joined: Tue Apr 04, 2006 12:42 am

Postby delfs » Tue Apr 04, 2006 1:24 am

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.
Posts: 3
Joined: Tue Apr 04, 2006 12:42 am

Postby asmecher » Tue Apr 04, 2006 10:27 am

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.

Alec Smecher
Open Journal Systems Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Answer to problem

Postby delfs » Fri Apr 07, 2006 2:19 am

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
Posts: 3
Joined: Tue Apr 04, 2006 12:42 am

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot] and 3 guests