Archived

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

From Joomla! Documentation

(4 intermediate revisions by the same 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)
  
This document is Work in Progress, the following procedures are not yet checked:
+
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".
* Banners: have to be checked.
 
* Contacts: have to be checked.
 
* Newsfeeds: have to be checked.
 
* Smart Search: have to be checked.
 
* Weblinks: have to be checked.
 
  
 +
'''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]
  
Core component installation packages don't exist because it's too much work to maintain.
+
<noinclude>
 
+
[[Category:Tips and tricks 2.5|Components]]
= Reinstallation information per core-component =
+
[[Category:Components]]
With some FTP & phpMyAdmin knowledge you will be able to reinstall deleted core components.
+
</noinclude>
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:
 
* Name
 
* Directories + files to re-upload (front-end and back-end)
 
* 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_''' )
 
 
 
== Banners ==
 
Upload all files & directories under:
 
* /administrator/components/com_banners/
 
* /components/com_banners/
 
Language files:
 
* /administrator/language/en-GB/en-GB.com_banners.ini
 
* /administrator/language/en-GB/en-GB.com_banners.sys.ini
 
 
 
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/
 
Language files:
 
* /administrator/language/en-GB/en-GB.com_contact.ini
 
* /administrator/language/en-GB/en-GB.com_contact.sys.ini
 
* /language/en-GB/en-GB.com_contact.ini
 
 
 
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/
 
Language files:
 
* /administrator/language/en-GB/en-GB.com_newsfeeds.ini
 
* /administrator/language/en-GB/en-GB.com_newsfeeds.sys.ini
 
* /language/en-GB/en-GB.com_newsfeeds.ini
 
 
 
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>
 
===Newsfeeds Tables Structure===
 
<source lang="sql">
 
--
 
