J1.5

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

From Joomla! Documentation

Line 128: Line 128:
 
INSERT INTO `jos_components` VALUES (6, 'Categories', '', 0, 4, 'option=com_categories&section=com_weblinks',  
 
INSERT INTO `jos_components` VALUES (6, 'Categories', '', 0, 4, 'option=com_categories&section=com_weblinks',  
 
'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1);</source>
 
'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1);</source>
 +
 +
The SQL to create the weblinks table:
 +
<source lang="sql">CREATE TABLE IF NOT EXISTS `jos_weblinks` (
 +
  `id` int(11) 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) 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',
 +
  `published` 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',
 +
  `params` text NOT NULL,
 +
  PRIMARY KEY  (`id`),
 +
  KEY `catid` (`catid`,`published`,`archived`)
 +
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;</source>
 +
 +
If you want the example date, use the following SQL:
 +
<source lang="sql">INSERT INTO `jos_weblinks` VALUES(1, 2, 0, 'Joomla!', 'joomla', 'http://www.joomla.org', 'Home of Joomla!', '2005-02-14 15:19:02', 5, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0');
 +
INSERT INTO `jos_weblinks` VALUES(2, 2, 0, 'php.net', 'php', 'http://www.php.net', 'The language that Joomla! is developed in', '2004-07-07 11:33:24', 8, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, '');
 +
INSERT INTO `jos_weblinks` VALUES(3, 2, 0, 'MySQL', 'mysql', 'http://www.mysql.com', 'The database that Joomla! uses', '2004-07-07 10:18:31', 3, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, '');
 +
INSERT INTO `jos_weblinks` VALUES(4, 2, 0, 'OpenSourceMatters', 'opensourcematters', 'http://www.opensourcematters.org', 'Home of OSM', '2005-02-14 15:19:02', 13, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 'target=0');
 +
INSERT INTO `jos_weblinks` VALUES(5, 2, 0, 'Joomla! - Forums', 'joomla-forums', 'http://forum.joomla.org', 'Joomla! Forums', '2005-02-14 15:19:02', 6, 1, 0, '0000-00-00 00:00:00', 4, 0, 1, 'target=0');
 +
INSERT INTO `jos_weblinks` VALUES(6, 2, 0, 'Ohloh Tracking of Joomla!', 'ohloh-tracking-of-joomla', 'http://www.ohloh.net/projects/20', 'Objective reports from Ohloh about Joomla''s development activity. Joomla! has some star developers with serious kudos.', '2007-07-19 09:28:31', 3, 1, 0, '0000-00-00 00:00:00', 6, 0, 1, 'target=0\n\n');</source>
  
 
<noinclude>
 
<noinclude>

Revision as of 18:00, 29 January 2010

The "J1.5" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. 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 1.5.x core component (Banners, News Feeds, Polls, and Weblinks) can be deleted via the /administrator back-end: Extensions > Install/Uninstall > Components.

Core component installation packages don't exist because it's too much work to maintain.

Reinstallation information per core-component[edit]

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 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[edit]

Upload all files & directories under:

  • /administrator/components/com_banners/
  • /components/com_banners/

Use phpMyAdmin to run the following SQL statements to recreate the references:

INSERT INTO `jos_components` VALUES (1, 'Banners', '', 0, 0, '', 'Banner Management', 
'com_banners', 0, 'js/ThemeOffice/component.png', 0, 'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n', 1);
INSERT INTO `jos_components` VALUES (2, 'Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 
'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '', 1);
INSERT INTO `jos_components` VALUES (3, 'Clients', '', 0, 1, 'option=com_banners&c=client', 'Manage Clients', 
'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '', 1);

News Feeds[edit]

Upload all files & directories under:

  • /administrator/components/com_newsfeeds/
  • /components/com_newsfeeds/

Use phpMyAdmin to run the following SQL statements to recreate the references:

INSERT INTO `jos_components` VALUES (11, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management',
'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '', 1);
INSERT INTO `jos_components` VALUES (12, 'Feeds', '', 0, 11, 'option=com_newsfeeds', 'Manage News Feeds', 
'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, 'show_headings=1\nshow_name=1\nshow_articles=1
\nshow_link=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1
\nshow_item_description=1\nfeed_word_count=0\n\n', 1);
INSERT INTO `jos_components` VALUES (13, 'Categories', '', 0, 11, 'option=com_categories&section=com_newsfeeds', 
'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1);

Polls[edit]

Upload all files & directories under:

  • /administrator/components/com_poll/
  • /components/com_poll/

Use phpMyAdmin to run the following SQL statements to recreate the references:

INSERT INTO `jos_components` VALUES (10, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 
'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '', 1);

To recreate the four Poll tables with example data:

CREATE TABLE `jos_polls` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `voters` int(9) 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',
  `published` tinyint(1) NOT NULL default '0',
  `access` int(11) NOT NULL default '0',
  `lag` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

INSERT INTO `jos_polls` VALUES (14, 'Joomla! is used for?', 'joomla-is-used-for', 
11, 0, '0000-00-00 00:00:00', 1, 0, 86400);

CREATE TABLE `jos_poll_data` (
  `id` int(11) NOT NULL auto_increment,
  `pollid` int(11) NOT NULL default '0',
  `text` text NOT NULL,
  `hits` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

INSERT INTO `jos_poll_data` VALUES (1, 14, 'Community Sites', 2);
INSERT INTO `jos_poll_data` VALUES (2, 14, 'Public Brand Sites', 3);
INSERT INTO `jos_poll_data` VALUES (3, 14, 'eCommerce', 1);
INSERT INTO `jos_poll_data` VALUES (4, 14, 'Blogs', 0);
INSERT INTO `jos_poll_data` VALUES (5, 14, 'Intranets', 0);
INSERT INTO `jos_poll_data` VALUES (6, 14, 'Photo and Media Sites', 2);
INSERT INTO `jos_poll_data` VALUES (7, 14, 'All of the Above!', 3);
INSERT INTO `jos_poll_data` VALUES (8, 14, '', 0);
INSERT INTO `jos_poll_data` VALUES (9, 14, '', 0);
INSERT INTO `jos_poll_data` VALUES (10, 14, '', 0);
INSERT INTO `jos_poll_data` VALUES (11, 14, '', 0);
INSERT INTO `jos_poll_data` VALUES (12, 14, '', 0);

CREATE TABLE `jos_poll_date` (
  `id` bigint(20) NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `vote_id` int(11) NOT NULL default '0',
  `poll_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

INSERT INTO `jos_poll_date` VALUES (1, '2006-10-09 13:01:58', 1, 14);
INSERT INTO `jos_poll_date` VALUES (2, '2006-10-10 15:19:43', 7, 14);
INSERT INTO `jos_poll_date` VALUES (3, '2006-10-11 11:08:16', 7, 14);
INSERT INTO `jos_poll_date` VALUES (4, '2006-10-11 15:02:26', 2, 14);
INSERT INTO `jos_poll_date` VALUES (5, '2006-10-11 15:43:03', 7, 14);
INSERT INTO `jos_poll_date` VALUES (6, '2006-10-11 15:43:38', 7, 14);
INSERT INTO `jos_poll_date` VALUES (7, '2006-10-12 00:51:13', 2, 14);
INSERT INTO `jos_poll_date` VALUES (8, '2007-05-10 19:12:29', 3, 14);
INSERT INTO `jos_poll_date` VALUES (9, '2007-05-14 14:18:00', 6, 14);
INSERT INTO `jos_poll_date` VALUES (10, '2007-06-10 15:20:29', 6, 14);
INSERT INTO `jos_poll_date` VALUES (11, '2007-07-03 12:37:53', 2, 14);

CREATE TABLE `jos_poll_menu` (
  `pollid` int(11) NOT NULL default '0',
  `menuid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Web Links[edit]

Upload all files & directories under:

  • /administrator/components/com_weblinks/
  • /components/com_weblinks/

Use phpMyAdmin to run the following SQL statements to recreate the references:

INSERT INTO `jos_components` VALUES (4, 'Web Links', 'option=com_weblinks', 0, 0, '', 
'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/component.png', 0, 'show_comp_description=1\ncomp_description=\nshow_link_hits=1
\nshow_link_description=1\nshow_other_cats=1
\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n', 1);
INSERT INTO `jos_components` VALUES (5, 'Links', '', 0, 4, 'option=com_weblinks', 
'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '', 1);
INSERT INTO `jos_components` VALUES (6, 'Categories', '', 0, 4, 'option=com_categories&section=com_weblinks', 
'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1);

The SQL to create the weblinks table:

CREATE TABLE IF NOT EXISTS `jos_weblinks` (
  `id` int(11) 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) 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',
  `published` 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',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

If you want the example date, use the following SQL:

INSERT INTO `jos_weblinks` VALUES(1, 2, 0, 'Joomla!', 'joomla', 'http://www.joomla.org', 'Home of Joomla!', '2005-02-14 15:19:02', 5, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0');
INSERT INTO `jos_weblinks` VALUES(2, 2, 0, 'php.net', 'php', 'http://www.php.net', 'The language that Joomla! is developed in', '2004-07-07 11:33:24', 8, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, '');
INSERT INTO `jos_weblinks` VALUES(3, 2, 0, 'MySQL', 'mysql', 'http://www.mysql.com', 'The database that Joomla! uses', '2004-07-07 10:18:31', 3, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, '');
INSERT INTO `jos_weblinks` VALUES(4, 2, 0, 'OpenSourceMatters', 'opensourcematters', 'http://www.opensourcematters.org', 'Home of OSM', '2005-02-14 15:19:02', 13, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 'target=0');
INSERT INTO `jos_weblinks` VALUES(5, 2, 0, 'Joomla! - Forums', 'joomla-forums', 'http://forum.joomla.org', 'Joomla! Forums', '2005-02-14 15:19:02', 6, 1, 0, '0000-00-00 00:00:00', 4, 0, 1, 'target=0');
INSERT INTO `jos_weblinks` VALUES(6, 2, 0, 'Ohloh Tracking of Joomla!', 'ohloh-tracking-of-joomla', 'http://www.ohloh.net/projects/20', 'Objective reports from Ohloh about Joomla''s development activity. Joomla! has some star developers with serious kudos.', '2007-07-19 09:28:31', 3, 1, 0, '0000-00-00 00:00:00', 6, 0, 1, 'target=0\n\n');