No contacts in the admin panel after upgrading from Joomla 3.10.4 to 4 Topic is solved

[sylwekb]

Hello
I updated Joomla from version 3.10.4 to the newest version 4 and ran into a problem because contacts cannot be seen in the admin panel. The contacts, however, are visible from the front. How can I fix it. Are contacts now in a different place than in the previous version of Joomla? I have attached a screenshot from the admin panel.

php 7.4.7

[ceford]

Your Contacts menu is missing two sub-menu items: Contacts and Categories. You could just type in the url to see if you get your contacts list: administrator/index.php?option=com_contact&view=contacts

[sylwekb]

Yes, it works for me. The quickest way would be to add the missing ones via phpmyadmin. Do you remember in which table they are stored?

[ceford]

The entries are in #__menu - but what else might be missing and why?

[sylwekb]

Weird, these entries are phpmyadmin. So what causes these 2 menu items to be hidden in the admin panel?

[ceford]

Is published set 1?

[sylwekb]

Yes, published set 1. I have no more idea what it might be. You don't see them on the admin panel menu.

[ceford]

Switch on Debug mode and have a look at the list of queries on load of Home dashboard. For me the last one in the list is the Menu fetch query. I copied and pasted it into phpMyAdmin and got 20 rows. I had to change menutype to 'main':

Code: Select all

