Akeeba Admin Tools Error building Administrator Menus. Topic is solved

[herby1961]

I updated Akeeba Admin Tools to Version 7.4.8. Installation looks ok but i don't get the Admin Tools Menu in the Components in the Administrator Backend.

I get the following error messages:
Error building Administrator Menus.
23000, 1062, Duplicate entry '1-1-com-admintools-' for key 'idx_client_id_parent_id_alias_language'

Akebba support linked me to joomla support because he said that the error messages come from the joomla core. But i find no entries in the ##_menu table from admin tools. See attached Menu Table.txt and the screenshot of the errormessages. I have executed the FPA-EN script and saved the output. where can i upload the generated pdf because the file is to large to upload here.

regards
Herbert

[herby1961]

PHP Version 8.2.7
Joomla 4.4.3

[herby1961]

Joomla! Instance :: Joomla! 4.4.3-Stable (Pamoja) 20-February-2024
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: true | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: true | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 60 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: pdomysql | PHP Supports J! 4.4.3: Yes | Database Supports J! 4.4.3: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 6.1.0-18-amd64 | Technology: x86_64 | Web Server: Apache/2.4.57 (Debian) | Encoding: gzip, deflate, br, zstd | System TMP Writable: Yes | Free Disk Space : 76.39 GiB |

PHP Configuration :: Version: 8.2.7 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 16M | Max. POST Size: 16M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 128M

Database Configuration :: Version: 10.11.6-MariaDB-0+deb12u1 (Client:mysqlnd 8.2.7) | Database Size: 129.02 MiB | #of Tables with config prefix:  139 | #of other Tables:  111 | User Privileges : GRANT ALL

PHP Extensions :: Core (8.2.7) | date (8.2.7) | libxml (8.2.7) | openssl (8.2.7) | pcre (8.2.7) | zlib (8.2.7) | filter (8.2.7) | hash (8.2.7) | json (8.2.7) | random (8.2.7) | Reflection (8.2.7) | SPL (8.2.7) | session (8.2.7) | standard (8.2.7) | sodium (8.2.7) | apache2handler (8.2.7) | mysqlnd (mysqlnd 8.2.7) | PDO (8.2.7) | xml (8.2.7) | calendar (8.2.7) | ctype (8.2.7) | curl (8.2.7) | dom (20031129) | mbstring (8.2.7) | FFI (8.2.7) | fileinfo (8.2.7) | ftp (8.2.7) | gd (8.2.7) | gettext (8.2.7) | iconv (8.2.7) | exif (8.2.7) | mysqli (8.2.7) | pdo_mysql (8.2.7) | Phar (8.2.7) | posix (8.2.7) | readline (8.2.7) | shmop (8.2.7) | SimpleXML (8.2.7) | sockets (8.2.7) | sysvmsg (8.2.7) | sysvsem (8.2.7) | sysvshm (8.2.7) | tokenizer (8.2.7) | xmlreader (8.2.7) | xmlwriter (8.2.7) | xsl (8.2.7) | zip (1.21.1) | Zend OPcache (8.2.7) | Zend Engine (4.2.7) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: Maybe

Apache Modules :: core | mod_so | mod_watchdog | http_core | mod_log_config | mod_logio | mod_version | mod_unixd | mod_access_compat | mod_alias | mod_auth_basic | mod_authn_core | mod_authn_file | mod_authz_core | mod_authz_host | mod_authz_user | mod_autoindex | mod_deflate | mod_dir | mod_env | mod_expires | mod_filter | mod_mime | prefork | mod_negotiation | mod_php | mod_reqtimeout | mod_rewrite | mod_setenvif | mod_socache_shmcb | mod_ssl | mod_status | Apache/2.4.57 (Debian) |
Potential Missing Modules ::

Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) | api/ (755) |

Elevated Permissions (First 10) :: administrator/components/com_akeebabackup/backup/ (777) | kicktemp/ (777) |

Database statistics :: Uptime: 171682 | Threads: 1 | Questions: 810365 | Slow queries: 0 | Opens: 447 | Open tables: 338 | Queries per second avg: 4.720 |

