Joomla4 Upgrade issue

[northbra]

Error message :When I open an existing article and try to close it following error message appears: 1048 Column 'checked_out' cannot be null .

Joomla! Instance :: Joomla! 4.0.2-Stable (Furaha) 24-August-2021
Joomla! Configured :: Yes | Writable (666) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: N/A | FTP Layer: false | Proxy: N/A | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: N/A | SSL: 0 | Error Reporting: none | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.0.2: Yes | Database Supports J! 4.0.2: Yes | Database Credentials Present: Password missing |

Host Configuration :: OS: Windows NT | OS Version: 10.0 | Technology: AMD64 | Web Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25 | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 159.33 GiB |

PHP Configuration :: Version: 7.3.25 | PHP API: apache2handler | Session Path Writable: No | Display Errors: 0 | Error Reporting: 32767 | Log Errors To: C:\xampp\php\logs\php_error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 256M | Max. POST Size: 256M | Max. Input Time: 1000 | Max. Execution Time: 3000 | Memory Limit: 1024M

Database Configuration :: Version: 5.5.5-10.4.17-MariaDB (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | Database Size: 31.38 MiB | #of Tables with config prefix: 176 | #of other Tables: 353 | User Privileges : GRANT PROXY

PHP Extensions :: Core (7.3.25) | bcmath (7.3.25) | calendar (7.3.25) | ctype (7.3.25) | date (7.3.25) | filter (7.3.25) | hash (7.3.25) | iconv (7.3.25) | json (1.7.0) | SPL (7.3.25) | pcre (7.3.25) | readline (7.3.25) | Reflection (7.3.25) | session (7.3.25) | standard (7.3.25) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | tokenizer (7.3.25) | zip (1.15.4) | zlib (7.3.25) | libxml (7.3.25) | dom (20031129) | PDO (7.3.25) | bz2 (7.3.25) | SimpleXML (7.3.25) | xml (7.3.25) | wddx (7.3.25) | xmlreader (7.3.25) | xmlwriter (7.3.25) | apache2handler () | openssl (7.3.25) | curl (7.3.25) | fileinfo (7.3.25) | gd (7.3.25) | gettext (7.3.25) | mbstring (7.3.25) | exif (7.3.25) | mysqli (7.3.25) | pdo_mysql (7.3.25) | pdo_sqlite (7.3.25) | Phar (7.3.25) | ftp (7.3.25) | Zend Engine (3.3.25) |
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_authn_core | mod_authn_file | mod_authz_core | mod_authz_groupfile | mod_authz_host | mod_authz_user | mod_autoindex | mod_cgi | mod_dav_lock | mod_dir | mod_env | mod_headers | mod_include | mod_info | mod_isapi | mod_log_config | mod_cache_disk | mod_mime | mod_negotiation | mod_proxy | mod_proxy_ajp | mod_rewrite | mod_setenvif | mod_socache_shmcb | mod_ssl | mod_status | mod_php7 | Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25 |
Potential Missing Modules :: mod_expires | mod_deflate | mod_security | mod_evasive | mod_dosevasive | mod_qos | mod_userdir |

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

Elevated Permissions (First 10) :: .htpasswds/ (777) | administrator/ (777) | administrator/backups/ (777) | administrator/cache/ (777) | administrator/components/ (777) | administrator/components/com_actionlogs/ (777) | administrator/components/com_actionlogs/forms/ (777) | administrator/components/com_actionlogs/services/ (777) | administrator/components/com_actionlogs/src/ (777) | administrator/components/com_actionlogs/src/Controller/ (777) |

Database statistics :: Uptime: 130 | Threads: 7 | Questions: 77 | Slow queries: 0 | Opens: 733 | Flush tables: 1 | Open tables: 543 | Queries per second avg: 0.592 |

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

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.2) 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_search (3.0.0) 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:: Akeeba (8.0.10) 1 | com_jaextmanager (2.5.3) 1 | com_jaextmanager (2.7.1) 1 | COM_JCE (2.9.14) 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 (3.0.0) 1 | 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:: Smart Latest News (1.0.0) 0 |

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.0.1) ? | Regular Labs Library (21.8.25972) 0 |

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) ? | plg_api-authentication_basic (4.0.0) 1 | plg_api-authentication_token (4.0.0) 0 | 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) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 0 | 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_editors-xtd_weblink (3.7.0) 0 | plg_extension_finder (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) 0 | 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_repeatable (3.9.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) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_installer_folderinstaller (3.6.0) ? | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) ? | 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_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) 0 | plg_quickicon_eos310 (3.10.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 (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_tags (3.0.0) 0 | plg_system_accessibility (4.0.0) 0 | plg_system_actionlogs (3.9.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_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 1 | 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) 1 | plg_system_remember (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_skipto (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) 0 | plg_system_webauthn (4.0.0) 1 | plg_system_weblinks (3.7.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | 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) 0 | plg_webservices_banners (4.0.0) 0 | plg_webservices_config (4.0.0) 0 | plg_webservices_content (4.0.0) 1 | plg_webservices_installer (4.0.0) 0 | plg_webservices_languages (4.0.0) 0 | plg_webservices_menus (4.0.0) 0 | plg_webservices_messages (4.0.0) 0 | plg_webservices_modules (4.0.0) 0 | plg_webservices_newsfeeds (4.0.0) 0 | plg_webservices_plugins (4.0.0) 0 | plg_webservices_privacy (4.0.0) 0 | plg_webservices_redirect (4.0.0) 0 | plg_webservices_tags (4.0.0) 0 | plg_webservices_templates (4.0.0) 0 | plg_webservices_users (4.0.0) 0 | 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_jce (2.9.14) 1 | plg_editors_codemirror (5.62.2) 1 | plg_editors_jce (2.9.14) 1 | plg_editors_tinymce (5.8.2) 1 | plg_extension_jce (2.9.14) 1 | plg_fields_mediajce (2.9.14) 1 | plg_installer_jce (2.9.14) 1 | plg_quickicon_jce (2.9.14) 1 | PLG_JEV_SEARCH_TITLE (3.6.16) 0 | plg_system_jce (2.9.14) 1 | PLG_SYSTEM_REGULARLABS (21.8.25972) 0 |

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

[cmbay]

Thank you for supplying the Forum Post Assistant report but Yikes! look at all those elevated permissions. You'll want to fix those.

No database password assigned? In your hosting control panel, have you created a database user with full permissions?

You'll also want to move up to PHP version 7.4+.

[sozzled]

@cmbay: the "elevated permissions" are normal when using the FPA on a Windows PC-hosted platform (e.g. Wampserver, XAMPP, etc.) but it looks to me like the database does not support NULL values in the checked_out column for [the unspecified] table in the database. It's possible that the migration from J! 3.10 to J! 4.0 was not done properly using the Joomla! Update component (when the website was running J! 3.10).

[AMurray]

@cmbay "no database password" would also be normal on a localhost install (WAMPServer, XAMPP etc) on the OP's PC

[cmbay]

the "elevated permissions" are normal when using the FPA on a Windows PC-hosted platform...

Aaaah. Thank you.

It's possible that the migration from J! 3.10 to J! 4.0 was not done properly using the Joomla! Update component...

There's more from @northbra in another thread.

[sozzled]

Thanks, Andy. I figured that was the case about "missing passwords" on PC-hosted environments. As a quick test, I ran the FPA report on a PC-hosted J! 4 test site and it reports the same thing in the case where the SQL username (root) has no password:

fpaMissingPassword.png

(Although it flags it in orange font, not red). CORRECTION: It displays on the FPA panel in orange font (i.e. before you generate the forum post); the BBcode (used on this forum) generated by the FPA, however, displays the information in red-coloured font.

As a further comment (not wanting to contradict @cmbay's observation about PHP 7.3), PHP 7.3 should work fine with J! 4; theoretically, PHP 7.2.5 should work with J! 4 (but I wouldn't personally recommend using that version).

[sozzled]

Thanks, @cmbay: Yes, I thought I read something about NULL values being allowed but I couldn't remember where I read it. viewtopic.php?f=812&t=988520#p3639390

[northbra]

Still getting message 1048 Column 'checked_out' cannot be null . I imported a copy of my database into a clean install of 3.10.2 and used Joomla update to 4.0.3. What can I do to fix?

[AMurray]

Are all your 3.x extensions compatible - did it pass the pre-upgrade advisor test?

Did your previous 3.9.x site have additional extensions that you would have to run "discover install" on in 3.10.2 to get them reinstalled (since the core files of 3.10.2 would not have your third party extensions included).?

[northbra]

Yes probably, but I was trying to avoid any extensions that are not J4 compatabile.

[northbra]

Here is log file:

Joomla 4 upgrade error

1048 Column 'checked_out' cannot be null

Joomla! Instance :: Joomla! 4.0.3-Stable (Furaha) 12-September-2021
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: No | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.0.3: Yes | Database Supports J! 4.0.3: Yes | Database Credentials Present: Password missing |

Host Configuration :: OS: Windows NT | OS Version: 10.0 | Technology: AMD64 | Web Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25 | Encoding: gzip, deflate | System TMP Writable: Yes | Free Disk Space : 152.39 GiB |

PHP Configuration :: Version: 7.3.25 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: 32767 | Log Errors To: C:\xampp\php\logs\php_error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 40M | Max. POST Size: 40M | Max. Input Time: 60 | Max. Execution Time: 300 | Memory Limit: 512M

Database Configuration :: Version: 5.5.5-10.4.17-MariaDB (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | Database Size: 41.47 MiB | #of Tables with config prefix: 230 | #of other Tables: 353 | User Privileges : GRANT PROXY

PHP Extensions :: Core (7.3.25) | bcmath (7.3.25) | calendar (7.3.25) | ctype (7.3.25) | date (7.3.25) | filter (7.3.25) | hash (7.3.25) | iconv (7.3.25) | json (1.7.0) | SPL (7.3.25) | pcre (7.3.25) | readline (7.3.25) | Reflection (7.3.25) | session (7.3.25) | standard (7.3.25) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | tokenizer (7.3.25) | zip (1.15.4) | zlib (7.3.25) | libxml (7.3.25) | dom (20031129) | PDO (7.3.25) | bz2 (7.3.25) | SimpleXML (7.3.25) | xml (7.3.25) | wddx (7.3.25) | xmlreader (7.3.25) | xmlwriter (7.3.25) | apache2handler () | openssl (7.3.25) | curl (7.3.25) | fileinfo (7.3.25) | gd (7.3.25) | gettext (7.3.25) | mbstring (7.3.25) | exif (7.3.25) | mysqli (7.3.25) | pdo_mysql (7.3.25) | pdo_sqlite (7.3.25) | Phar (7.3.25) | ftp (7.3.25) | Zend Engine (3.3.25) |
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_authn_core | mod_authn_file | mod_authz_core | mod_authz_groupfile | mod_authz_host | mod_authz_user | mod_autoindex | mod_cgi | mod_dav_lock | mod_dir | mod_env | mod_headers | mod_include | mod_info | mod_isapi | mod_log_config | mod_cache_disk | mod_mime | mod_negotiation | mod_proxy | mod_proxy_ajp | mod_rewrite | mod_setenvif | mod_socache_shmcb | mod_ssl | mod_status | mod_php7 | Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25 |
Potential Missing Modules :: mod_expires | mod_deflate | mod_security | mod_evasive | mod_dosevasive | mod_qos | mod_userdir |

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

Elevated Permissions (First 10) :: administrator/ (777) | administrator/cache/ (777) | administrator/components/ (777) | administrator/components/com_actionlogs/ (777) | administrator/components/com_actionlogs/forms/ (777) | administrator/components/com_actionlogs/services/ (777) | administrator/components/com_actionlogs/src/ (777) | administrator/components/com_actionlogs/src/Controller/ (777) | administrator/components/com_actionlogs/src/Field/ (777) | administrator/components/com_actionlogs/src/Helper/ (777) |

Database statistics :: Uptime: 95264 | Threads: 7 | Questions: 133633 | Slow queries: 0 | Opens: 2307 | Flush tables: 1 | Open tables: 1921 | Queries per second avg: 1.402 |

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.2) 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_search (3.0.0) 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::

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 (3.0.0) 1 | 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::

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) ? | plg_api-authentication_basic (4.0.0) 1 | plg_api-authentication_token (4.0.0) 0 | 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) 0 | plg_captcha_recaptcha_invisible (3. 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 0 | 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) 0 | 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_repeatable (3.9.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) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_installer_folderinstaller (3.6.0) ? | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) ? | 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_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) 0 | plg_quickicon_eos310 (3.10.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 (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_tags (3.0.0) 0 | plg_system_accessibility (4.0.0) 0 | plg_system_actionlogs (3.9.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_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 1 | 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) 1 | plg_system_remember (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_skipto (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) 0 | plg_system_webauthn (4.0.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | 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) 0 | plg_webservices_banners (4.0.0) 0 | plg_webservices_config (4.0.0) 0 | plg_webservices_content (4.0.0) 1 | plg_webservices_installer (4.0.0) 0 | plg_webservices_languages (4.0.0) 0 | plg_webservices_menus (4.0.0) 0 | plg_webservices_messages (4.0.0) 0 | plg_webservices_modules (4.0.0) 0 | plg_webservices_newsfeeds (4.0.0) 0 | plg_webservices_plugins (4.0.0) 0 | plg_webservices_privacy (4.0.0) 0 | plg_webservices_redirect (4.0.0) 0 | plg_webservices_tags (4.0.0) 0 | plg_webservices_templates (4.0.0) 0 | plg_webservices_users (4.0.0) 0 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 |
3rd Party:: plg_editors_codemirror (5.62.2) 1 | plg_editors_tinymce (5.8.2) 1 |

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

[northbra]

Do I need to remove extensions that are identified in the Pre Update check as Update information unavailable, or can I just disable them for the update?

[cmbay]

Do I need to remove extensions that are identified in the Pre Update check as Update information unavailable, or can I just disable them for the update?

In my limited experience in Joomla 4 migrations, I suggest uninstalling those extensions. In some cases (for example, JQueryEasy 4.2.2), I found that I was not able to uninstall the extensions in Joomla 4.