OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



search and detailed author index not working

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.

search and detailed author index not working

Postby Jakob » Mon Feb 27, 2006 4:47 pm

Hello,

Having upgraded (1.1.8 ->1.1.10) and moved hisal.org journal to a new server (php version 4.4.1), some functions in search.php do not work anymore. More specificaly the query :

$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";
$result = $db->query($sql);

does not retrieve any result in functions displaySearchResults, authorIndex, authorDetail.

MySQL problem or wrong php settings ? Everything else works (but for $baseurl I had to change because of php.cgi). Can anybody help ?

Thanks in advance, regards,
Jakob Schlüpmann
http://www.hisal.org
Jakob
 
Posts: 7
Joined: Wed Jun 09, 2004 3:25 pm

Postby asmecher » Tue Feb 28, 2006 10:32 am

Hi Jakob,

Have you checked to ensure that there are no errors being reported by PHP? Depending on your system's php.ini configuration, errors might not be displayed. If you're on a shared host, try using:
Code: Select all
ini_set('display_errors', E_ALL);
Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 8470
Joined: Wed Aug 10, 2005 12:56 pm

Postby Jakob » Wed Mar 01, 2006 7:22 am

Hi Alec,

Thank you for looking into the problem.
Error report only returns some notices (variables not set etc... ). Nothing seemingly related to the said mysql query not returning results.
Could something be wrong with the JOIN used in the mysql query because of the upgrade ?

Regards,
Jakob Schlüpmann
http://www.hisal.org
Jakob
 
Posts: 7
Joined: Wed Jun 09, 2004 3:25 pm

Postby asmecher » Wed Mar 01, 2006 10:19 am

Hi Jakob,

Between OJS 1.1.8 and 1.1.10 there is one minor schema change relating to reviews; only a few queries changed and none of these relate to searching. Generally speaking, OJS 1.1.10 has been a very stable release. I suspect the migration process might be the problem, rather than the upgrade; I'd suggest enabling logging on your database server and capturing the query that's not returning any results (or capturing the executed SQL using PHP) and looking there to see why the query is not returning any results.

One thing some users encounter when migrating installations is character set problems. Have you checked the search features using content that doesn't contain accented characters?

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 8470
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 2 guests