Looks like there's a few queries that need to be taken care of in the Open Graph and Requests (Facebook Invitations) stuff. I've taken a note of the ones we've found, and we'll get those updated before the next release.
For the query you specified, please edit the /administrator/components/com_jfbconnect/models/opengraphobject.php file. Around line 90, you'll see:
$query = "SELECT * FROM #__opengraph_object";
if ($publishedOnly)
$query .= " WHERE published=1";Update that to:
$query = $this->_db->getQuery(true);
$query->select('*')
->from($this->_db->qn('#__opengraph_object'));
if ($publishedOnly)
$query->where($this->_db->qn('published') . '=1');There are some delete queries above that that we'll have to fix as well.. so you may run into issues if you delete before then.
While you're editing and getting Open Graph setup, you'll need to edit the opengraphaction.php file in the same directory.
Toward the bottom, you'll see:
private function setObjectMappings($actionId, $objects)
{
$filter = JFilterInput::getInstance();
// Delete all previous associations
$this->_db->setQuery("DELETE FROM #__opengraph_action_object WHERE action_id = " . $actionId);
$this->_db->execute();
foreach ($objects as $objectId)
{
$objectId = $filter->clean($objectId, 'INT');
if (is_int($objectId))
{
$this->_db->setQuery("INSERT INTO #__opengraph_action_object (`action_id`, `object_id`) VALUES " .
"(" . $actionId . ", " . $objectId . ")");
$this->_db->execute();
}
}
}Replace that whole function with:
private function setObjectMappings($actionId, $objects)
{
$filter = JFilterInput::getInstance();
// Delete all previous associations
$query = $this->_db->getQuery(true);
$query->delete($this->_db->qn("#__opengraph_action_object"))
->where($this->_db->qn("action_id") . '=' . $actionId);
$this->_db->setQuery($query);
$this->_db->execute();
$columns = array('action_id', 'object_id');
$query = $this->_db->getQuery(true);
$query->insert($this->_db->qn("#__opengraph_action_object")
->columns($this->_db->qn($columns));
foreach ($objects as $objectId)
{
$objectId = $filter->clean($objectId, 'INT');
if (is_int($objectId))
{
$query->clear('values');
$query->values($actionId . ',' . $objectId);
$this->_db->setQuery($query);
$this->_db->query();
}
}
}The above was written and doesn't seem to blow up, but I didn't fully test. Please let me know if you run into any issues.
We're planning the 6.1.2 release either for Friday this week or early next week, depending on any other minor issues found and general timing constraints. We'll try to find any other queries that we may have missed that aren't using the abstraction layer by that release.
As always, keep me posted on what you find or if you need anything else.
Thanks,
Alex
Postgres installation issues
