[Summary view] [Print] [Text view]

   1  -- From 4.0.0-2020-09-19.sql
   2  UPDATE `#__menu` SET `link`='index.php?option=com_finder' WHERE `menutype`='main' AND `title`='com_finder' AND `link`='index.php?option=com_finder&view=index';
   3  
   4  -- From 4.0.0-2020-09-22.sql
   5  UPDATE `#__menu` SET `link`='index.php?option=com_tags&view=tags' WHERE `menutype`='main' AND `path`='Tags';
   6  UPDATE `#__menu` SET `link`='index.php?option=com_associations&view=associations' WHERE `menutype`='main' AND `path`='Multilingual Associations';
   7  
   8  -- From 4.0.0-2020-09-27.sql
   9  DELETE FROM `#__extensions` WHERE `name` = 'plg_content_imagelazyload' AND `type` = 'plugin' AND `element` = 'imagelazyload' AND `folder` = 'content' AND `client_id` = 0;
  10  DELETE FROM `#__extensions` WHERE `name` = 'plg_authentication_gmail' AND `type` = 'plugin' AND `element` = 'gmail' AND `folder` = 'authentication' AND `client_id` = 0;
  11  
  12  --
  13  -- Delete possibly duplicate record for plg_sampledata_multilang
  14  --
  15  DELETE `e1`.*
  16    FROM `#__extensions` AS `e1`
  17    LEFT JOIN (SELECT MAX(extension_id) AS last_id FROM `#__extensions` GROUP BY `name`,`type`,`element`,`folder`,`client_id`) AS `e2`
  18      ON `e2`.`last_id` = `e1`.`extension_id`
  19   WHERE `last_id` IS NULL;
  20  
  21  --
  22  -- Enable the remaining plg_sampledata_multilang record in case it has been disabled before
  23  --
  24  UPDATE `#__extensions` SET `enabled` = 1 WHERE `name` = 'plg_sampledata_multilang' AND `type` = 'plugin' AND `element` = 'multilang' AND `folder` = 'sampledata' AND `client_id` = 0;