You are viewing the PKP Support Forum | PKP Home Wiki

Search fails - p.title ref fails in published paper search

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.

Search fails - p.title ref fails in published paper search

Postby spatialguru » Wed Jul 09, 2008 12:28 pm

Can seem to find any reference to this in the form or bugzilla. This is for a recent OCS 2.1 upgraded site.

From the schedConf/presentations page, I do a search and it give this error:

Code: Select all
DB Error: Unknown column 'p.title' in 'where clause'

I've search high and low in the database and can't seem to find the table that class/paper/PublishedPaperDAO.inc.php should refer to instead. I certainly don't see a papers.title item in the db. :)

For a live example, see this site. Sidebar searching tool works like a charm though!

Any ideas?

Posts: 112
Joined: Mon Jun 25, 2007 1:23 pm
Location: British Columbia, Canada

Re: Search fails - p.title ref fails in published paper search

Postby mcrider » Wed Jul 09, 2008 3:40 pm

Hi Tyler,

I can confirm the same behavior and I started a BugZilla entry at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=3667. Nice catch!

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

Return to OCS Technical Support

Who is online

Users browsing this forum: No registered users and 1 guest