Upgrading from CB 1.9.1 to 2.0.11 on Joomla 3.4.5 (on a test site), I get this:
Warning
Duplicate entry '17' for key 'PRIMARY' SQL=INSERT INTO `j25_comprofiler_plugin` (`id`,`name`,`element`,`type`,`folder`,`viewaccesslevel`,`backend_menu`,`ordering`,`published`,`iscore`,`client_id`,`checked_out`,`checked_out_time`,`params`) VALUES (17,'CB Articles','cbarticles','user','plug_cbarticles',1,'',8,1,1,0,0,'0000-00-00 00:00:00',''), (18,'CB Forums','cbforums','user','plug_cbforums',1,'',9,1,1,0,0,'0000-00-00 00:00:00',''), (19,'CB Blogs','cbblogs','user','plug_cbblogs',1,'',10,1,1,0,0,'0000-00-00 00:00:00','')
Package Install: There was an error installing an extension: com_comprofiler.zip
After this, Community Builder is no longer installed and kunena forum gives a 500 server error.
Having looked at the comprofiler_plugin table, the row 17 that already exists is pms.uddeim.
Presumably, this is a bug, as the CB installer should not make the assumption that key 17 is free? Maybe the installer should change any occupied row index numbers to free ones after the highest index number or something?
Anyway, to mitigate this when I come to upgrade the live site, should I remove all the non-default plugins and upgrade, then re-install the plugins after the upgrade? Is there a better way? Is it safe to manually renumber the plugins from 17 onwards to (for example) 117 onwards?
Having deleted all the rows from 17 onwards in the comprofiler_plugin table, the installation succeeds ok and the kunena forum works again.
Hopefully, this problem can be sorted in a future update of CB.
Thanks
Brian
krileon