Components :: Site ::
Core ::
3rd Party:: WF_CHARMAP_TITLE (2.9.19) ? | WF_KITCHENSINK_TITLE (2.9.19) ? | WF_FORMATSELECT_TITLE (2.9.19) ? | WF_HELP_TITLE (2.9.19) ? | WF_FULLSCREEN_TITLE (2.9.19) ? | WF_CONTEXTMENU_TITLE (2.9.19) ? | WF_VISUALCHARS_TITLE (2.9.19) ? | WF_BROWSER_TITLE (2.9.19) ? | WF_NONBREAKING_TITLE (2.9.19) ? | WF_REFERENCE_TITLE (2.9.11) ? | WF_FONTCOLOR_TITLE (2.9.19) ? | WF_TEXTCASE_TITLE (2.9.19) ? | WF_WORDCOUNT_TITLE (2.9.19) ? | WF_PRINT_TITLE (2.9.19) ? | WF_MEDIA_TITLE (2.9.19) ? | WF_STYLE_TITLE (2.9.19) ? | WF_FONTSELECT_TITLE (2.9.19) ? | WF_TABLE_TITLE (2.9.19) ? | WF_SEARCHREPLACE_TITLE (2.9.19) ? | WF_ATTRIBUTES_TITLE (2.9.11) ? | WF_DIRECTIONALITY_TITLE (2.9.19) ? | JCE - Noneditable (1.0.0) ? | WF_EMOTIONS_TITLE (2.9.19) ? | WF_IMGMANAGER_TITLE (2.9.19) ? | WF_CLEANUP_TITLE (2.9.19) ? | WF_FONTSIZESELECT_TITLE (2.9.19) ? | WF_PREVIEW_TITLE (2.9.19) ? | WF_CLIPBOARD_TITLE (2.9.19) ? | WF_ANCHOR_TITLE (2.9.19) ? | WF_HR_TITLE (2.9.19) ? | WF_LISTS_TITLE (2.9.19) ? | WF_LAYER_TITLE (2.7.19) ? | WF_XHTMLXTRAS_TITLE (2.9.19) ? | WF_SOURCE_TITLE (2.9.19) ? | WF_STYLESELECT_TITLE (2.9.19) ? | WF_SPELLCHECKER_TITLE (2.9.19) ? | WF_LINK_TITLE (2.9.19) ? | WF_AUTOSAVE_TITLE (2.9.19) ? | WF_VISUALBLOCKS_TITLE (2.9.19) ? | WF_ARTICLE_TITLE (2.9.19) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.19) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.19) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.19) ? | WF_LINK_SEARCH_TITLE (2.9.19) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.19) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.19) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.19) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.19) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.19) ? |