SELECT `m`.*,`e`.`element`
FROM `xxxx_menu` AS `m`
LEFT JOIN `xxxx_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE 
(`m`.`menutype` = 'main' AND `m`.`client_id` = 1 AND `m`.`id` > 1) AND 
(`e`.`enabled` = 1 OR `e`.`enabled` IS NULL)
ORDER BY `m`.`lft`

where xxxx is your database prefix.

[sylwekb]

I set up the Server tab in the Global Configuration screen and set error reporting to Maximum. I don't know how to find it. From the front, or the admin panel, I have no error. I don't know how to trigger this operation.

[ceford]

Enable the Plugin: System - Debug. In the bottom left corner of your screen you will see a small square Joomla icon. Click it to open the Debug panel. Select Queries to see the database queries used on the page just loaded.

What we need to know is how your query differs from mine for the menu.

[sylwekb]

Of course, I have the debug plugin enabled, but I cannot locate the button at the bottom left of the button. I cannot locate this icon.

[ceford]

Have you set Debug System to Yes in Global Configuration?

Also, try that query I quoted in phpMyAdmin with your own database prefix. If the two missing menu items are still missing then we know it is the data that is at fault. Look at the WHERE item values in the tables. There may be something amiss with the com_content values.

[sylwekb]

There is already an icon. Fatigue after a week of work. What to click?

[ceford]

Queries gives you a list of queries used - for me it was the last one to look at and copy to use in phpMyAdmin.

[sylwekb]

I made your query, added my prefix, below is the phpmyadmin result. These 2 menus are missing

Code: Select all

id	menutype	title	alias	note	path	link	type	published	parent_id	level	component_id	checked_out	checked_out_time	browserNav	access	img	template_style_id	params	lft Rosnąco 1	rgt	home	language	client_id	publish_up	publish_down	element 	

197 	main 	com_banners 	Banners 		Banners/Banners 	index.php?option=com_banners&view=banners 	component 	1 	2 	2 	4 	NULL 	NULL 	0 	0 	class:banners 	0 		14 	15 	0 	* 	1 	NULL 	NULL 	com_banners

198 	main 	com_banners_categories 	Categories 		Banners/Categories 	index.php?option=com_categories&view=categories&ex... 	component 	1 	2 	2 	6 	NULL 	NULL 	0 	0 	class:banners-cat 	0 		16 	17 	0 	* 	1 	NULL 	NULL 	com_categories

199 	main 	com_banners_clients 	Clients 		Banners/Clients 	index.php?option=com_banners&view=clients 	component 	1 	2 	2 	4 	NULL 	NULL 	0 	0 	class:banners-clients 	0 		18 	19 	0 	* 	1 	NULL 	NULL 	com_banners

200 	main 	com_banners_tracks 	Tracks 		Banners/Tracks 	index.php?option=com_banners&view=tracks 	component 	1 	2 	2 	4 	NULL 	NULL 	0 	0 	class:banners-tracks 	0 		20 	21 	0 	* 	1 	NULL 	NULL 	com_banners

202 	main 	com_contact 	Contacts 		Contacts/Contacts 	index.php?option=com_contact&view=contacts 	component 	1 	7 	2 	8 	NULL 	NULL 	0 	0 	class:contact 	0 		24 	25 	0 	* 	1 	NULL 	NULL 	com_contact

203 	main 	com_contact_categories 	Categories 		Contacts/Categories 	index.php?option=com_categories&view=categories&ex... 	component 	1 	7 	2 	6 	NULL 	NULL 	0 	0 	class:contact-cat 	0 		26 	27 	0 	* 	1 	NULL 	NULL 	com_categories

208 	main 	com_newsfeeds_feeds 	Feeds 		News Feeds/Feeds 	index.php?option=com_newsfeeds&view=newsfeeds 	component 	1 	13 	2 	17 	NULL 	NULL 	0 	0 	class:newsfeeds 	0 		36 	37 	0 	* 	1 	NULL 	NULL 	com_newsfeeds

209 	main 	com_newsfeeds_categories 	Categories 		News Feeds/Categories 	index.php?option=com_categories&view=categories&ex... 	component 	1 	13 	1 	6 	NULL 	NULL 	0 	0 	class:newsfeeds-cat 	0 		37 	38 	0 	* 	1 	NULL 	NULL 	com_categories

196 	main 	com_banners 	Banners 		Banners 	index.php?option=com_banners 	component 	1 	1 	1 	4 	NULL 	NULL 	0 	0 	class:bookmark 	0 		43 	44 	0 	* 	1 	NULL 	NULL 	com_banners

201 	main 	com_contact 	Contacts 		Contacts 	index.php?option=com_contact 	component 	1 	1 	1 	8 	NULL 	NULL 	0 	0 	class:address-book 	0 		49 	56 	0 	* 	1 	NULL 	NULL 	com_contact

445 	main 	- 	1642169299-4386 		Contacts/1642169299-4386 	# 	separator 	1 	201 	2 	33 	NULL 	NULL 	0 	0 		0 	{} 	50 	51 	0 	* 	1 	NULL 	NULL 	com_fields

446 	main 	mod_menu_fields 	contact-custom-fields 		Contacts/contact-custom-fields 	index.php?option=com_fields&context=com_contact.co... 	component 	1 	201 	2 	33 	NULL 	NULL 	0 	0 		0 	{} 	52 	53 	0 	* 	1 	NULL 	NULL 	com_fields

447 	main 	mod_menu_fields_group 	contact-custom-fields-group 		Contacts/contact-custom-fields-group 	index.php?option=com_fields&view=groups&context=co... 	component 	1 	201 	2 	33 	NULL 	NULL 	0 	0 		0 	{} 	54 	55 	0 	* 	1 	NULL 	NULL 	com_fields

207 	main 	com_newsfeeds 	News Feeds 		News Feeds 	index.php?option=com_newsfeeds 	component 	1 	1 	1 	17 	NULL 	NULL 	0 	0 	class:rss 	0 		57 	58 	0 	* 	1 	NULL 	NULL 	com_newsfeeds

215 	main 	com_finder 	Smart Search 		Smart Search 	index.php?option=com_finder 	component 	1 	1 	1 	27 	NULL 	NULL 	0 	0 	class:search-plus 	0 		59 	70 	0 	* 	1 	NULL 	NULL 	com_finder

448 	main 	- 	1642169299-4395 		Smart Search/1642169299-4395 	# 	separator 	1 	215 	2 	27 	NULL 	NULL 	0 	0 		0 	{} 	60 	61 	0 	* 	1 	NULL 	NULL 	com_finder

449 	main 	com_finder_index 	smart-search-index 		Smart Search/smart-search-index 	index.php?option=com_finder&view=index 	component 	1 	215 	2 	27 	NULL 	NULL 	0 	0 		0 	{} 	62 	63 	0 	* 	1 	NULL 	NULL 	com_finder

450 	main 	com_finder_maps 	smart-search-maps 		Smart Search/smart-search-maps 	index.php?option=com_finder&view=maps 	component 	1 	215 	2 	27 	NULL 	NULL 	0 	0 		0 	{} 	64 	65 	0 	* 	1 	NULL 	NULL 	com_finder

451 	main 	com_finder_filters 	smart-search-filters 		Smart Search/smart-search-filters 	index.php?option=com_finder&view=filters 	component 	1 	215 	2 	27 	NULL 	NULL 	0 	0 		0 	{} 	66 	67 	0 	* 	1 	NULL 	NULL 	com_finder

452 	main 	com_finder_searches 	smart-search-searches 		Smart Search/smart-search-searches 	index.php?option=com_finder&view=searches 	component 	1 	215 	2 	27 	NULL 	NULL 	0 	0 		0 	{} 	68 	69 	0 	* 	1 	NULL 	NULL 	com_finder

226 	main 	com_tags 	Tags 		Tags 	index.php?option=com_tags&view=tags 	component 	1 	1 	1 	29 	NULL 	NULL 	0 	1 	class:tags 	0 		95 	96 	0 		1 	NULL 	NULL 	com_tags

214 	main 	com_weblinks_categories 	Categories 		administrator-othermenu-18/Categories 	index.php?option=com_categories&extension=com_webl... 	component 	1 	18 	2 	6 	NULL 	NULL 	0 	0 	class:weblinks-cat 	0 		120 	121 	0 	* 	1 	NULL 	NULL 	com_categories

316 	main 	com_associations 	multilingual-associations 		multilingual-associations 	index.php?option=com_associations 	component 	1 	1 	1 	34 	NULL 	NULL 	0 	1 	class:associations 	0 	{} 	161 	162 	0 	* 	1 	NULL 	NULL 	com_associations

437 	main 	COM_ROUTE66 	com-route66 		com-route66 	index.php?option=com_route66 	component 	1 	1 	1 	10046 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	163 	176 	0 		1 	NULL 	NULL 	com_route66

438 	main 	COM_ROUTE66_URLS 	com-route66-urls 		com-route66/com-route66-urls 	index.php?option=com_route66&view=urls 	component 	1 	437 	2 	10046 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	164 	165 	0 		1 	NULL 	NULL 	com_route66

439 	main 	COM_ROUTE66_SEO_SCORES 	com-route66-seo-scores 		com-route66/com-route66-seo-scores 	index.php?option=com_route66&view=seo 	component 	1 	437 	2 	10046 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	166 	167 	0 		1 	NULL 	NULL 	com_route66

440 	main 	COM_ROUTE66_SEO_ANALYSIS 	com-route66-seo-analysis 		com-route66/com-route66-seo-analysis 	index.php?option=com_route66&view=analysis 	component 	1 	437 	2 	10046 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	168 	169 	0 		1 	NULL 	NULL 	com_route66

441 	main 	COM_ROUTE66_SITEMAPS 	com-route66-sitemaps 		com-route66/com-route66-sitemaps 	index.php?option=com_route66&view=sitemaps 	component 	1 	437 	2 	10046 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	170 	171 	0 		1 	NULL 	NULL 	com_route66

442 	main 	COM_ROUTE66_FACEBOOK_INSTANT_ARTICLES 	com-route66-facebook-instant-articles 		com-route66/com-route66-facebook-instant-articles 	index.php?option=com_route66&view=instantarticlesf... 	component 	1 	437 	2 	10046 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	172 	173 	0 		1 	NULL 	NULL 	com_route66

443 	main 	COM_ROUTE66_GOOGLE_PAGESPEED 	com-route66-google-pagespeed 		com-route66/com-route66-google-pagespeed 	index.php?option=com_route66&view=googlepagespeed 	component 	1 	437 	2 	10046 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	174 	175 	0 		1 	NULL 	NULL 	com_route66

453 	main 	Search 	search 		search 	index.php?option=com_search 	component 	1 	1 	1 	19 	NULL 	NULL 	0 	1 	class:search 	0 	{} 	177 	178 	0 		1 	NULL 	NULL 	com_search

454 	main 	com_weblinks 	com-weblinks 		com-weblinks 	index.php?option=com_weblinks 	component 	1 	1 	1 	21 	NULL 	NULL 	0 	1 	class:weblinks 	0 	{} 	179 	188 	0 		1 	NULL 	NULL 	com_weblinks

455 	main 	com_weblinks_links 	com-weblinks-links 		com-weblinks/com-weblinks-links 	index.php?option=com_weblinks 	component 	1 	454 	2 	21 	NULL 	NULL 	0 	1 	class:weblinks 	0 	{} 	180 	181 	0 		1 	NULL 	NULL 	com_weblinks

456 	main 	com_weblinks_categories 	com-weblinks-categories 		com-weblinks/com-weblinks-categories 	index.php?option=com_categories&extension=com_webl... 	component 	1 	454 	2 	21 	NULL 	NULL 	0 	1 	class:weblinks-cat 	0 	{} 	182 	183 	0 		1 	NULL 	NULL 	com_weblinks

457 	main 	com_weblinks_fields 	com-weblinks-fields 		com-weblinks/com-weblinks-fields 	index.php?option=com_fields&view=fields&context=co... 	component 	1 	454 	2 	21 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	184 	185 	0 		1 	NULL 	NULL 	com_weblinks

458 	main 	com_weblinks_field_groups 	com-weblinks-field-groups 		com-weblinks/com-weblinks-field-groups 	index.php?option=com_fields&view=groups&context=co... 	component 	1 	454 	2 	21 	NULL 	NULL 	0 	1 	class:component 	0 	{} 	186 	187 	0 		1 	NULL 	NULL 	com_weblinks
	

[ceford]

I can see problems in your table data: the menu items are not in the right order, for example id 201 occurs after 202 and 203; and 202 (in a new install) should have com_contact_contacts as title rather than com_contact.

What happens if you go to Menus/All Menu Items select Administrator and click Rebuild? I don't really expect it to make any difference. Clutching at straws!

Note: the items are present but incorrect.

[sylwekb]

Unfortunately, I'm empty. I rebuilt it anyway. However, it did not help.

[ceford]

In the menus table try changing 202 title from com_contact to com_contact_contacts

[sylwekb]

Unfortunately, the same after the change.

[ceford]

I see another problem in your query result: lft Rosnąco 1 as a field name - it is supposed to be lft and that is used in parent-child relationships. So I wonder how it got there: is it an extension related change, recently or at some time in the past?

[sylwekb]

The site has been migrated since the oldest times, initially from the Joomla 1.5 version through individual versions, always uploaded current updates that appeared. There were no manual modifications to the database. Everything was always right. Contacts were available until the problem occurred with Joomla 4.0.5. Is there any way to fix it? I would not like to rebuild the page because of the large amount of data that has been migrated.

[ceford]

I recommend you make a copy of the #__menu table (such as #__menu_bak).

If that column heading really is lft Rosnąco 1 then something must have gone wrong in the past. Rosnąco is Polish for ascending. And I doubt that the Rebuild button would work on the Site menu items.

So try changing lft Rosnąco 1 to lft in the #__menu table and see what happens.

[sylwekb]

I have php myadmin with comments in Polish. See I dumped the entire menu table and can't locate this lft. I attached a menu dump file in txt format because sql files cannot be uploaded in the joomla forum.

[ceford]

The dumped table looks good, except:

The params field is text in Joomla 4 but medium text in your version.

I added CREATE TABLE at the top and removed the last three lines starting /*!40101 SET

The problem is that both the Banners and Contacts parent lft/rgt values are wrong. I am not sure how best to correct them - still looking into it.

[sylwekb]

Indeed, the rest of the banners are also missing. Should expand into categories etc.

[ceford]

This is probably a crazy suggestion, but ...

I don't see any setting to allow adjustment of the order of the default Admin menu items. But you could make an entry in the menu_types table:

INSERT INTO `#xxxxx_menu_types` (`id`, `asset_id`, `menutype`, `title`, `description`, `client_id`) VALUES (NULL, '0', 'main', 'Admin Menu', 'The admin menu for the site', '1');