-- Table structure for table `jos_newsfeeds`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_newsfeeds` (
 
  `catid` int(11) NOT NULL DEFAULT '0',
 
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
  `name` varchar(100) NOT NULL DEFAULT '',
 
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 
  `link` varchar(200) NOT NULL DEFAULT '',
 
  `filename` varchar(200) DEFAULT NULL,
 
  `published` tinyint(1) NOT NULL DEFAULT '0',
 
  `numarticles` int(10) unsigned NOT NULL DEFAULT '1',
 
  `cache_time` int(10) unsigned NOT NULL DEFAULT '3600',
 
  `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',
 
  `rtl` tinyint(4) NOT NULL DEFAULT '0',
 
  `access` int(10) unsigned NOT NULL DEFAULT '0',
 
  `language` char(7) NOT NULL DEFAULT '',
 
  `params` text 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,
 
  `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_language` (`language`),
 
  KEY `idx_xreference` (`xreference`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
</source>
 
 
 
===Newsfeeds reference in Extensions Table===
 
<source lang="sql">
 
INSERT INTO `jos_extensions` VALUES(17, 'com_newsfeeds', 'component', 'com_newsfeeds', '', 1, 1, 1, 0, '{"legacy":false,"name":"com_newsfeeds","type":"component","creationDate":"April 2006","author":"Joomla! Project","copyright":"(C) 2005 - 2012 Open Source Matters. All rights reserved.\\t","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"2.5.0","description":"COM_NEWSFEEDS_XML_DESCRIPTION","group":""}', '{"show_feed_image":"1","show_feed_description":"1","show_item_description":"1","feed_word_count":"0","show_headings":"1","show_name":"1","show_articles":"0","show_link":"1","show_description":"1","show_description_image":"1","display_num":"","show_pagination_limit":"1","show_pagination":"1","show_pagination_results":"1","show_cat_items":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
 
</source>
 
 
 
===Newsfeeds references in Menu Table===
 
<source lang="sql">
 
INSERT INTO `jos_menu` VALUES(13, 'menu', 'com_newsfeeds', 'News Feeds', '', 'News Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 1, 1, 17, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 23, 28, 0, '*', 1);
 
INSERT INTO `jos_menu` VALUES(14, 'menu', 'com_newsfeeds_feeds', 'Feeds', '', 'News Feeds/Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 13, 2, 17, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 24, 25, 0, '*', 1);
 
INSERT INTO `jos_menu` VALUES(15, 'menu', 'com_newsfeeds_categories', 'Categories', '', 'News Feeds/Categories', 'index.php?option=com_categories&extension=com_newsfeeds', 'component', 0, 13, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds-cat', 0, '', 26, 27, 0, '*', 1);
 
</source>
 
 
 
== Smart Search ==
 
Upload all files & directories under:
 
* /administrator/components/com_finder
 
* /components/com_finder
 
Language files:
 
* /administrator/language/en-GB/en-GB.com_finder.ini
 
* /administrator/language/en-GB/en-GB.com_finder.sys.ini
 
* /language/en-GB/en-GB.com_finder.ini
 
 
 
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>
 
===Smart Search Tables Structure===
 
<source lang="sql">--
 
-- Table structure for table `jos_finder_filters`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_filters` (
 
  `filter_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
  `title` varchar(255) NOT NULL,
 
  `alias` varchar(255) NOT NULL,
 
  `state` tinyint(1) NOT NULL DEFAULT '1',
 
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `created_by` int(10) unsigned NOT NULL,
 
  `created_by_alias` varchar(255) NOT NULL,
 
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `modified_by` int(10) unsigned 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',
 
  `map_count` int(10) unsigned NOT NULL DEFAULT '0',
 
  `data` text NOT NULL,
 
  `params` mediumtext,
 
  PRIMARY KEY (`filter_id`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links` (
 
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
  `url` varchar(255) NOT NULL,
 
  `route` varchar(255) NOT NULL,
 
  `title` varchar(255) DEFAULT NULL,
 
  `description` varchar(255) DEFAULT NULL,
 
  `indexdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `md5sum` varchar(32) DEFAULT NULL,
 
  `published` tinyint(1) NOT NULL DEFAULT '1',
 
  `state` int(5) DEFAULT '1',
 
  `access` int(5) DEFAULT '0',
 
  `language` varchar(8) NOT NULL,
 
  `publish_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `publish_end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `list_price` double unsigned NOT NULL DEFAULT '0',
 
  `sale_price` double unsigned NOT NULL DEFAULT '0',
 
  `type_id` int(11) NOT NULL,
 
  `object` mediumblob NOT NULL,
 
  PRIMARY KEY (`link_id`),
 
  KEY `idx_type` (`type_id`),
 
  KEY `idx_title` (`title`),
 
  KEY `idx_md5` (`md5sum`),
 
  KEY `idx_url` (`url`(75)),
 
  KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
 
  KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms0`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms0` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms1`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms1` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms2`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms2` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms3`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms3` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms4`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms4` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms5`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms5` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms6`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms6` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms7`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms7` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms8`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms8` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_terms9`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_terms9` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_termsa`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_termsa` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_termsb`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_termsb` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_termsc`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_termsc` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_termsd`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_termsd` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_termse`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_termse` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_links_termsf`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_links_termsf` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `term_id` int(10) unsigned NOT NULL,
 
  `weight` float unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`term_id`),
 
  KEY `idx_term_weight` (`term_id`,`weight`),
 
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_taxonomy`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_taxonomy` (
 
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
 
  `title` varchar(255) NOT NULL,
 
  `state` tinyint(1) unsigned NOT NULL DEFAULT '1',
 
  `access` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  `ordering` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  PRIMARY KEY (`id`),
 
  KEY `parent_id` (`parent_id`),
 
  KEY `state` (`state`),
 
  KEY `ordering` (`ordering`),
 
  KEY `access` (`access`),
 
  KEY `idx_parent_published` (`parent_id`,`state`,`access`)
 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
 
 
 
--
 
-- Dumping data for table `jos_finder_taxonomy`
 
--
 
 
 
INSERT INTO `jos_finder_taxonomy` VALUES(1, 0, 'ROOT', 0, 0, 0);
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_taxonomy_map`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_taxonomy_map` (
 
  `link_id` int(10) unsigned NOT NULL,
 
  `node_id` int(10) unsigned NOT NULL,
 
  PRIMARY KEY (`link_id`,`node_id`),
 
  KEY `link_id` (`link_id`),
 
  KEY `node_id` (`node_id`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_terms`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_terms` (
 
  `term_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
  `term` varchar(75) NOT NULL,
 
  `stem` varchar(75) NOT NULL,
 
  `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  `weight` float unsigned NOT NULL DEFAULT '0',
 
  `soundex` varchar(75) NOT NULL,
 
  `links` int(10) NOT NULL DEFAULT '0',
 
  PRIMARY KEY (`term_id`),
 
  UNIQUE KEY `idx_term` (`term`),
 
  KEY `idx_term_phrase` (`term`,`phrase`),
 
  KEY `idx_stem_phrase` (`stem`,`phrase`),
 
  KEY `idx_soundex_phrase` (`soundex`,`phrase`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_terms_common`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_terms_common` (
 
  `term` varchar(75) NOT NULL,
 
  `language` varchar(3) NOT NULL,
 
  KEY `idx_word_lang` (`term`,`language`),
 
  KEY `idx_lang` (`language`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
--
 
-- Dumping data for table `jos_finder_terms_common`
 
--
 
 
 
INSERT INTO `jos_finder_terms_common` VALUES('a', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('about', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('after', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('ago', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('all', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('am', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('an', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('and', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('ani', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('any', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('are', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('aren''t', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('as', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('at', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('be', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('but', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('by', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('for', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('from', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('get', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('go', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('how', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('if', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('in', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('into', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('is', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('isn''t', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('it', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('its', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('me', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('more', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('most', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('must', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('my', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('new', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('no', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('none', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('not', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('noth', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('nothing', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('of', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('off', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('often', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('old', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('on', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('onc', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('once', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('onli', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('only', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('or', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('other', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('our', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('ours', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('out', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('over', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('page', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('she', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('should', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('small', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('so', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('some', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('than', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('thank', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('that', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('the', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('their', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('theirs', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('them', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('then', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('there', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('these', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('they', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('this', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('those', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('thus', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('time', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('times', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('to', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('too', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('true', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('under', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('until', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('up', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('upon', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('use', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('user', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('users', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('veri', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('version', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('very', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('via', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('want', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('was', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('way', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('were', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('what', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('when', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('where', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('whi', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('which', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('who', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('whom', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('whose', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('why', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('wide', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('will', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('with', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('within', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('without', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('would', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('yes', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('yet', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('you', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('your', 'en');
 
INSERT INTO `jos_finder_terms_common` VALUES('yours', 'en');
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_tokens`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_tokens` (
 
  `term` varchar(75) NOT NULL,
 
  `stem` varchar(75) NOT NULL,
 
  `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  `weight` float unsigned NOT NULL DEFAULT '1',
 
  `context` tinyint(1) unsigned NOT NULL DEFAULT '2',
 
  KEY `idx_word` (`term`),
 
  KEY `idx_context` (`context`)
 
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_tokens_aggregate`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_tokens_aggregate` (
 
  `term_id` int(10) unsigned NOT NULL,
 
  `map_suffix` char(1) NOT NULL,
 
  `term` varchar(75) NOT NULL,
 
  `stem` varchar(75) NOT NULL,
 
  `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  `term_weight` float unsigned NOT NULL,
 
  `context` tinyint(1) unsigned NOT NULL DEFAULT '2',
 
  `context_weight` float unsigned NOT NULL,
 
  `total_weight` float unsigned NOT NULL,
 
  KEY `token` (`term`),
 
  KEY `keyword_id` (`term_id`)
 
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
 
 
-- --------------------------------------------------------
 
 
 
--
 
-- Table structure for table `jos_finder_types`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_finder_types` (
 
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
  `title` varchar(100) NOT NULL,
 
  `mime` varchar(100) NOT NULL,
 
  PRIMARY KEY (`id`),
 
  UNIQUE KEY `title` (`title`)
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
</source>
 
 
 
===Smart Search reference in Extensions Table===
 
<source lang="sql">
 
INSERT INTO `jos_extensions` VALUES(27, 'com_finder', 'component', 'com_finder', '', 1, 1, 0, 0, '{"legacy":false,"name":"com_finder","type":"component","creationDate":"August 2011","author":"Joomla! Project","copyright":"(C) 2005 - 2012 Open Source Matters. All rights reserved.","authorEmail":"admin@joomla.org","authorUrl":"www.joomla.org","version":"2.5.0","description":"COM_FINDER_XML_DESCRIPTION","group":""}', '{"show_description":"1","description_length":255,"allow_empty_query":"0","show_url":"1","show_advanced":"1","expand_advanced":"0","show_date_filters":"0","highlight_terms":"1","opensearch_name":"","opensearch_description":"","batch_size":"50","memory_table_limit":30000,"title_multiplier":"1.7","text_multiplier":"0.7","meta_multiplier":"1.2","path_multiplier":"2.0","misc_multiplier":"0.3","stemmer":"snowball"}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
 
</source>
 
 
 
===Smart Search references in Menu Table===
 
<source lang="sql">
 
INSERT INTO `jos_menu` VALUES(21, 'menu', 'com_finder', 'Smart Search', '', 'Smart Search', 'index.php?option=com_finder', 'component', 0, 1, 1, 27, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:finder', 0, '', 31, 32, 0, '*', 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>
 
 
 
===Weblinks Tables Structure===
 
<source lang="sql">--
 
-- Table structure for table `jos_weblinks`
 
--
 
 
 
CREATE TABLE IF NOT EXISTS `jos_weblinks` (
 
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
  `catid` int(11) NOT NULL DEFAULT '0',
 
  `sid` int(11) NOT NULL DEFAULT '0',
 
  `title` varchar(250) NOT NULL DEFAULT '',
 
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 
  `url` varchar(250) NOT NULL DEFAULT '',
 
  `description` text NOT NULL,
 
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `hits` int(11) NOT NULL DEFAULT '0',
 
  `state` tinyint(1) NOT NULL DEFAULT '0',
 
  `checked_out` int(11) NOT NULL DEFAULT '0',
 
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 
  `ordering` int(11) NOT NULL DEFAULT '0',
 
  `archived` tinyint(1) NOT NULL DEFAULT '0',
 
  `approved` tinyint(1) NOT NULL DEFAULT '1',
 
  `access` int(11) NOT NULL DEFAULT '1',
 
  `params` text NOT NULL,
 
  `language` char(7) NOT NULL DEFAULT '',
 
  `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 link 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` (`state`),
 
  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>
 
 
 
===Weblinks reference in Extensions Table===
 
<source lang="sql">
 
INSERT INTO `jos_extensions` VALUES(21, 'com_weblinks', 'component', 'com_weblinks', '', 1, 1, 1, 0, '{"legacy":false,"name":"com_weblinks","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_WEBLINKS_XML_DESCRIPTION","group":""}', '{"show_comp_description":"1","comp_description":"","show_link_hits":"1","show_link_description":"1","show_other_cats":"0","show_headings":"0","show_numbers":"0","show_report":"1","count_clicks":"1","target":"0","link_icons":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0);
 
</source>
 
 
 
===Weblinks references in Menu Table===
 
<source lang="sql">
 
INSERT INTO `jos_menu` VALUES(18, 'menu', 'com_weblinks', 'Weblinks', '', 'Weblinks', 'index.php?option=com_weblinks', 'component', 0, 1, 1, 21, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks', 0, '', 35, 40, 0, '*', 1);
 
INSERT INTO `jos_menu` VALUES(19, 'menu', 'com_weblinks_links', 'Links', '', 'Weblinks/Links', 'index.php?option=com_weblinks', 'component', 0, 18, 2, 21, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks', 0, '', 36, 37, 0, '*', 1);
 
INSERT INTO `jos_menu` VALUES(20, 'menu', 'com_weblinks_categories', 'Categories', '', 'Weblinks/Categories', 'index.php?option=com_categories&extension=com_weblinks', 'component', 0, 18, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks-cat', 0, '', 38, 39, 0, '*', 1);
 
</source>
 

Revision as of 18:48, 16 April 2012

This page has been archived. This page contains information for an unsupported Joomla! version or is no longer relevant. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

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]