Warnings in Maintenance Database

Need help with the Administration of your Joomla! 4.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
hajo70
Joomla! Apprentice
Joomla! Apprentice
Posts: 47
Joined: Fri Feb 12, 2016 3:02 pm

Warnings in Maintenance Database

Post by hajo70 » Sun Oct 02, 2022 11:39 am

I have the following warning messages in System-Maintenance-Database (sorry for not knowing how to show the warnings in a code box, attached them as a picture instead...)

All database table structures are up to date.
warning.jpg
And after that comes two "No problem" lines, Akeeba and Joomla CMS.

What does this depend on and how can I get rid of them?

Occured in my local test environment running on Win 11:
  • Wampserver 3.2.9
  • Apache 2.4.54
  • PHP 8.0.23
  • MySQL 8.0.30
You do not have the required permissions to view the files attached to this post.
Håkan, Sweden

Using Joomla to document restoration of a Mercedes-Benz from -57, https://www.mb219.com
Latest versions of Joomla, Akeeba, 4SEF, 4SEO, and SIGE-Simple Image Gallery Extended

hajo70
Joomla! Apprentice
Joomla! Apprentice
Posts: 47
Joined: Fri Feb 12, 2016 3:02 pm

Re: Warnings in Maintenance Database

Post by hajo70 » Sun Oct 02, 2022 11:53 am

Forum Post Assistant (v1.6.5) : 2-Oct-2022 wrote:
Last PHP Error(s) Reported :: wrote:[02-Oct-2022 11:13:22 UTC] PHP 12. Joomla\Component\Installer\Administrator\Model\DatabaseModel->fetchSchemaCache($cid = *uninitialized*) C:\wamp64\www\mb219dev\administrator\components\com_installer\src\Model\DatabaseModel.php:322
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.2.3-Stable (Uaminifu) 27-September-2022
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: true | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: simple | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.2.3: Yes | Database Supports J! 4.2.3: Yes | Database Credentials Present: Password missing |

Host Configuration :: OS: Windows NT | OS Version: 10.0 | Technology: AMD64 | Web Server: Apache/2.4.54 (Win64) OpenSSL/1.1.1o PHP/8.0.23 mod_fcgid/2.3.10-dev | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 200.43 GiB |

PHP Configuration :: Version: 8.0.23 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 32767 | Log Errors To: c:/wamp64/logs/php_error.log | Last Known Error: 02nd October 2022 11:13:22. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 64M | Max. POST Size: 64M | Max. Input Time: 60 | Max. Execution Time: 120 | Memory Limit: 128M

Database Configuration :: Version: 8.0.30 (Client:mysqlnd 8.0.23) | Database Size: 38.42 MiB | #of Tables with config prefix:  119 | #of other Tables:  0 | User Privileges : GRANT PROXY
Detailed Environment :: wrote:PHP Extensions :: Core (8.0.23) | bcmath (8.0.23) | calendar (8.0.23) | ctype (8.0.23) | date (8.0.23) | filter (8.0.23) | hash (8.0.23) | iconv (8.0.23) | json (8.0.23) | SPL (8.0.23) | pcre (8.0.23) | readline (8.0.23) | Reflection (8.0.23) | session (8.0.23) | standard (8.0.23) | mysqlnd (mysqlnd 8.0.23) | tokenizer (8.0.23) | zip (1.19.5) | zlib (8.0.23) | libxml (8.0.23) | dom (20031129) | PDO (8.0.23) | bz2 (8.0.23) | SimpleXML (8.0.23) | xml (8.0.23) | xmlreader (8.0.23) | xmlwriter (8.0.23) | apache2handler (8.0.23) | openssl (8.0.23) | curl (8.0.23) | com_dotnet (8.0.23) | fileinfo (8.0.23) | gd (8.0.23) | gettext (8.0.23) | gmp (8.0.23) | intl (8.0.23) | imap (8.0.23) | ldap (8.0.23) | mbstring (8.0.23) | exif (8.0.23) | mysqli (8.0.23) | Phar (8.0.23) | pdo_mysql (8.0.23) | pdo_sqlite (8.0.23) | soap (8.0.23) | sockets (8.0.23) | sqlite3 (8.0.23) | xsl (8.0.23) | Zend OPcache (8.0.23) | xdebug (3.1.5) | Zend Engine (4.0.23) |
Potential Missing Extensions ::

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

Apache Modules :: core | mod_win32 | mpm_winnt | http_core | mod_so | mod_access_compat | mod_actions | mod_alias | mod_allowmethods | mod_asis | mod_auth_basic | mod_auth_digest | mod_authn_core | mod_authn_file | mod_authz_core | mod_authz_groupfile | mod_authz_host | mod_authz_user | mod_autoindex | mod_cache | mod_cache_disk | mod_cgi | mod_dir | mod_env | mod_file_cache | mod_include | mod_isapi | mod_log_config | mod_mime | mod_negotiation | mod_rewrite | mod_setenvif | mod_socache_shmcb | mod_ssl | mod_userdir | mod_vhost_alias | mod_php | mod_fcgid | Apache/2.4.54 (Win64) OpenSSL/1.1.1o PHP/8.0.23 mod_fcgid/2.3.10-dev |
Potential Missing Modules :: mod_expires | mod_deflate |
Folder Permissions :: wrote:Core Folders :: images/ (Writable) | components/ (Writable) | modules/ (Writable) | plugins/ (Writable) | language/ (Writable) | templates/ (Writable) | cache/ (Writable) | logs/ (Writable) | tmp/ (Writable) | administrator/components/ (Writable) | administrator/modules/ (Writable) | administrator/language/ (Writable) | administrator/templates/ (Writable) | administrator/logs/ (Writable) |
Database Information :: wrote:Database statistics :: Uptime: 8364 | Threads: 2 | Questions: 57804 | Slow queries: 0 | Opens: 1651 | Flush tables: 3 | Open tables: 1293 | Queries per second avg: 6.911 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party::

