OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Browse by Author - a bug?

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.

Browse by Author - a bug?

Postby nef » Fri Jun 01, 2007 3:01 am

When I click the link Browse - By Author I get the following message:
DB Error: ERROR: Unable to identify an ordering operator '<' for type '"unknown"' Use an explicit ordering operator or modify the query

How do I fix that?

Regards,
Niels Erik
nef
 
Posts: 257
Joined: Fri Jun 01, 2007 2:56 am
Location: Aarhus, Denmark

Postby asmecher » Fri Jun 01, 2007 1:48 pm

Hi Niels,

Could you turn on the show_stacktrace option in config.inc.php, try again, and post the results here (camouflaging anything you deem private)? What DBMS are you using, and what version?

Regards,
Alec Smecher
Public Knowledge Project Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Postby nef » Fri Jun 08, 2007 12:07 am

asmecher wrote:Hi Niels,

Could you turn on the show_stacktrace option in config.inc.php, try again, and post the results here (camouflaging anything you deem private)? What DBMS are you using, and what version?

Regards,
Alec Smecher
Public Knowledge Project Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
nef
 
Posts: 257
Joined: Fri Jun 01, 2007 2:56 am
Location: Aarhus, Denmark

Browse author

Postby nef » Fri Jun 08, 2007 12:14 am

Hi Alec

Here's the result after turning the show_stacktrace on:

DB Error: ERROR: Unable to identify an ordering operator '<' for type '"unknown"' Use an explicit ordering operator or modify the query
Stack Trace:
File: /home/ojs/ojs-2.1.1/classes/article/AuthorDAO.inc.php line 134
Function: authordao->retrieverange("SELECT DISTINCT NULL AS url, NULL AS author_id, NULL AS article_...", Array(1), Object(dbresultrange))

File: /home/ojs/ojs-2.1.1/pages/search/SearchHandler.inc.php line 121
Function: authordao->getauthorsalphabetizedbyjournal("14", Null, Object(dbresultrange))

File: (unknown) line (unknown)
Function: searchhandler::authors(Array(0))

File: /home/ojs/ojs-2.1.1/index.php line 46
Function: call_user_func(Array(2), Array(0))

File: /home/ojs/ojs-2.1.1/index.php line 57
Function: handlerequest()

And our DBMS are: postgresql 7.3.19 (RHEL3)

Regards,
Niels Erik
nef
 
Posts: 257
Joined: Fri Jun 01, 2007 2:56 am
Location: Aarhus, Denmark

Postby asmecher » Fri Jun 08, 2007 1:54 pm

Hi Niels,

Try applying the patch at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=2907; please let me know if it corrects the problem.

Regards,
Alec Smecher
Public Knowledge Project Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Postby nef » Mon Jun 11, 2007 6:06 am

Hi Alec
Unfortunately the patch doesn't correct the problem. I still receive a stack trace, when I click Browse by author.

Regards,
Niels Erik
nef
 
Posts: 257
Joined: Fri Jun 01, 2007 2:56 am
Location: Aarhus, Denmark

Postby asmecher » Mon Jun 11, 2007 3:43 pm

Hi Niels,

This appears to be a problem specific to PostgreSQL < 7.4. Until we come up with a more platform-independent solution, try the second patch posted at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=2907 (attachment #208). You'll need to reverse the first patch by applying it with the -R option.

Regards,
Alec Smecher
Public Knowledge Project Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Postby nef » Mon Jun 11, 2007 11:55 pm

Hi Alec
Now it works.
Thank you.

Regards,
Niels Erik
nef
 
Posts: 257
Joined: Fri Jun 01, 2007 2:56 am
Location: Aarhus, Denmark


Return to OJS Technical Support

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 2 guests