Software Hosting and Development Services available at PKP Publishing Services
As the developers of Open Journal Systems, Open Conference Systems, Open Harvester Systems, and Open Monograph Press, the PKP team are experts in helping journal managers and conference organizers make the most of their online publishing projects. PKP Publishing Services offers support for:
As a customer of PKP Publishing Services, you will not only receive direct, personalized support from the PKP Development Team, but will be contributing to the ongoing development of the PKP applications. All funds raised by PKP Publishing Services go directly toward enhancing our free, open source software. For more information, please contact us.
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.
by 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 5423Stack 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()
-
ponsfrilus
-
- Posts: 44
- Joined: Fri Jun 05, 2009 7:46 am
- Location: Switzerland
by 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
-
asmecher
-
- Posts: 5769
- Joined: Wed Aug 10, 2005 12:56 pm
-
by ponsfrilus » Wed May 12, 2010 1:43 am
Thank you
-
ponsfrilus
-
- Posts: 44
- Joined: Fri Jun 05, 2009 7:46 am
- Location: Switzerland
Return to OCS Technical Support
Who is online
Users browsing this forum: No registered users and 1 guest
