Kevin you are on Joomla3, right? It seems that the db function we were using has been removed on this version of joomla.
The interesting part is why I haven't seen this message before.
could you please modify:
\administrator\components\com_hotspots\tables\marker.php on line 138
The countCategoryMarker function should be replaced with this:
public function countCategoryMarker($ids) {
$db = $this->_db;
$query = $db->getQuery(true);
// if we have an array, then we have hotspots ids
if(is_array($ids)) {
$query->select('DISTINCT(catid)')->from('#__hotspots_marker')
->where('id IN ('.implode(',', $ids).')');
$db->setQuery($query);
$ids = $db->loadColumn();
} else {
$ids = array($ids);
}
foreach($ids as $value) {
$query->clear();
$query->select('COUNT(*)')->from($db->qn('#__hotspots_marker'))
->where('catid = ' . $db->q($value))
->where('published = ' . $db->q(1));
$db->setQuery($query);
$count = $db->loadRow();
$query->clear();
$query->update('#__hotspots_categorie')->set( 'count = ' . $db->q($count[0]) )
->where('id =' . $db->q($value) );
$db->setQuery($query);
$db->execute();
}
}
then also in the publish function around line 102 change $this->countCategoryMarker() with
$this->countCategoryMarker($cid);
And in the store function around line 38 change $this->countCategoryMarker() to this
$this->countCategoryMarker($this->catid);
Normally I would give you a link to a dev release that contains the changes, but I'm on a public network and I don't have access to our server. (I can create a new dev. release tomorrow that will contain the changes)
Regards,
Daniel
