incomplete lists of submissions assigned to 'Me'

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.
elt
Posts: 9
Joined: Tue Aug 20, 2013 1:34 pm

incomplete lists of submissions assigned to 'Me'

Postby elt » Wed May 07, 2014 8:52 am

Hi, we recently upgraded from 2.3.8 to 2.4.3. I used the patch file, and the web-based script for the database; the upgrade went well, and no errors were reported.
Since the upgrade, on the User > Editor > Submissions page, lists of submissions (either in Review or in Editing) assigned to 'Me' are either empty or incomplete. We have editors who have multiple roles: some are also Section Editors, some are also Journal Managers, some are also Copy Editors, etc. etc., and most articles are assigned to more than one editor. I can't find any common configuration of roles and assignments which explains why one article gets listed and other doesn't. However, I did notice that the edit_assignments table is joined three times in the SQL generated by EditorSubmissionsDAO.inc.php, first with a table alias of 'e', then with an alias of 'ea' and finally with an alias of 'ea2'. Currently line 326 of EditorSubmissionDAO.inc.php has:
$searchSql .= ' AND ea.editor_id = ?';
If this is changed to
$searchSql .= ' AND e.editor_id = ?';
then I seem to get accurate results. But would this change break something else ? Maybe the real problem lies elsewhere?
We are using mySQL 5.0 and PHP 5.1.6 on RHEL5.9
Many thanks for any suggestions you can offer!

asmecher
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm
Contact:

Re: incomplete lists of submissions assigned to 'Me'

Postby asmecher » Wed May 07, 2014 9:02 am

Hi elt,

I suspect this is bug #8595, which is fixed in OJS 2.4.4.

Regards,
Alec Smecher
Public Knowledge Project Team

elt
Posts: 9
Joined: Tue Aug 20, 2013 1:34 pm

Re: incomplete lists of submissions assigned to 'Me'

Postby elt » Wed May 07, 2014 9:31 am

Great! So I can make a patch to apply the change mentioned in comment 11 : http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=8595#c11 and that should fix it.
Many thanks for the fast reply!


Return to “OJS Technical Support”

Who is online

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