Actions

J2.5

Difference between revisions of "Reinstalling deleted Joomla 2.5 core extensions"

From Joomla! Documentation

 
(15 intermediate revisions by one user not shown)
Line 1: Line 1:
 
Some Joomla 2.5.x core components (Banners, Contacts, Newsfeeds, Smart Search, and Weblinks) can be deleted via the Back-end: Extensions > Extension Manager > Manage > (select + delete)
 
Some Joomla 2.5.x core components (Banners, Contacts, Newsfeeds, Smart Search, and Weblinks) can be deleted via the Back-end: Extensions > Extension Manager > Manage > (select + delete)
Core component installation packages don't exist because it's too much work to maintain.
 
  
= Reinstallation information per core-component =
+
Core component installation packages don't exist because it's too much work to maintain, and Joomla 2.5 has a nice feature called "discover".
With some FTP & phpMyAdmin knowledge you will be able to reinstall deleted core components.
+
In general, if you have deleted some core component by mistake, use the following steps to reinstall:
+
* Download & unzip the Joomla Full 2.5.x package of your current version
+
* Before following the next steps, backup your site (files + database)
+
* Re-upload the component's files for the front-end and the back-end (see info below)
+
* Re-create the reference to the component in your database with phpMyAdmin (see info below)
+
  
Next you will find the necessary information to reinstall a core component, all displayed in the format:
+
'''Note:''' The following method is recommended:  
* Name
+
* upload the contents of a Joomla full package (without /installation/ directory) to your website
* Directories + files to re-upload (front-end and back-end)
+
* use Extensions > Extension Manager > Discover to discover & install uninstalled extensions.
* SQL query to run in phpMyAdmin to restore the reference in the jos_components table ('''note:''' '''assuming that your table prefix is the default jos_''' )
+
* The components table structures + the component reference in #__extensions + the component menu items will all be created automatically.
 +
* The component reference in #__assets will not be created using "discover": to recreate, use Components > [component name] > [Options] (icon in upper right corner) > Permissions (tab) > [save & close]
  
== Banners ==
+
<noinclude>
Upload all files & directories under:
+
[[Category:Tips and tricks 2.5|Components]]
* /administrator/components/com_banners/
+
[[Category:Components]]
* /components/com_banners/
+
</noinclude>
 
