Hi, and thanks
I got the snippet from the repository and around those lines it reads:
// make sql statement for retreiving similar pages
$pre= $modx->dbConfig['dbase'].".".$modx->dbConfig['table_prefix'];
$relatedSql = "
SELECT DISTINCT content.id, content.pagetitle, content.description,
IF(content.pub_date > 0, content.pub_date, content.createdon) AS date
FROM
".$pre."site_content AS content,
".$pre."keyword_xref AS xref,
".$pre."site_keywords AS keywords
WHERE keywords.keyword IN (".$keyString.")
AND xref.keyword_id = keywords.id
AND content.hidemenu = ".$showhidemenu."
AND content.id = xref.content_id
AND content.id != ".$modx->documentObject['id']."
ORDER BY ". $sortBy . ' ' . $sortDir ."
LIMIT ".$maxRelated.";";
$relatives = $modx->dbQuery($relatedSql);
$relativeCount = $modx->recordCount($relatives);
$relArray = array();
for($i=0;$i<$relativeCount;$i++) {
array_push($relArray,$modx->fetchRow($relatives));
}
<br /><br />so it has this 112th line
AND content.id != ".$modx->documentObject['id']."
<br /><br />but doesn’t seem to pick it up and parse it ok.<br /><br />Indeed, the snippet says 092, suggesting it was written around that time, but there are other people using it on 0.9.6 without problems as I read this thread.<br /><br />I’ve got FURLs and alias ON, could that be the problem?<br /> As I understand, the syntax is not the correct/suitable syntax for my current MySQL version 5.0.45<br /><br />My call is the suggested minimal<br />
[[ListRelated?LR_keywords=fun,functional,good stuff]]
<br /><br />Thanks for any help anyone can offer.<br />
MODX Staff
