Can't update from j4.4.10 to j5.2.3

[smurfd]

My upgrade to j5 keeps failing. I use the "upload and update" option because I can't pass the "Database Table Structure Up to Date" check (even after doing the update structure option). There's also one extension in the "Update Required" category, CloudPanel. I don't know what this is, I can't update it, and I can't find it anywhere on the web server or database server. What do I need to do to get this update to work?

The second screenshot is the error log from a failed update.

[03-Feb-2025 15:40:32 UTC] PHP 5. Joomla\CMS\Uri\Uri::getInstance($uri = *uninitialized*) /data/www/html/new/libraries/src/Uri/Uri.php:133

Joomla! Instance :: Joomla! 4.4.10-Stable (Pamoja) 7-January-2025
Joomla! Configured :: Yes | Writable (644) |
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: false | FTP Layer: N/A | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.4.10: Yes | Database Supports J! 4.4.10: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 4.18.0-553.36.1.el8_10.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br, zstd | System TMP Writable: Yes | Free Disk Space : 40.28 GiB |

PHP Configuration :: Version: 8.2.25 | PHP API: fpm-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: /var/log/php-fpm/www-error.log | Last Known Error: 03rd February 2025 16:26:59. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 30M | Max. POST Size: 30M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 128M

Database Configuration :: Version: 8.0.36 (Client:mysqlnd 8.2.25) | Database Size: 13.20 MiB | #of Tables with config prefix:  170 | #of other Tables:  73 | User Privileges : GRANT ALL

PHP Extensions :: Core (8.2.25) | date (8.2.25) | libxml (8.2.25) | openssl (8.2.25) | pcre (8.2.25) | zlib (8.2.25) | filter (8.2.25) | hash (8.2.25) | json (8.2.25) | random (8.2.25) | Reflection (8.2.25) | SPL (8.2.25) | session (8.2.25) | standard (8.2.25) | cgi-fcgi (8.2.25) | bz2 (8.2.25) | calendar (8.2.25) | ctype (8.2.25) | curl (8.2.25) | dom (20031129) | mbstring (8.2.25) | fileinfo (8.2.25) | ftp (8.2.25) | gettext (8.2.25) | iconv (8.2.25) | exif (8.2.25) | mysqlnd (mysqlnd 8.2.25) | odbc (8.2.25) | PDO (8.2.25) | pgsql (8.2.25) | Phar (8.2.25) | posix (8.2.25) | shmop (8.2.25) | SimpleXML (8.2.25) | sockets (8.2.25) | sqlite3 (8.2.25) | sysvmsg (8.2.25) | sysvsem (8.2.25) | sysvshm (8.2.25) | tokenizer (8.2.25) | xml (8.2.25) | xmlwriter (8.2.25) | xsl (8.2.25) | mysqli (8.2.25) | pdo_mysql (8.2.25) | PDO_ODBC (8.2.25) | pdo_pgsql (8.2.25) | pdo_sqlite (8.2.25) | xmlreader (8.2.25) | apcu (5.1.23) | rrd (2.0.3) | zip (1.22.3) | Zend OPcache (8.2.25) | xdebug (3.2.2) | Zend Engine (4.2.25) |
Potential Missing Extensions :: gd |

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

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

Elevated Permissions (First 10) ::

Database statistics :: Uptime: 837501 | Threads: 2 | Questions: 14461466 | Slow queries: 0 | Opens: 2328 | Flush tables: 3 | Open tables: 1067 | Queries per second avg: 17.267 |

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

