OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Bug (OCS 2.3.3-1): Places where sorting doesn't work

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

Moderators: jmacgreg, michael, John

Forum rules
What to do if you have a technical problem with OCS:

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. Please note that this FAQ is OJS-centric, but most issues are applicable to both platforms.

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 OCS Conference Support and Discussion subforum; if you have a development question, try the OCS Development subforum.

Bug (OCS 2.3.3-1): Places where sorting doesn't work

Postby r2d2 » Sun Mar 27, 2011 9:45 am

In the following places, the sorting function does not work (or missing):

1. In Track Director's PRESENTATIONS and ARCHIVES tabs, when STATUS sorting is clicked, the following error is received:
DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 23

2. Under Conference Manager's Scheduler page, in "Schedule Presentations & Events" main page, when Sort by Track is clicked, we get the following error:
Fatal error: Call to undefined method Track::getTrackName() in ...\classes\manager\form\scheduler\ScheduleForm.inc.php on line 90

3. Reviewer's ACTIVE and ARCHIVE tabs do not have sort order functionality.
r2d2
 
Posts: 32
Joined: Fri Aug 28, 2009 1:36 pm

Re: Bug (OCS 2.3.3-1): Places where sorting doesn't work

Postby mcrider » Tue Apr 05, 2011 11:41 am

Hi r2d2,

Thanks, I've duplicated some of this behavior and posted a bug at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=6568. Feel free to add yourself to the CC list for that bug to receive updates.

Cheers,
Matt
mcrider
 
Posts: 952
Joined: Mon May 05, 2008 10:29 am
Location: Vancouver, BC

Re: Bug (OCS 2.3.3-1): Places where sorting doesn't work

Postby tantalocura » Thu Apr 28, 2011 8:18 pm

Hi Matt / r2d2
If I log as Director and list submissions ( .../director/submissions/submissionsUnassigned or .../director/submissions/submissionsInReview )
and sort them by ID, Date, Author or Title it's OK, it works fine; but trying to sort by Track results in :
DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 0,25' at line 27

Cheers, Luis.
tantalocura
 
Posts: 11
Joined: Mon Mar 07, 2011 7:00 pm


Return to OCS Technical Support

Who is online

Users browsing this forum: No registered users and 2 guests