On a fresh install of Joomla 3.6.2, I attempted to install JEvents 3.4 with the file jevents34_3.4.22.zip with the date of October 7, 2016. The issue that I have is that the install attempts to add a column that already exists. On line 604 of the install.php script inside of the component folder, you are getting: "SHOW INDEX" and should be using: "SHOW COLUMN".
Just giving you a heads up before others attempt to install this new version and it breaks their existing jevents by updating a component and leaving the database in an non-updated state.
Should be:
Just giving you a heads up before others attempt to install this new version and it breaks their existing jevents by updating a component and leaving the database in an non-updated state.
Should be:
$sql = "SHOW COLUMN FROM #__jevents_filtermap";
$db->setQuery($sql);
$cols = @$db->loadObjectList("Key_name");
if (!array_key_exists("andor", $cols))
{
$sql = "ALTER TABLE #__jevents_filtermap ADD COLUMN andor tinyint(3) NOT NULL default 0";
$db->setQuery($sql);
@$db->execute();
}
if (!array_key_exists("modid", $cols))
{
$sql = "ALTER TABLE #__jevents_filtermap ADD COLUMN modid int(12) NOT NULL default 0";
$db->setQuery($sql);
@$db->execute();
}
if (!array_key_exists("name", $cols))
{
$sql = "ALTER TABLE #__jevents_filtermap ADD COLUMN name varchar(255) $rowcharset NOT NULL default '' ";
$db->setQuery($sql);
@$db->execute();
}