ORDER BY ASC LIMIT 0,25 Bug3

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
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.
ponsfrilus
Posts: 44
Joined: Fri Jun 05, 2009 7:46 am
Location: Switzerland

ORDER BY ASC LIMIT 0,25 Bug3

Postby ponsfrilus » Tue May 11, 2010 6:28 am

Code: Select all

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


appears when sorting paper ny tacks in conference management ocs 2.3.1.

See bug 5423


Stack trace:

Code: Select all

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

Stack Trace:

File: /var/www/ocs23/classes/submission/director/DirectorSubmissionDAO.inc.php line 279
Function: DAO->retrieveRange("SELECT DISTINCT p.*, COALESCE(ptl.setting_value, pptl.se...", Array(13), Object(DBResultRange))

File: /var/www/ocs23/classes/submission/director/DirectorSubmissionDAO.inc.php line 354
Function: DirectorSubmissionDAO->_getUnfilteredDirectorSubmissions("1", 0, 0, "3", "contains", "", Null, Null, Null, "p.status = 1 AND ea.edit_id IS NOT NULL", Object(DBResultRange), "track", "1")

File: /var/www/ocs23/pages/director/DirectorHandler.inc.php line 160
Function: DirectorSubmissionDAO->getDirectorSubmissionsInReview("1", 0, 0, "3", "contains", "", Null, Null, Null, Object(DBResultRange), "track", "1")

File: /var/www/ocs23/lib/pkp/classes/core/PKPPageRouter.inc.php line 177
Function: DirectorHandler->submissions(Array(1), Object(Request))

File: /var/www/ocs23/lib/pkp/classes/core/Dispatcher.inc.php line 130
Function: PKPPageRouter->route(Object(Request))

File: /var/www/ocs23/lib/pkp/classes/core/PKPApplication.inc.php line 170
Function: Dispatcher->dispatch(Object(Request))

File: /var/www/ocs23/index.php line 65
Function: PKPApplication->execute()

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

Re: ORDER BY ASC LIMIT 0,25 Bug3

Postby asmecher » Tue May 11, 2010 11:05 am

Hi ponsfrilus,

See the Bugzilla entry for a patch to correct.

Regards,
Alec Smecher
Public Knowledge Project Team

ponsfrilus
Posts: 44
Joined: Fri Jun 05, 2009 7:46 am
Location: Switzerland

Re: ORDER BY ASC LIMIT 0,25 Bug3

Postby ponsfrilus » Wed May 12, 2010 1:43 am

Thank you :!:


Return to “OCS Technical Support”

Who is online

Users browsing this forum: No registered users and 2 guests