Components :: Admin ::
Core :: com_scheduler (4.1.0) 1 | com_config (4.0.0) 1 | com_search (3.0.0) 1 | com_postinstall (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_menus (4.0.0) 1 | com_redirect (4.0.0) 1 | com_admin (4.0.0) 1 | com_finder (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_login (4.0.0) 1 | com_banners (4.0.0) 1 | com_modules (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_messages (4.0.0) 1 | com_checkin (4.0.0) 1 | com_categories (4.0.0) 1 | com_fields (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_ajax (4.0.0) 1 | com_users (4.0.0) 1 | com_media (3.0.0) 1 | com_installer (4.0.0) 1 | com_workflow (4.0.0) 1 | com_templates (4.0.0) 1 | com_privacy (3.9.0) 1 | com_mails (4.0.0) 1 | com_associations (4.0.0) 1 | com_content (4.0.0) 1 | com_languages (4.0.0) 1 | com_tags (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_actionlogs (3.9.0) 1 | com_guidedtours (4.3.0) 1 | com_plugins (4.0.0) 1 | com_cache (4.0.0) 1 |
3rd Party:: COM_JCE (2.9.19) 1 | com_admintools (7.4.8) 1 | com_akeebabackup (9.8.5) 1 | COM_EVENTGALLERY (5.3.1) 1 |

Modules :: Site ::
Core :: mod_articles_news (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_stats (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 |
3rd Party:: MOD_EVENTGALLERY_EVENTS (5.3.1) 1 | MOD_EVENTGALLERY_LATEST (5.3.1) 1 | MOD_EVENTGALLERY_EVENT (5.3.1) 1 | MOD_EVENTGALLERY_CATEGORIES (5.3.1) 1 | MOD_EVENTGALLERY_CART (5.3.1) 1 | MOD_YOOTHEME_BUILDER (4.3.8) 1 | MOD_EVENTGALLERY_CUSTOM (5.3.1) 1 |

Modules :: Admin ::
Core :: mod_multilangstatus (3.0.0) 1 | mod_privacy_status (4.0.0) 1 | mod_custom (3.0.0) 1 | mod_loginsupport (4.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_feed (3.0.0) 1 | mod_login (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_messages (4.0.0) 1 | mod_frontend (4.0.0) 1 | mod_version (3.0.0) 1 | mod_title (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_user (4.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_toolbar (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_guidedtours (4.3.0) 1 |
3rd Party:: MOD_YOOTHEME_LINK (4.3.8) 1 |

Libraries ::
Core ::
3rd Party:: file_fof40 (4.0.3) ? | file_fof30 (3.6.2) ? |

Plugins ::
Core :: plg_media-action_resize (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_actionlog_joomla (3.9.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_compat (4.4.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_token (3.9.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_multifactorauth_fixed (4.2.0) 0 | plg_multifactorauth_email (4.2.0) 0 | plg_multifactorauth_yubikey (3.2.0) 0 | plg_multifactorauth_webauthn (4.2.0) 0 | plg_multifactorauth_totp (3.2.0) 0 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_webservices_modules (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_eos (4.4.0) 1 | plg_task_demo_tasks (4.1) 1 | plg_task_check_files (4.1) 1 | plg_task_requests (4.1) 1 | plg_task_site_status (4.1) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_skipto (4.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_shortcut (4.2.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_httpheaders (4.0.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_jooa11y (4.2.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_guidedtours (4.3.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_task_notification (4.1) 1 | plg_system_log (3.0.0) 1 | plg_system_webauthn (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_actionlogs (3.9.0) 0 | plg_system_accessibility (4.0.0) 0 | plg_system_fields (3.7.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_content (3.0.0) 0 | plg_search_categories (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_override (4.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 |
3rd Party:: plg_extension_jce (2.9.19) 1 | PLG_EVENTGALLERY_SHIP_STANDARD (5.3.1) 1 | PLG_EVENTGALLERY_SHIP_EMAIL (5.3.1) 1 | PLG_EVENTGALLERY_SHIP_DOWNLOAD (5.3.1) 1 | PLG_ACTIONLOG_AKEEBABACKUP (9.8.5) 0 | PLG_ACTIONLOG_ADMINTOOLS (7.4.8) 0 | PLG_EVENTGALLERY_PAY_BRAINTREE (5.3.1) 1 | PLG_EVENTGALLERY_PAY_STANDARD (5.3.1) 1 | PLG_EVENTGALLERY_PAY_PAYPALBASIC (5.3.1) 1 | PLG_EVENTGALLERY_PAY_PAYPAL (5.3.1) 1 | PLG_EVENTGALLERY_PAY_STRIPE (5.3.1) 1 | PLG_EVENTGALLERY_SUR_STANDARD (5.3.1) 1 | PLG_EVENTGALLERY_CONTENT (5.3.1) 1 | PLG_EVENTGALLERY_MULTILANGCONTENT (5.3.1) 1 | plg_content_jce (2.9.19) 1 | EVENTGALLERY_FIELDS_CATEGORY (5.3.1) 1 | PLG_WEBSERVICES_AKEEBABACKUP (9.8.5) 1 | PLG_CONSOLE_AKEEBABACKUP (9.8.5) 1 | PLG_CONSOLE_ADMINTOOLS (7.4.8) 1 | plg_quickicon_jce (2.9.19) 1 | PLG_QUICKICON_AKEEBABACKUP (9.8.5) 1 | PLG_TASK_AKEEBABACKUP (9.8.5) 1 | PLG_TASK_ADMINTOOLS (7.4.8) 1 | PLG_EVENTGALLERY_FILE_FINDER (5.3.1) 0 | PLG_EVENTGALLERY_FINDER (5.3.1) 1 | System - YOOtheme Framework (4.3.8) 1 | PLG_SYSTEM_EVENTGALLERY_CAPABILITIE (5.3.1) ? | PLG_SYSTEM_PICASAUPDATER (5.3.1) 1 | plg_system_jce (2.9.19) 1 | PLG_SYSTEM_BACKUPONUPDATE (9.8.5) 1 | PLG_SYSTEM_ADMINTOOLS (7.4.8) 1 | PLG_SYSTEM_EVENTGALLERYCONSOLE (5.3.1) 1 | PLG_EVENTGALLERY_SEARCH_FILE (5.3.1) 0 | PLG_EVENTGALLERY_SEARCH (5.3.1) 1 | plg_editors_jce (2.9.19) 1 | plg_editors_tinymce (5.10.9) 1 | plg_editors_codemirror (5.65.15) 1 | PLG_INSTALLER_EVENTGALLERY (5.3.1) 1 | Installer - YOOtheme (1.0.7) 1 | plg_installer_jce (2.9.19) 1 | PLG_EDITORS-XTD_EVENTGALLERYIMAGE (5.3.1) 1 | PLG_EDITORS-XTD_EVENTGALLERY (5.3.1) 1 | Fields - YOOtheme Location (4.3.8) 1 | plg_fields_mediajce (2.9.19) 1 |

Templates :: Site :: YOOtheme (4.3.8) 1 | cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |

[herby1961]

Index idx_client_id_parent_id_alias_language for the ##__menu table was corrupted. rebuilding it and running the update of the admin tools again solved the problem