Components :: Admin ::
Core :: com_actionlogs (3.9.0) 1 | com_admin (4.0.0) 1 | com_ajax (4.0.0) 1 | com_associations (4.0.0) 1 | com_banners (4.0.0) 1 | com_cache (4.0.0) 1 | com_categories (4.0.0) 1 | com_checkin (4.0.0) 1 | com_config (4.0.0) 1 | com_content (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_finder (4.0.0) 1 | com_installer (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_languages (4.0.0) 1 | com_login (4.0.0) 1 | com_mails (4.0.0) 1 | com_media (3.0.0) 1 | com_menus (4.0.0) 1 | com_messages (4.0.0) 1 | com_modules (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_plugins (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_privacy (3.9.0) 1 | com_redirect (4.0.0) 1 | com_scheduler (4.1.0) 1 | com_search (4.0.0-dev) 1 | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_users (4.0.0) 1 | com_workflow (4.0.0) 1 | com_wrapper (4.0.0) 1 |
3rd Party:: com_akeebabackup (9.3.2) 1 | com_forsef (1.1.0.341) 1 | com_forseo (4.0.1.1823) 1 | com_sige (4.2.2.2-PRO) 1 |

Modules :: Site ::
Core :: mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (4.0.0-dev) 0 | mod_stats (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party::

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

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

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_captcha_recaptcha (3.4.0) 1 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 0 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 0 | plg_finder_tags (3.0.0) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_multifactorauth_email (4.2.0) 0 | plg_multifactorauth_fixed (4.2.0) 0 | plg_multifactorauth_totp (3.2.0) 0 | plg_multifactorauth_webauthn (4.2.0) 0 | plg_multifactorauth_yubikey (3.2.0) 0 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_search_categories (4.0.0-dev) 0 | plg_search_contacts (4.0.0-dev) 0 | plg_search_content (4.0.0-dev) 0 | plg_search_newsfeeds (4.0.0-dev) 0 | plg_search_tags (4.0.0-dev) 0 | plg_system_accessibility (4.0.0) 0 | plg_system_actionlogs (3.9.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_httpheaders (4.0.0) 0 | plg_system_jooa11y (4.2.0) 1 | plg_system_languagecode (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_redirect (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_shortcut (4.2.0) 1 | plg_system_skipto (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_task_notification (4.1) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_webauthn (4.0.0) 1 | plg_task_check_files (4.1) 1 | plg_task_demo_tasks (4.1) 1 | plg_task_requests (4.1) 1 | plg_task_site_status (4.1) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_token (3.9.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_modules (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 |
3rd Party:: plg_content_sige (4.2.2.2-PRO) 1 | plg_editors_codemirror (5.65.6) 1 | plg_editors_tinymce (5.10.5) 1 | PLG_INSTALLER_FORSEF (1.1.0.341) 1 | PLG_INSTALLER_FORSEO (4.0.1.1823) 1 | KRPU - Kubik-Rubik Pro Updater (4.0.0.1) 1 | PLG_QUICKICON_AKEEBABACKUP (9.3.2) 1 | PLG_SYSTEM_FORSEF (1.1.0.341) 1 | PLG_SYSTEM_FORSEO (4.0.1.1823) 1 |
Templates Discovered :: wrote:Templates :: Site :: cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |
Håkan, Sweden

Using Joomla to document restoration of a Mercedes-Benz from -57, https://www.mb219.com
Latest versions of Joomla, Akeeba, 4SEF, 4SEO, and SIGE-Simple Image Gallery Extended

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 8152
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Warnings in Maintenance Database

Post by AMurray » Sun Oct 02, 2022 12:44 pm

I'm not sure if Joomla runs well on MySQL 8.x - the recommended version is still 5.6+/5.7+ (logically including 8.x) but can you try switching back to MySQL 5.x? More to the point, do you see the same errors under MySQL 5.6.x? The switch back may involve restoring a backup to the localhost environment when you're running MySQL 5.x, I don't think the databases can be transferred across when you select the different MySQL version, and the only way is restoring the Akeeba Backup.

Even if Joomla runs fine in MySQL 8, it may be some of your extensions don't.

This is the docs I can find regarding MySQL 8.x and Joomla:
https://docs.joomla.org/Joomla_and_MySQL_8

Given you appear to be running this Joomla install on a local server like XAMPP (?) it may make it easier to adjust the MySQL 8 as detailed in the above link (if required).

That stack trace looks like it comes from Debug; can you see if you have debug turned on, in the PHP options (or switch the error reporting to a lower setting like "default")
Regards - A Murray

hajo70
Joomla! Apprentice
Joomla! Apprentice
Posts: 47
Joined: Fri Feb 12, 2016 3:02 pm

Re: Warnings in Maintenance Database

Post by hajo70 » Sun Oct 02, 2022 12:52 pm

I don't know why I thought MySQL v8 was a good idea to use... I'll go back to v5 next time I do a restore! Thanks.

And yes, error reporting in Joomla was on Simple and by setting it to Default the message disappeared. I assume the error is still there then but I don't really have to care about it (if it's still there after switch to MySQL v5?!
Håkan, Sweden

Using Joomla to document restoration of a Mercedes-Benz from -57, https://www.mb219.com
Latest versions of Joomla, Akeeba, 4SEF, 4SEO, and SIGE-Simple Image Gallery Extended

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 29475
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Warnings in Maintenance Database

Post by Per Yngve Berg » Sun Oct 02, 2022 7:34 pm

Memory Limit: 128M

Should be 256M in J4 for reliable updating.


Post Reply

Return to “Administration Joomla! 4.x”