+
Use phpMyAdmin to run the following SQL statements to recreate the references (replace jos_ with your own table prefix!):
+
=== Banner reference in Assets table ===
+
<source lang="sql">INSERT INTO `jos_assets` VALUES(3, 1, 3, 6, 1, 'com_banners', 'com_banners', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');</source>
+
 
+
===Banner Tables Structure===
+
<source lang="sql">--
+
-- Table structure for table `jos_banners`
+
--
+
 
+
CREATE TABLE IF NOT EXISTS `jos_banners` (
+
  `id` int(11) NOT NULL AUTO_INCREMENT,
+
  `cid` int(11) NOT NULL DEFAULT '0',
+
  `type` int(11) NOT NULL DEFAULT '0',
+
  `name` varchar(255) NOT NULL DEFAULT '',
+
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
+
  `imptotal` int(11) NOT NULL DEFAULT '0',
+
  `impmade` int(11) NOT NULL DEFAULT '0',
+
  `clicks` int(11) NOT NULL DEFAULT '0',
+
  `clickurl` varchar(200) NOT NULL DEFAULT '',
+
  `state` tinyint(3) NOT NULL DEFAULT '0',
+
  `catid` int(10) unsigned NOT NULL DEFAULT '0',
+
  `description` text NOT NULL,
+
  `custombannercode` varchar(2048) NOT NULL,
+
  `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
+
  `ordering` int(11) NOT NULL DEFAULT '0',
+
  `metakey` text NOT NULL,
+
  `params` text NOT NULL,
+
  `own_prefix` tinyint(1) NOT NULL DEFAULT '0',
+
  `metakey_prefix` varchar(255) NOT NULL DEFAULT '',
+
  `purchase_type` tinyint(4) NOT NULL DEFAULT '-1',
+
  `track_clicks` tinyint(4) NOT NULL DEFAULT '-1',
+
  `track_impressions` tinyint(4) NOT NULL DEFAULT '-1',
+
  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
+
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `reset` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `language` char(7) NOT NULL DEFAULT '',
+
  PRIMARY KEY (`id`),
+
  KEY `idx_state` (`state`),
+
  KEY `idx_own_prefix` (`own_prefix`),
+
  KEY `idx_metakey_prefix` (`metakey_prefix`),
+
  KEY `idx_banner_catid` (`catid`),
+
  KEY `idx_language` (`language`)
+
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
 
+
-- --------------------------------------------------------
+
 
+
--
+
-- Table structure for table `jos_banner_clients`
+
--
+
 
+
CREATE TABLE IF NOT EXISTS `jos_banner_clients` (
+
  `id` int(11) NOT NULL AUTO_INCREMENT,
+
  `name` varchar(255) NOT NULL DEFAULT '',
+
  `contact` varchar(255) NOT NULL DEFAULT '',
+
  `email` varchar(255) NOT NULL DEFAULT '',
+
  `extrainfo` text NOT NULL,
+
  `state` tinyint(3) NOT NULL DEFAULT '0',
+
  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
+
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `metakey` text NOT NULL,
+
  `own_prefix` tinyint(4) NOT NULL DEFAULT '0',
+
  `metakey_prefix` varchar(255) NOT NULL DEFAULT '',
+
  `purchase_type` tinyint(4) NOT NULL DEFAULT '-1',
+
  `track_clicks` tinyint(4) NOT NULL DEFAULT '-1',
+
  `track_impressions` tinyint(4) NOT NULL DEFAULT '-1',
+
  PRIMARY KEY (`id`),
+
  KEY `idx_own_prefix` (`own_prefix`),
+
  KEY `idx_metakey_prefix` (`metakey_prefix`)
+
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
 
+
-- --------------------------------------------------------
+
 
+
--
+
-- Table structure for table `jos_banner_tracks`
+
--
+
 
+
CREATE TABLE IF NOT EXISTS `jos_banner_tracks` (
+
  `track_date` datetime NOT NULL,
+
  `track_type` int(10) unsigned NOT NULL,
+
  `banner_id` int(10) unsigned NOT NULL,
+
  `count` int(10) unsigned NOT NULL DEFAULT '0',
+
  PRIMARY KEY (`track_date`,`track_type`,`banner_id`),
+
  KEY `idx_track_date` (`track_date`),
+
  KEY `idx_track_type` (`track_type`),
+
  KEY `idx_banner_id` (`banner_id`)
+
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
</source>
+
 
+
===Banner reference in Extensions Table===
+
<source lang="sql">INSERT INTO `jos_extensions` VALUES(4, 'com_banners', 'component', 'com_banners', '', 1, 1, 1, 0, '{"legacy":false,"name":"com_banners","type":"component","creationDate":"April 2006","author":"Joomla! Project","copyright":"(C) 2005 - 2012 Open Source Matters. All rights reserved.\\n\\t","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"2.5.0","description":"COM_BANNERS_XML_DESCRIPTION","group":""}', '{"purchase_type":"3","track_impressions":"0","track_clicks":"0","metakey_prefix":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0);</source>
+
 
+
===Banner references in Menu Table===
+
<source lang="sql">INSERT INTO `jos_menu` VALUES(2, 'menu', 'com_banners', 'Banners', '', 'Banners', 'index.php?option=com_banners', 'component', 0, 1, 1, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 1, 10, 0, '*', 1);
+
INSERT INTO `jos_menu` VALUES(3, 'menu', 'com_banners', 'Banners', '', 'Banners/Banners', 'index.php?option=com_banners', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 2, 3, 0, '*', 1);
+
INSERT INTO `jos_menu` VALUES(4, 'menu', 'com_banners_categories', 'Categories', '', 'Banners/Categories', 'index.php?option=com_categories&extension=com_banners', 'component', 0, 2, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-cat', 0, '', 4, 5, 0, '*', 1);
+
INSERT INTO `jos_menu` VALUES(5, 'menu', 'com_banners_clients', 'Clients', '', 'Banners/Clients', 'index.php?option=com_banners&view=clients', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-clients', 0, '', 6, 7, 0, '*', 1);
+
INSERT INTO `jos_menu` VALUES(6, 'menu', 'com_banners_tracks', 'Tracks', '', 'Banners/Tracks', 'index.php?option=com_banners&view=tracks', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-tracks', 0, '', 8, 9, 0, '*', 1);</source>
+
 
+
== Contacts ==
+
Upload all files & directories under:
+
* /administrator/components/com_contact/
+
* /components/com_contact/
+
 
+
 
+
== Newsfeeds ==
+
Upload all files & directories under:
+
* /administrator/components/com_newsfeeds/
+
* /components/com_newsfeeds/
+
 
+
== Smart Search ==
+
Upload all files & directories under:
+
 
+
 
+
== Weblinks ==
+
Upload all files & directories under:
+
* /administrator/components/com_weblinks/
+
* /components/com_weblinks/
+

Latest revision as of 07:28, 6 June 2013

Some Joomla 2.5.x core components (Banners, Contacts, Newsfeeds, Smart Search, and Weblinks) can be deleted via the Back-end: Extensions > Extension Manager > Manage > (select + delete)

Core component installation packages don't exist because it's too much work to maintain, and Joomla 2.5 has a nice feature called "discover".

Note: The following method is recommended:

  • upload the contents of a Joomla full package (without /installation/ directory) to your website
  • use Extensions > Extension Manager > Discover to discover & install uninstalled extensions.
  • The components table structures + the component reference in #__extensions + the component menu items will all be created automatically.
  • The component reference in #__assets will not be created using "discover": to recreate, use Components > [component name] > [Options] (icon in upper right corner) > Permissions (tab) > [save & close]