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
What to do if you have a technical problem with OJS:
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.
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 OJS Editorial Support and Discussion
subforum; if you have a development question, try the OJS Development
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,
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
What is the version history of this OJS installation? Did you upgrade from a previous version, and what version are you using now?
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: Baidu [Spider], Yahoo [Bot] and 4 guests