You are viewing the PKP Support Forum | PKP Home Wiki

Error: Unknown column 'fkIssueID' in 'on clause'

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.

Error: Unknown column 'fkIssueID' in 'on clause'

Postby php340 » Tue Jun 26, 2007 2:18 pm

The search page return this message:
Unknown column 'fkIssueID' in 'on clause'

Code: Select all
      $sql = "SELECT nArticleID, chMetaTitle, chTitle, nIssueID, nVolume, nNumber, nYear, a.dtDatePublished,
      dtDateHTMLGalleyCreated, dtDatePDFGalleyCreated, fkFilePDFID,
      dtDatePostScriptGalleyCreated, fkFilePostScriptID,
      bContentsLinkPage, fkPublishStatusID
      FROM tblarticles AS a, tblsections AS s
      LEFT JOIN tblissues AS i ON fkIssueID=nIssueID
      WHERE fkSectionID=nSectionID AND a.bPublished='1' AND ($where)
      ORDER BY nYear DESC, nVolume DESC, nNumber DESC, s.nRank, nOrder";

Someone can help me?
Posts: 1
Joined: Tue Jun 26, 2007 2:15 pm

Postby asmecher » Tue Jun 26, 2007 10:34 pm

Hi php340,

What is the version history of this OJS installation? Did you upgrade from a previous version, and what version are you using now?

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

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 3 guests