Components :: Admin ::
Core :: com_guidedtours (4.3.0) ? | com_privacy (3.9.0) 1 | com_associations (4.0.0) 1 | com_languages (4.0.0) 1 | com_plugins (4.0.0) 1 | com_actionlogs (3.9.0) 1 | com_contenthistory (4.0.0) 1 | com_mails (4.0.0) 1 | com_media (3.0.0) 1 | com_tags (4.0.0) 1 | com_menus (4.0.0) 1 | com_workflow (4.0.0) 1 | com_admin (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_users (4.0.0) 1 | com_config (4.0.0) 1 | com_redirect (4.0.0) 1 | com_content (4.0.0) 1 | com_cache (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_finder (4.0.0) 1 | com_login (4.0.0) 1 | com_banners (4.0.0) 1 | com_installer (4.0.0) 1 | com_modules (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_categories (4.0.0) 1 | com_templates (4.0.0) 1 | com_fields (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_checkin (4.0.0) 1 | com_ajax (4.0.0) 1 | com_messages (4.0.0) 1 | com_scheduler (4.1.0) ? |
3rd Party:: com_akeebabackup (9.9.11) 1 | COM_JCE (2.9.17) 1 | com_gantry5 (5.5.4) 1 | GRIDBOX (2.16.2.1) 1 | COM_CONVERTFORMS (4.4.8) 1 | com_maximenuck (10.1.12) 1 | Maximenu CK (10.1.12) 1 |

Modules :: Site ::
Core :: mod_articles_archive (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_login (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_languages (3.5.0) 1 | mod_articles_categories (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_random_image (3.0.0) 1 | mod_articles_popular (3.0.0) 1 |
3rd Party:: Minifrontpage (4.0.1) 1 | mod_convertforms (1.0) 1 | mod_gantry5_particle (5.5.4) 1 | Maximenu CK (10.1.12) 1 | mod_azdirectory (9.0.0) 1 |

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

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_multifactorauth_yubikey (3.2.0) ? | plg_multifactorauth_email (4.2.0) ? | plg_multifactorauth_webauthn (4.2.0) ? | plg_multifactorauth_fixed (4.2.0) ? | plg_multifactorauth_totp (3.2.0) ? | plg_fields_text (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_rotate (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 | plg_content_pagenavigation (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_vote (3.0.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_captcha_recaptcha (3.4.0) 0 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_modules (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_media (4.1.0) ? | plg_actionlog_joomla (3.9.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_token (3.9.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_tags (3.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_quickicon_eos (4.4.0) ? | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_system_guidedtours (4.3.0) ? | plg_system_shortcut (4.2.0) ? | plg_system_fields (3.7.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_logrotation (3.9.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_redirect (3.0.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_skipto (4.0.0) 1 | plg_system_actionlogs (3.9.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_webauthn (4.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_accessibility (4.0.0) 0 | plg_system_logout (3.0.0) 1 | plg_system_httpheaders (4.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_jooa11y (4.2.0) ? | plg_system_schedulerunner (4.1) ? | plg_system_task_notification (4.1) ? | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_behaviour_compat (4.4.0) ? | plg_behaviour_versionable (4.0.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_task_check_files (4.1) ? | plg_task_demo_tasks (4.1) ? | plg_task_requests (4.1) ? | plg_task_site_status (4.1) ? |
3rd Party:: plg_fields_mediajce (2.9.17) 1 | PLG_CONVERTFORMS_EMAILS (1.0) 1 | PLG_CONVERTFORMS_ACYMAILING (1.0) 1 | PLG_CONVERTFORMS_ERRORLOGGER (1.0) 1 | plg_content_jce (2.9.17) 1 | PLG_CONVERTFORMSTOOLS_PDF (1.0) 1 | PLG_CONVERTFORMSTOOLS_CALCULATIONS (1.0) 1 | PLG_CONVERTFORMSTOOLS_CONDITIONALLO (1.0) ? | PLG_CONVERTFORMSTOOLS_TASKS (1.0) 1 | Gridbox - Smart Search (2.15.0) 1 | Gridbox - Search (2.12.1) 1 | PLG_QUICKICON_AKEEBABACKUP (9.9.11) 1 | plg_quickicon_gantry5 (5.5.4) 1 | plg_quickicon_jce (2.9.17) 1 | CloudPanel (5.0) 1 | PLG_SYSTEM_CONVERTFORMS (1.0) 1 | System - Helix Ultimate Framework (2.1.1) 1 | Gridbox - System (2.16.1) 1 | plg_system_jce (2.9.17) 1 | plg_system_nrframework (5.0.74) 1 | plg_system_gantry5 (5.5.4) 1 | plg_installer_jce (2.9.17) 1 | PLG_EDITORS-XTD_CONVERTFORMS (1.0) 1 | plg_extension_jce (2.9.17) 1 | plg_editors_codemirror (5.65.15) 1 | plg_editors_tinymce (5.10.9) 1 | plg_editors_jce (2.9.17) 1 | plg_gantry5_preset (5.5.4) 0 | PLG_CONVERTFORMSAPPS_ACYMAILING (1.0) 1 | PLG_CONVERTFORMSAPPS_EMAIL (1.0) 1 |

Templates :: Site :: shaper_helixultimate (2.1.1) 1 | gridbox_testing (2.12.1) 1 | cassiopeia (1.0) 1 | Gridbox (2.16.2.1) 1 |
Templates :: Admin :: atum (1.0) 1 |

[AMurray]

CloudPanel seems to be your webhost (?) https://www.cloudpanel.io/docs/v2/php/a ... ns/joomla/
Perhaps some internal plugin installed by CloudPanel is causing the problems (the one your pre-update check says needs updating). Perhaps check with CloudPanel on that point.

If it's not a standard install of Joomla (i.e. installed through some quick start or via Cloudpanel itself) we may not be able to help because it's that third party that might be causing the problem with your update. I'd check with CloudPanel about the database issue as well. Joomla is simply reporting the problem, not necessarily the cause of the problem.

Can you backup the site, then restore it to "localhost" using WAMPServer on your PC, and try a standard, normal migration to J5? See if that works first. (see https://wampserver.aviatechno.net/?lang=en) for download of WAMPServer and its associated plugins and files).

[Per Yngve Berg]

Memory Limit: 128M

Needs to be at least 256M for J5

[smurfd]

I increased the memory limit to 256M, but that didn't work. I got the same error. Here's the full error. It was a little cut off in the initial post.

I'm fairly certain I don't use CloudPanel. I'm an admin on the webserver box and database box. I don't ever remember seeing anything like the screenshots on CloudPanel's website. I disabled the plugin, but it's still getting flagged during the update check. Any other ideas on how to proceed?

If it's helpful, after a failed update, I wipe out the website document root, copy in an Akeeba backup and restore using kickstarter.php. Should I be doing something to the database too?

[gws]

Yes you have to empty the DB after a failed upgrade when you are restoring.

[smurfd]

Wiped the database before restore. Same error.

[Per Yngve Berg]

Don't you find CloudPanel in Plugin Manager?

[smurfd]

I see it there, but the only action I can take is disabling it, which doesn't fix there error.

[leolam]

Please post the content of your .htaccess file and that of your file structure of the public_html folder. You have PHP5 directive throwing havoc and that is causing your problems. Also delete the "CloudPanel (5.0) 1" plugin by going to manage extensions> select plugins and delete the crap...After that go into PhP admin> extensions and see if that plugin is till in here. If so delete it

Leo

[smurfd]

file structure is attached.

I uninstalled the cloudpanel extension, but I don't (think I) have a php admin tool. I did look at the extensions table in the database, and I didn't see anything about cloudpanel.

Here's the .htaccess

Code: Select all

##
# @package    Joomla
# @copyright  (C) 2005 Open Source Matters, Inc. <https://www.joomla.org>
# @license    GNU General Public License version 2 or later; see LICENSE.txt
##

##
# READ THIS COMPLETELY IF YOU CHOOSE TO USE THIS FILE!
#
# The line 'Options +FollowSymLinks' may cause problems with some server configurations.
# It is required for the use of Apache mod_rewrite, but it may have already been set by
# your server administrator in a way that disallows changing it in this .htaccess file.
# If using it causes your site to produce an error, comment it out (add # to the
# beginning of the line), reload your site in your browser and test your sef urls. If
# they work, then it has been set by your server administrator and you do not need to
# set it here.
##

## Can be commented out if causes errors, see notes above.
Options +FollowSymlinks
Options -Indexes

## No directory listings
<IfModule mod_autoindex.c>
	IndexIgnore *
</IfModule>

## Suppress mime type detection in browsers for unknown types
<IfModule mod_headers.c>
	Header always set X-Content-Type-Options "nosniff"
</IfModule>

## Protect against certain cross-origin requests. More information can be found here:
## https://developer.mozilla.org/en-US/docs/Web/HTTP/Cross-Origin_Resource_Policy_(CORP)
## https://web.dev/why-coop-coep/
#<IfModule mod_headers.c>
#	Header always set Cross-Origin-Resource-Policy "same-origin"
#	Header always set Cross-Origin-Embedder-Policy "require-corp"
#</IfModule>

## Disable inline JavaScript when directly opening SVG files or embedding them with the object-tag
<FilesMatch "\.svg$">
  <IfModule mod_headers.c>
    Header always set Content-Security-Policy "script-src 'none'"
  </IfModule>
</FilesMatch>

## These directives are only enabled if the Apache mod_rewrite module is enabled
<IfModule mod_rewrite.c>
	RewriteEngine On

	## Begin - Rewrite rules to block out some common exploits.
	# If you experience problems on your site then comment out the operations listed
	# below by adding a # to the beginning of the line.
	# This attempts to block the most common type of exploit `attempts` on Joomla!
	#
	# Block any script trying to base64_encode data within the URL.
	RewriteCond %{QUERY_STRING} base64_encode[^(]*\([^)]*\) [OR]
	# Block any script that includes a <script> tag in URL.
	RewriteCond %{QUERY_STRING} (<|%3C)([^s]*s)+cript.*(>|%3E) [NC,OR]
	# Block any script trying to set a PHP GLOBALS variable via URL.
	RewriteCond %{QUERY_STRING} GLOBALS(=|\[|\%[0-9A-Z]{0,2}) [OR]
	# Block any script trying to modify a _REQUEST variable via URL.
	RewriteCond %{QUERY_STRING} _REQUEST(=|\[|\%[0-9A-Z]{0,2})
	# Return 403 Forbidden header and show the content of the root home page
	RewriteRule .* index.php [F]
	#
	## End - Rewrite rules to block out some common exploits.

	## Begin - Custom redirects
	#
	# If you need to redirect some pages, or set a canonical non-www to
	# www redirect (or vice versa), place that code here. Ensure those
	# redirects use the correct RewriteRule syntax and the [R=301,L] flags.
	#
	## End - Custom redirects

	##
	# Uncomment the following line if your webserver's URL
	# is not directly related to physical file paths.
	# Update Your Joomla! Directory (just / for root).
	##

	# RewriteBase /

	## Begin - Joomla! core SEF Section.
	#
	# PHP FastCGI fix for HTTP Authorization, required for the API application
	RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
	# -- SEF URLs for the API application
	# If the requested path starts with /api, the file is not /api/index.php
	# and the request has not already been internally rewritten to the
	# api/index.php script
	RewriteCond %{REQUEST_URI} ^/api/
	RewriteCond %{REQUEST_URI} !^/api/index\.php
	# and the requested path and file doesn't directly match a physical file
	RewriteCond %{REQUEST_FILENAME} !-f
	# and the requested path and file doesn't directly match a physical folder
	RewriteCond %{REQUEST_FILENAME} !-d
	# internally rewrite the request to the /api/index.php script
	RewriteRule .* api/index.php [L]
	# -- SEF URLs for the public frontend application
	# If the requested path and file is not /index.php and the request
	# has not already been internally rewritten to the index.php script
	RewriteCond %{REQUEST_URI} !^/index\.php
	# and the requested path and file doesn't directly match a physical file
	RewriteCond %{REQUEST_FILENAME} !-f
	# and the requested path and file doesn't directly match a physical folder
	RewriteCond %{REQUEST_FILENAME} !-d
	# internally rewrite the request to the index.php script
	RewriteRule .* index.php [L]
	#
	## End - Joomla! core SEF Section.
</IfModule>

## These directives are only enabled if the Apache mod_rewrite module is disabled
<IfModule !mod_rewrite.c>
	<IfModule mod_alias.c>
		# When Apache mod_rewrite is not available, we instruct a temporary redirect
		# of the start page to the front controller explicitly so that the website
		# and the generated links can still be used.
		RedirectMatch 302 ^/$ /index.php/
		# RedirectTemp cannot be used instead
	</IfModule>
</IfModule>

## These directives are only enabled if the Apache mod_headers module is enabled.
## This section will check if a .gz file exists and if so will stream it
##     directly or fallback to gzip any asset on the fly
## If your site starts to look strange after enabling this, and you see
##     ERR_CONTENT_DECODING_FAILED in your browser console network tab,
##     then your server is already gzipping css and js files and you don't need this
##     block enabled in your .htaccess
<IfModule mod_headers.c>
	# Serve gzip compressed CSS files if they exist
	# and the client accepts gzip.
	RewriteCond "%{HTTP:Accept-encoding}" "gzip"
	RewriteCond "%{REQUEST_FILENAME}\.gz" -s
	RewriteRule "^(.*)\.css" "$1\.css\.gz" [QSA]

	# Serve gzip compressed JS files if they exist
	# and the client accepts gzip.
	RewriteCond "%{HTTP:Accept-encoding}" "gzip"
	RewriteCond "%{REQUEST_FILENAME}\.gz" -s
	RewriteRule "^(.*)\.js" "$1\.js\.gz" [QSA]

	# Serve correct content types, and prevent mod_deflate double gzip.
	RewriteRule "\.css\.gz$" "-" [T=text/css,E=no-gzip:1]
	RewriteRule "\.js\.gz$" "-" [T=text/javascript,E=no-gzip:1]

	<FilesMatch "(\.js\.gz|\.css\.gz)$">
		# Serve correct encoding type.
		Header append Content-Encoding gzip

		# Force proxies to cache gzipped &
		# non-gzipped css/js files separately.
		Header append Vary Accept-Encoding
	</FilesMatch>
</IfModule>

[smurfd]

The update is still failing...

I followed these steps, https://docs.joomla.org/J4.x:Fix_%22Dat ... _Update/en
and that resolved the database error flag

There were still several modules with warning flags, so I removed as much as I could. In the end there are 3 modules with a warning:
Two Factor Authentication - Google Authenticator
Two Factor Authentication - YubiKey
Maximenu CK

Then there are three warnings with the settings:
Output Buffering
GD Available
intl Available

I attached the most recent error messages

[smurfd]

I should also add that I'm now at J4.4.11

[smurfd]

Finally got the upgrade through ! With a lot of help from other forum posts.

To recap:
--Fix database structure--https://docs.joomla.org/J4.x:Fix_%22Dat ... _Update/en

--For modules with warnings--
recreate content with a J5 compatible module or disable

--For the mysqli ordering error--
https://gist.github.com/Yiannistaos/8e9 ... 8ca7d31e1c

--For the JPlugin error--
update the JCE plugin