Difference between revisions of "Joomla Update Missing in from Admin Menu"

From Joomla! Documentation

m (Adjusted layout)
(6 intermediate revisions by 4 users not shown)
Line 4: Line 4:
  
 
<source lang="sql">
 
<source lang="sql">
UPDATE #_menu
+
UPDATE #__menu
 
SET component_id =
 
SET component_id =
   (SELECT extension_id from #_extensions WHERE name = "com_joomlaupdate")
+
   (SELECT extension_id from #__extensions WHERE name = "com_joomlaupdate")
 
WHERE title = "com_joomlaupdate"
 
WHERE title = "com_joomlaupdate"
 
</source>
 
</source>
Line 15: Line 15:
  
 
<source lang="sql">
 
<source lang="sql">
INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`,
+
INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`)  
`parent_id`, `level`, `component_id`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`,
+
VALUES ('menu', 'com_joomlaupdate', 'Joomla! Update', '', 'Joomla! Update', 'index.php?option=com_joomlaupdate', 'component', 0, 1, 1, (SELECT extension_id FROM #__extensions WHERE `name` = 'com_joomlaupdate'), 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:joomlaupdate', 0, '', 41, 42, 0, '*', 1);
`access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`)
 
VALUES (22, 'menu', 'com_joomlaupdate', 'Joomla! Update', '', 'Joomla! Update',
 
'index.php?option=com_joomlaupdate', 'component', 0, 1, 1, 28, 0, 0,
 
'0000-00-00 00:00:00', 0, 0, 'class:joomlaupdate', 0, '', 41, 42, 0, '*', 1);
 
 
</source>
 
</source>
  
Replace #__menu with the name of your database table. Under VALUES you need to change the id, component_id, lft and rgt to the appropriate values for your system.
+
Replace the "#_" of #__menu and #__extensions with the prefix of your database table (System --> Global Configuration --> Server --> Database Tables Prefix).
On a clean Joomla 2.5.6 install it looks like this:
 
  
[[File:backend menu.jpg]]
+
Example: vy2bp_menu and vy2bp_extensions (only one underline)
 
+
<noinclude>[[Category:Version 2.5 FAQ]]
[[Category:Version 2.5 FAQ]]
 
 
[[Category:Version 2.5.4 FAQ]]
 
[[Category:Version 2.5.4 FAQ]]
 
[[Category:Version 2.5.5 FAQ]]
 
[[Category:Version 2.5.5 FAQ]]
 
[[Category:Version 2.5.6 FAQ]]
 
[[Category:Version 2.5.6 FAQ]]
 +
[[Category:Update Working Group]]
 +
</noinclude>

Revision as of 18:40, 19 August 2014

Starting with version 2.5.4, the Joomla core is updated with the new component Joomla Update instead of in Extensions/Install/Update.

If Joomla Update does not shows as an installed component the menuitem could be wrong. Run this SQL statement:

UPDATE #__menu
SET component_id =
  (SELECT extension_id from #__extensions WHERE name = "com_joomlaupdate")
WHERE title = "com_joomlaupdate"

It should update 1 row, if not use the Discover function and install it as a component.

If Joomla Update shows as an installed component but is not in the Admin Menu under Components, you are missing the entry in the database table #__menu.

INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) 
VALUES ('menu', 'com_joomlaupdate', 'Joomla! Update', '', 'Joomla! Update', 'index.php?option=com_joomlaupdate', 'component', 0, 1, 1, (SELECT extension_id FROM #__extensions WHERE `name` = 'com_joomlaupdate'), 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:joomlaupdate', 0, '', 41, 42, 0, '*', 1);

Replace the "#_" of #__menu and #__extensions with the prefix of your database table (System --> Global Configuration --> Server --> Database Tables Prefix).

Example: vy2bp_menu and vy2bp_extensions (only one underline)