Actions

J2.5

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

From Joomla! Documentation

(12 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":[]}');
+
INSERT INTO `jos_assets` VALUES(28, 3, 4, 5, 2, 'com_banners.category.3', 'Uncategorised', '{"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/
+
 
+
Use phpMyAdmin to run the following SQL statements to recreate the references (replace jos_ with your own table prefix!):
+
=== Contacts reference in Assets table ===
+
<source lang="sql">INSERT INTO `jos_assets` VALUES(7, 1, 13, 16, 1, 'com_contact', 'com_contact', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
+
INSERT INTO `jos_assets` VALUES(29, 7, 14, 15, 2, 'com_contact.category.4', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
+
</source>
+
===Contacts Tables Structure===
+
<source lang="sql">--
+
-- Table structure for table `jos_contact_details`
+
--
+
 
+
CREATE TABLE IF NOT EXISTS `jos_contact_details` (
+
  `id` int(11) NOT NULL AUTO_INCREMENT,
+
  `name` varchar(255) NOT NULL DEFAULT '',
+
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
+
  `con_position` varchar(255) DEFAULT NULL,
+
  `address` text,
+
  `suburb` varchar(100) DEFAULT NULL,
+
  `state` varchar(100) DEFAULT NULL,
+
  `country` varchar(100) DEFAULT NULL,
+
  `postcode` varchar(100) DEFAULT NULL,
+
  `telephone` varchar(255) DEFAULT NULL,
+
  `fax` varchar(255) DEFAULT NULL,
+
  `misc` mediumtext,
+
  `image` varchar(255) DEFAULT NULL,
+
  `imagepos` varchar(20) DEFAULT NULL,
+
  `email_to` varchar(255) DEFAULT NULL,
+
  `default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
+
  `published` tinyint(1) 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',
+
  `ordering` int(11) NOT NULL DEFAULT '0',
+
  `params` text NOT NULL,
+
  `user_id` int(11) NOT NULL DEFAULT '0',
+
  `catid` int(11) NOT NULL DEFAULT '0',
+
  `access` int(10) unsigned NOT NULL DEFAULT '0',
+
  `mobile` varchar(255) NOT NULL DEFAULT '',
+
  `webpage` varchar(255) NOT NULL DEFAULT '',
+
  `sortname1` varchar(255) NOT NULL,
+
  `sortname2` varchar(255) NOT NULL,
+
  `sortname3` varchar(255) NOT NULL,
+
  `language` char(7) NOT NULL,
+
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
+
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
+
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
+
  `metakey` text NOT NULL,
+
  `metadesc` text NOT NULL,
+
  `metadata` text NOT NULL,
+
  `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if article is featured.',
+
  `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
+
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+
  PRIMARY KEY (`id`),
+
  KEY `idx_access` (`access`),
+
  KEY `idx_checkout` (`checked_out`),
+
  KEY `idx_state` (`published`),
+
  KEY `idx_catid` (`catid`),
+
  KEY `idx_createdby` (`created_by`),
+
  KEY `idx_featured_catid` (`featured`,`catid`),
+
  KEY `idx_language` (`language`),
+
  KEY `idx_xreference` (`xreference`)
+
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
</source>
+
 
+
===Contacts reference in Extensions Table===
+
<source lang="sql">
+
INSERT INTO `jos_extensions` VALUES(8, 'com_contact', 'component', 'com_contact', '', 1, 1, 1, 0, '{"legacy":false,"name":"com_contact","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_CONTACT_XML_DESCRIPTION","group":""}', '{"show_contact_category":"hide","show_contact_list":"0","presentation_style":"sliders","show_name":"1","show_position":"1","show_email":"0","show_street_address":"1","show_suburb":"1","show_state":"1","show_postcode":"1","show_country":"1","show_telephone":"1","show_mobile":"1","show_fax":"1","show_webpage":"1","show_misc":"1","show_image":"1","image":"","allow_vcard":"0","show_articles":"0","show_profile":"0","show_links":"0","linka_name":"","linkb_name":"","linkc_name":"","linkd_name":"","linke_name":"","contact_icons":"0","icon_address":"","icon_email":"","icon_telephone":"","icon_mobile":"","icon_fax":"","icon_misc":"","show_headings":"1","show_position_headings":"1","show_email_headings":"0","show_telephone_headings":"1","show_mobile_headings":"0","show_fax_headings":"0","allow_vcard_headings":"0","show_suburb_headings":"1","show_state_headings":"1","show_country_headings":"1","show_email_form":"1","show_email_copy":"1","banned_email":"","banned_subject":"","banned_text":"","validate_session":"1","custom_reply":"0","redirect":"","show_category_crumb":"0","metakey":"","metadesc":"","robots":"","author":"","rights":"","xreference":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
+
</source>
+
 
+
===Contacts references in Menu Table===
+
<source lang="sql">
+
INSERT INTO `jos_menu` VALUES(7, 'menu', 'com_contact', 'Contacts', '', 'Contacts', 'index.php?option=com_contact', 'component', 0, 1, 1, 8, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 11, 16, 0, '*', 1);
+
INSERT INTO `jos_menu` VALUES(8, 'menu', 'com_contact', 'Contacts', '', 'Contacts/Contacts', 'index.php?option=com_contact', 'component', 0, 7, 2, 8, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 12, 13, 0, '*', 1);
+
INSERT INTO `jos_menu` VALUES(9, 'menu', 'com_contact_categories', 'Categories', '', 'Contacts/Categories', 'index.php?option=com_categories&extension=com_contact', 'component', 0, 7, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact-cat', 0, '', 14, 15, 0, '*', 1);
+
</source>
+
 
+
== Newsfeeds ==
+
Upload all files & directories under:
+
* /administrator/components/com_newsfeeds/
+
* /components/com_newsfeeds/
+
 
+
Use phpMyAdmin to run the following SQL statements to recreate the references (replace jos_ with your own table prefix!):
+
=== Newsfeeds reference in Assets table ===
+
<source lang="sql">INSERT INTO `jos_assets` VALUES(19, 1, 41, 44, 1, 'com_newsfeeds', 'com_newsfeeds', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
+
INSERT INTO `jos_assets` VALUES(30, 19, 42, 43, 2, 'com_newsfeeds.category.5', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
+
</source>
+
 
+
== Smart Search ==
+
Upload all files & directories under:
+
 
+
Use phpMyAdmin to run the following SQL statements to recreate the references (replace jos_ with your own table prefix!):
+
=== Smart Search reference in Assets table ===
+
<source lang="sql">INSERT INTO `jos_assets` VALUES(33, 1, 63, 64, 1, 'com_finder', 'com_finder', '{"core.admin":{"7":1},"core.manage":{"6":1}}');</source>
+
 
+
== Weblinks ==
+
Upload all files & directories under:
+
* /administrator/components/com_weblinks/
+
* /components/com_weblinks/
+
 
+
Use phpMyAdmin to run the following SQL statements to recreate the references (replace jos_ with your own table prefix!):
+
=== Weblinks reference in Assets table ===
+
<source lang="sql">INSERT INTO `jos_assets` VALUES(25, 1, 57, 60, 1, 'com_weblinks', 'com_weblinks', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1},"core.edit.own":[]}');
+
INSERT INTO `jos_assets` VALUES(31, 25, 58, 59, 2, 'com_weblinks.category.6', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
+
</source>
+

Revision as of 18:48, 16 April 2012

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]