OJS OCS OMP OHS

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
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Submissions count error?

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

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
 
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.
delfs
 
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.

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 7737
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
delfs
 
Posts: 3
Joined: Tue Apr 04, 2006 12:42 am


Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 4 guests