MySQLi extension not available Topic is solved

[ipc10101]

Hello,

When i upgrade my PHP version from 7.4 to 8.0 i am getting an 500 error. When i turn on de error log the message MySQLi extention not available shows up.



What can i do?

fout.png

Sincerely,

Martijn

[toivo]

Welcome to the Joomla forum!

Go to the cPanel, the web page provided your host, and locate the Software section and PHP. Enable the MySQLi extension in the list of available PHP extensions for PHP 8.

[ipc10101]

Hoi Toivo,

this is already enabled.

[gws]

Run the FPA please.

[toivo]

this is already enabled.

Please look again at the enabled PHP extensions in the right php.ini file!

A web server can have several php.ini files. Some host configurations select the version of PHP and the associated php.ini file through entries in the .htaccess file. Some hosts use cPanel and its Software section, from where the PHP version is selected, together with PHP extensions for that particular version.

Let's focus on the first screenshot you attached to the topic. Access the website again. Once the error message is displayed, expand the first line by clicking the plus sign in the beginning of the line, immediately under the bold heading UnsupportedAdapterException. Line 161 refers to the file libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php. The following extract starts from line 151 and ends in line 162:

Code: Select all

	public function connect()
	{
		if ($this->connection)
		{
			return;
		}

		// Make sure the MySQLi extension for PHP is installed and enabled.
		if (!static::isSupported())
		{
			throw new UnsupportedAdapterException('The MySQLi extension is not available');
		}

This is where the error message comes from. It makes it clear that the PHP extension mysqli is not enabled in the PHP version that Joomla is using.

[ipc10101]

Hello,

In reply to gws i made an fpa report.

https://gukkies.nl/fpa.pdf

Thanks for the reply's

Martijn

[toivo]

Please follow the FPA instructions and copy and paste the BBCode into your reply so that the FPA results are in the standard, concise format.

[ipc10101]

[16-Apr-2023 10:45:57 UTC] PHP Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/gukkies/public_html/modules/mod_search/mod_search.php on line 44

Joomla! Instance :: Joomla! 4.2.9-Stable (Uaminifu) 14-March-2023
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | 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: standard | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.2.9: Yes | Database Supports J! 4.2.9: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-962.3.2.lve1.5.24.7.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 703.85 GiB |

PHP Configuration :: Version: 8.1.17 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: error_log | Last Known Error: 16th April 2023 10:45:57. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 2M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 128M

Database Configuration :: Version: 10.5.19-MariaDB (Client:3.1.20) | Database Size: 38.53 MiB | #of Tables with config prefix:  80 | #of other Tables:  0 | User Privileges : GRANT SELECTUser Privileges : INSERTUser Privileges : UPDATEUser Privileges : DELETEUser Privileges : CREATEUser Privileges : DROPUser Privileges : REFERENCESUser Privileges : INDEXUser Privileges : ALTERUser Privileges : CREATE TEMPORARY TABLESUser Privileges : LOCK TABLESUser Privileges : EXECUTEUser Privileges : CREATE VIEWUser Privileges : SHOW VIEWUser Privileges : CREATE ROUTINEUser Privileges : ALTER ROUTINEUser Privileges : EVENTUser Privileges : TRIGGER

PHP Extensions :: Core (8.1.17) | date (8.1.17) | libxml (8.1.17) | openssl (8.1.17) | pcre (8.1.17) | sqlite3 (8.1.17) | zlib (8.1.17) | bz2 (8.1.17) | calendar (8.1.17) | ctype (8.1.17) | curl (8.1.17) | hash (8.1.17) | filter (8.1.17) | ftp (8.1.17) | gettext (8.1.17) | json (8.1.17) | iconv (8.1.17) | SPL (8.1.17) | pcntl (8.1.17) | readline (8.1.17) | Reflection (8.1.17) | session (8.1.17) | standard (8.1.17) | mbstring (8.1.17) | shmop (8.1.17) | SimpleXML (8.1.17) | tokenizer (8.1.17) | xml (8.1.17) | litespeed () | bcmath (8.1.17) | dba (8.1.17) | dom (20031129) | enchant (8.1.17) | fileinfo (8.1.17) | gd (8.1.17) | imap (8.1.17) | intl (8.1.17) | ldap (8.1.17) | exif (8.1.17) | mysqli (8.1.17) | mysqlnd (mysqlnd 8.1.17) | odbc (8.1.17) | PDO (8.1.17) | pdo_mysql (8.1.17) | PDO_ODBC (8.1.17) | pdo_pgsql (8.1.17) | pdo_sqlite (8.1.17) | pgsql (8.1.17) | Phar (8.1.17) | posix (8.1.17) | pspell (8.1.17) | snmp (8.1.17) | soap (8.1.17) | sockets (8.1.17) | sysvmsg (8.1.17) | sysvsem (8.1.17) | sysvshm (8.1.17) | tidy (8.1.17) | xmlreader (8.1.17) | xmlrpc (1.0.0RC2) | xmlwriter (8.1.17) | xsl (8.1.17) | zip (1.19.5) | Zend Engine (4.1.17) |
Potential Missing Extensions ::

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: 1596113 | Threads: 41 | Questions: 538026359 | Slow queries: 197 | Opens: 14089284 | Open tables: 8000 | Queries per second avg: 337.085 |

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_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 (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_mails (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_scheduler (4.1.0) 1 |
3rd Party:: Akeeba (8.2.7) 1 | com_osmeta (2.0.5) 1 | com_akeebabackup (9.5.1) 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) 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:: MOD_YOOTHEME_BUILDER (3.0.29) 1 |

Modules :: Admin ::
Core :: mod_custom (3.0.0) 1 | mod_feed (3.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_menu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_privacy_dashboard (3.9.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_version (3.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_privacy_status (4.0.0) 1 | mod_user (4.0.0) 1 | mod_loginsupport (4.0.0) 1 | mod_frontend (4.0.0) 1 | mod_messages (4.0.0) 1 |
3rd Party::

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

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | 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) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 0 | 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_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_extension_finder (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_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_fields_subform (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) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_installer_override (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_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_search_categories (4.0.0-dev) 1 | plg_search_contacts (4.0.0-dev) 1 | plg_search_content (4.0.0-dev) 1 | plg_search_newsfeeds (4.0.0-dev) 1 | plg_search_tags (4.0.0-dev) 1 | 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_languagecode (3.0.0) 0 | 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) 1 | plg_system_redirect (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) 0 | plg_system_httpheaders (4.0.0) 0 | plg_system_webauthn (4.0.0) 1 | plg_system_skipto (4.0.0) 1 | plg_system_accessibility (4.0.0) 0 | plg_system_jooa11y (4.2.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_system_task_notification (4.1) ? | plg_system_shortcut (4.2.0) 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_messages (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_modules (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_api-authentication_token (4.0.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_media-action_rotate (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_task_check_files (4.1) ? | plg_task_demo_tasks (4.1) ? | plg_task_requests (4.1) 1 | plg_task_site_status (4.1) ? | plg_multifactorauth_email (4.2.0) 0 | plg_multifactorauth_fixed (4.2.0) 0 | plg_multifactorauth_totp (3.2.0) 1 | plg_multifactorauth_webauthn (4.2.0) 0 | plg_multifactorauth_yubikey (3.2.0) 0 |
3rd Party:: PLG_ACTIONLOG_AKEEBABACKUP (8.2.7) 0 | Content - OSMeta Content (2.0.2) 1 | plg_editors_codemirror (5.65.6) 1 | plg_editors_tinymce (5.10.7) 1 | Fields - YOOtheme Location (3.0.29) 0 | Installer - YOOtheme (1.0.6) 1 | plg_quickicon_akeebabackup (8.2.7) 1 | System - OSMeta Renderer (2.0.2) 1 | System - YOOtheme Framework (3.0.29) 1 | plg_system_osmylicensesmanager (2.0.15) 1 | PLG_SYSTEM_BACKUPONUPDATE (8.2.7) 0 | PLG_CONSOLE_AKEEBABACKUP (8.2.7) 0 |

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

[toivo]

The website seems to be loading all right now. Is everything now working?

[ipc10101]

Sorry, i set php 7.4 back on. Now i put 8.1 active and as you can see there is a 500 error on the website.

[gws]

Max. Upload Size: 2M | Max. POST Size: 8M | Set Both to 128M, Memory Limit: 128M Set to 256.
Try using the default template and see what happens, disable mod_search.

[AMurray]

FPA says PHP 8.1.17 (not 7.4) and Dbtype: mysqli....so it seems OK...?

Deprecated code is that which is flagged for removal in a future release of PHP.

[toivo]

Error Reporting: standard

The value 'standard' is invalid. These are values available from the dropdown list in Joomla 4:

• System Default

• None

• Simple

• Maximum

When the file configuration.php is edited manually, those values have to be written in lower case:

• default

• none

• simple

• maximum

Site Debug: false

Set the Debug option in the System tab of Global Configuration and set 'Log Almost Everything' to 'Yes' in the Logging tab. Alternatively, write-enable and edit the file configuration.php:

Code: Select all

	public $debug = true;
	public $log_everything = 1;

The above values and selecting 'Maximum' in Error Reporting will display a detailed error message together with the PHP call stack, which will identify the script and the line number of the extension that is not compatible with PHP 8.1.

The option 'Log Almost Everything' will write the error log into the file administrator/logs/everything.php. Copy and paste the error messages into your reply.

mod_search (4.0.0-dev) 1

As @gws advised, disable this module, which is a development version. Uninstall it and use the Smart Search component with the module mod_finder instead.

[ipc10101]

I don't know what happened but everyting seems to work fine now suddenly. Running PHP 8.1 and up to date.

Schermafbeelding 2023-04-17 083102.jpg

Thanks a lot for all the help!

[toivo]

Good to hear, and thank you for the update!

[osamogy]

I had the same error. use the php selector. select extensions , choose your current php version and enable mysqli. works for me