Hey guys,

we can not install cb activity. We get the error:

"Specified key was too long; max key length is 1000 bytes SQL=ALTER TABLE `joomla_comprofiler_plugin_activity` ADD KEY `type_item_date` (`type`, `item`, `date`)
#0 /joomla/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php(317): JDatabaseDriverMysqli->execute() #1 /joomla/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(1759): CBLib\Database\Driver\CmsDatabaseDriver->query() #2 /joomla/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(1168): CBLib\Database\DatabaseUpgrade->doQuery('ALTER TABLE `#_...') #3 /joomla/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(323): CBLib\Database\DatabaseUpgrade->changeIndex('#__comprofiler_...', Array, Object(CBLib\Xml\SimpleXMLElement), 'cbactivity') #4 /joomla/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(240): CBLib\Database\DatabaseUpgrade->checkXmlTableDescription(Object(CBLib\Xml\SimpleXMLElement), 'cbactivity', true, NULL, NULL) #5 /joomla/libraries/CBLib/CB/Legacy/cbInstallerPlugin.php(200): CBLib\Database\DatabaseUpgrade->checkXmlDatabaseDescription(Object(CBLib\Xml\SimpleXMLElement), 'cbactivity', true, NULL, NULL) #6 /joomla/libraries/CBLib/CB/Legacy/CBInstallPlugin.php(365): cbInstallerPlugin->install() #7 /joomla/libraries/CBLib/CB/Legacy/CBInstallPlugin.php(88): CBInstallPlugin->installPluginUpload() #8 /joomla/libraries/CBLib/CBLib/AhaWow/Controller/ActionController.php(939): CBInstallPlugin->store() #9 /joomla/libraries/CBLib/CBLib/AhaWow/Controller/ActionController.php(598): CBLib\AhaWow\Controller\ActionController->savePluginView(Array, Array, Array, Array, Object(CBLib\Xml\SimpleXMLElement), Object(CBInstallPlugin), Object(CBLib\AhaWow\Controller\RegistryEditController), 'apply', 'class', NULL, Object(CBLib\Xml\SimpleXMLElement), Object(CBLib\Registry\Registry), 'b3B0aW9uPWNvbV9...', 2) #10 /joomla/libraries/CBLib/CBLib/AhaWow/Controller/ActionController.php(170): CBLib\AhaWow\Controller\ActionController->drawView('com_comprofiler', 'installcbplugin', Object(CBLib\Xml\SimpleXMLElement), 'apply') #11 /joomla/libraries/CBLib/CBLib/AhaWow/Controller/Controller.php(130): CBLib\AhaWow\Controller\ActionController->handleAction(Array) #12 /joomla/libraries/CBLib/CBLib/AhaWow/Controller/Controller.php(111): CBLib\AhaWow\Controller\Controller->execute(Array, Object(CBLib\Output\Output)) #13 /joomla/libraries/CBLib/CBLib/Controller/Controller.php(101): CBLib\AhaWow\Controller\Controller->dispatchRoute(Array) #14 /joomla/libraries/CBLib/CBLib/Controller/Controller.php(78): CBLib\Controller\Controller->execute('installcbplugin...') #15 /joomla/libraries/CBLib/CBLib/Controller/Dispatcher.php(86): CBLib\Controller\Controller->dispatch('installcbplugin...') #16 /joomla/libraries/CBLib/CBLib/Application/Application.php(131): CBLib\Controller\Dispatcher->dispatch() #17 /joomla/libraries/CBLib/CBLib/Core/CBLib.php(167): CBLib\Application\Application->dispatch() #18 /joomla/administrator/components/com_comprofiler/admin.comprofiler.controller.php(198): CBLib\Core\CBLib::execute() #19 /joomla/administrator/components/com_comprofiler/comprofiler.php(14): require('/var/www/vhosts...') #20 /joomla/libraries/cms/component/helper.php(391): require_once('/var/www/vhosts...') #21 /joomla/libraries/cms/component/helper.php(371): JComponentHelper::executeComponent('/var/www/vhosts...') #22 /joomla/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent('com_comprofiler') #23 /joomla/libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch() #24 /joomla/libraries/cms/application/cms.php(252): JApplicationAdministrator->doExecute() #25 /joomla/administrator/index.php(42): JApplicationCms->execute() #26 {main}"


What is the reason for this... And what can we do ???

You can mark this thread as solved.

We had to delete the old database entry of old activity plugin.