You are viewing the PKP Support Forum | PKP Home Wiki

Title Index troubles

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
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 subforum.

Title Index troubles

Postby TaB » Thu May 31, 2007 1:50 pm

After publishing the first issue, I noticed that the Title Index is not listing any of the article titles (its says No Results), but the Author Index lists the authors and the Issue index is also working fine.
Is there some way I can fix this?
Posts: 3
Joined: Thu Oct 26, 2006 8:05 pm

Postby asmecher » Thu May 31, 2007 4:43 pm

Hi TaB,

You say the article is available via the Archive (or Current) links? Odd; you may have to do some investigation in the database. Find out the article's ID, e.g. by looking at its Editing page (it should be listed as #157 Editing or similar). Then go into MySQL and run the following query:
Code: Select all
SELECT a.status, pa.pub_id FROM articles a LEFT JOIN published_articles pa ON (pa.article_id = a.article_id) WHERE a.article_id = 157;
...where, of course, the 157 is the article ID you looked up before. Let me know the results and I'll see what I can suggest.

If you don't know how to run a MySQL query, I can give you further instructions.

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: Yahoo [Bot] and 2 guests