Then reload the Admin page and expand the Menu link to see an Admin menu link. Select to see the Component items, which you might be able to Rebuild and/or reorder by drag and drop. I say may because it does work with a menu that is not corrupted.

If it works - delete the item added to #xxxxx_menu_types.

[sylwekb]

Thank you very much!!! This allows you to fix such menu issues after migration.

[steepedincode]

...and 202 (in a new install) should have com_contact_contacts as title rather than com_contact.

On several Joomla 3 to 4 migrations this exact issue befuddled me for a while. Both the "Contacts" and "Categories" submenu items of "Contacts" were missing. This post from "ceford" began the fix for me.

Using one example, in the database I found two records titled "com_contacts". One for the path "Contacts" (id 107 in this example) and the other for the path "contact/Contacts" (id 108).

The following two steps fixes the issue for me:

1) Change the title for the path "contact/Contacts" to "com_contact_contacts".

2) The parent ID for both "com_contact_contacts" and "com_contact_categories" show an incorrect parent_id (7 instead of 107 in this example). Change to the correct parent ID for both child menu items. Issue fixed.

Attaching a screenshot from phpMyAdmin. Hope this helps anyone else running into this issue.

[sylwekb]

Yes, I had the same problem on many sites after migrating from Joomla 3.10 to 4.

[AloisEinser]

You deserve an order! Thank you so much!

It helped to insert this entry into the xxxxx_menu_types table to find the dependencies.

After that I had to fix the parent ID of several items in xxxxx_menu – by hand.

I have this problem with all Updates from Joomla 3 to Joomla 4 and I am not the only one.
I see a lot of questions but besides your solution there was no anwser that worked.

How can this happen? Are there more of such problems in Joomla 4?

This is probably a crazy suggestion, but ...

I don't see any setting to allow adjustment of the order of the default Admin menu items. But you could make an entry in the menu_types table:

INSERT INTO `#xxxxx_menu_types` (`id`, `asset_id`, `menutype`, `title`, `description`, `client_id`) VALUES (NULL, '0', 'main', 'Admin Menu', 'The admin menu for the site', '1');

Then reload the Admin page and expand the Menu link to see an Admin menu link. Select to see the Component items, which you might be able to Rebuild and/or reorder by drag and drop. I say may because it does work with a menu that is not corrupted.

If it works - delete the item added to #xxxxx_menu_types.