search and detailed author index not working

[Jakob]

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

[asmecher]

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

[Jakob]

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

[asmecher]

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