Call to undefined method Joomla\Database\Mysqli\MysqliDriver::query()

[TheWeps]

Hi,

I just updated my site from 3.10.5 to 4.0.6

The site itself and inside the administrator panels I'm getting the above error message.

I can open the Control panel and System, but as soon as I for example click on Database I get above error message

Does anyone have a solution?

Rob

[AMurray]

first enable Debug and error reporting to "maximum".

Also post the FPA report. (https://forumpostassistant.github.io/docs/)

What PHP version are you using. Did you have any other issues with the 3.10.5 > 4.0.6 migration?

[TheWeps]

Before I updated to 4.0.6, I updated php to version 8 and I also set the error reporting to maximum.

Joomla! Instance :: Joomla! 4.0.6-Stable (Furaha) 15-January-2022
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: No | 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: 0 | Error Reporting: maximum | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.0.6: Yes | Database Supports J! 4.0.6: No | Database Credentials Present: Yes |

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

PHP Configuration :: Version: 8.0.14 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 1 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 50M | Max. POST Size: 50M | Max. Input Time: 300 | Max. Execution Time: 600 | Memory Limit: 1024M

Database Configuration :: Version: 10.3.30 (Client:mysqlnd 8.0.14) | Database Size: 15.47 MiB | #of Tables with config prefix: 78 | #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.0.14) | date (8.0.14) | libxml (8.0.14) | openssl (8.0.14) | pcre (8.0.14) | zlib (8.0.14) | bz2 (8.0.14) | calendar (8.0.14) | ctype (8.0.14) | curl (8.0.14) | hash (8.0.14) | filter (8.0.14) | ftp (8.0.14) | gettext (8.0.14) | gmp (8.0.14) | SPL (8.0.14) | iconv (8.0.14) | json (8.0.14) | pcntl (8.0.14) | readline (8.0.14) | Reflection (8.0.14) | session (8.0.14) | standard (8.0.14) | shmop (8.0.14) | SimpleXML (8.0.14) | mbstring (8.0.14) | tokenizer (8.0.14) | xml (8.0.14) | cgi-fcgi (8.0.14) | bcmath (8.0.14) | dba (8.0.14) | dom (20031129) | fileinfo (8.0.14) | gd (8.0.14) | imagick (3.5.1) | imap (8.0.14) | intl (8.0.14) | exif (8.0.14) | mysqlnd (mysqlnd 8.0.14) | PDO (8.0.14) | pdo_sqlite (8.0.14) | Phar (8.0.14) | posix (8.0.14) | soap (8.0.14) | sysvmsg (8.0.14) | sysvsem (8.0.14) | sysvshm (8.0.14) | xsl (8.0.14) | xmlreader (8.0.14) | xmlwriter (8.0.14) | zip (1.19.5) | mysqli (8.0.14) | pdo_mysql (8.0.14) | Zend Engine (4.0.14) |
Potential Missing Extensions ::
Disabled Functions :: passthru | proc_close | proc_get_status | proc_nice | proc_open | proc_terminate | shell_exec | system | apache_note | apache_setenv | closelog | debugger_off | debugger_on | define_syslog_variables | openlog | syslog | popen | pclose | exec | ini_restore | symlink | pcntl |

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

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) |

Elevated Permissions (First 10) ::

Database statistics :: Uptime: 1554595 Threads | Questions: 52457990 | Slow queries: 8621 |

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 (3.0.0) 1 | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_users (4.0.0) 1 | com_weblinks (3.9.0) 1 | com_workflow (4.0.0) 1 | com_mails (4.0.0) 1 | com_wrapper (4.0.0) 1 |
3rd Party:: Akeeba (8.0.15) 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_weblinks (3.9.0) 1 | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party:: Twitter Show (1.0.0) 1 | JV Twitter (4.0) 1 | LV ENHANCED Image Slider (2.6) 1 | POWr Social Feed (3.0) 1 | mod_twitterlist (1.0) 1 | Visitors Counter (2.0.4) 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_fof40 (4.1.1) ? |

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) 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) 0 | plg_content_geshi (2.5.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_editors-xtd_weblink (3.9.0) 0 | 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_finder_weblinks (3.9.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_override (4.0.0) 1 | plg_installer_webinstaller (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 (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_search_weblinks (3.9.0) 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) 0 | plg_system_redirect (3.0.0) 1 | 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) 1 | plg_system_weblinks (3.9.0) 0 | plg_system_httpheaders (4.0.0) 1 | plg_system_webauthn (4.0.0) 1 | plg_system_skipto (4.0.0) 1 | plg_system_accessibility (4.0.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) 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_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 |
3rd Party:: PLG_ACTIONLOG_AKEEBABACKUP (8.0.15) 1 | AllVideos (by JoomlaWorks) (6.1.0) 1 | AllVideos (by JoomlaWorks) (6.1.0) 1 | POWr Shortcodes (3.0) 1 | POWr Icon (1.0) 1 | plg_editors_codemirror (5.65.0) 1 | plg_editors_tinymce (5.10.2) 1 | plg_quickicon_akeebabackup (8.0.15) 1 | PLG_SYSTEM_BACKUPONUPDATE (8.0.15) 0 |

Templates :: Site :: ALLROUNDER-3 (1.1) 1 | cassiopeia (1.0) 1 |
Templates :: Admin :: bluestork (2.5.0) 1 | atum (1.0) 1 |

[toivo]

Database Supports J! 4.0.6: No

The FPA results show that the Global Configuration has mysqli selected and both mysqli and pdomysql extensions are included in PHP 8.0.14, but something is still wrong. It is best to talk to your host.

[Olympe30]

Hi...

MysqliDriver::query() method is obsolete with Joomal4.
You have to replace by MysqliDriver::execute()

Bye

[TheWeps]

Where do I have to replace the method?

Rob

[Olympe30]

In the composant, plugin, template or module who generate the error...
Use default template or desactive not Joomla module for example.

[TheWeps]

But I get the error message everywhere inside Joomla. On everything in "System", "Control Panel", "Users", "Components", etc.

When I change on the host the php version to 7.0, I get a 'normal' message saying that this version of php is not supported. And that I need at least version 7.2.5

Changing it to 7.3 or higher I get the method error.
I read somewhere that php has dropped support for mysql from 7.0 and above

[toivo]

The driver 'mysqli' should be selected in the Global Configuration. If that does not work, contact the support team of your host.

[TheWeps]

I can't open the Global Configuration...

[toivo]

In that case you should edit the file configuration.php in the main Joomla folder.

If it already contains 'mysqli', you should talk to your host.

[TheWeps]

configuration.php says: public $dbtype = 'mysqli';

But what about that php discontinued support for mysql?

I also talked to my host, but the guy didn't know anything about php or Joomla. What do I have to ask?

[toivo]

PHP 7.0 to 8.1 support MySQL, as long as 'mysqli' is selected and not 'mysql'. The letter i stands for 'improved'.

If 'mysqli' does not work, check the database credentials from the cPanel of your host and if that does not help, talk to them.

[TheWeps]

I talked to them and they said that on there side everything was working.

What I did was:
update Joomla to 3.10.5
php to 8.0
installed a certificate

Up till then everything worked fine.

Then I updated to 4.0.6 and nothing worked anymore

[AMurray]

You have stuff left over from J 2.5 (blue stork admin template), and the 3P extensions seem to also be from that era or at least early Joomla 3. Definitely uninstall blue stork.

Those listed below I have doubts that they will or should run in Joomla 4.x, and surprised the 3.10 update checker didn't red-flag these as 'suspect' extensions that wouldn't run in the J4.x system.

3rd Party:: Twitter Show (1.0.0) 1 | JV Twitter (4.0) 1 | LV ENHANCED Image Slider (2.6) 1 | POWr Social Feed (3.0) 1 | mod_twitterlist (1.0) 1 | Visitors Counter (2.0.4) 1 |

Examples

• Powr Social Feed (JED Listing) doesn't indicate that it works on J4 (even though last update November 2021 on the JED listing).
• JV Twitter has been removed from the JED, cited as a Vulnerable Extension, but I can't find it on the VEL. Check here: https://extensions.joomla.org/extension ... v-twitter/.
• Mod_Twitterlist (I don't know if it's this one https://extensions.joomla.org/extension ... list-feed/) but that hasn't been updated in 3 years.
• LV ENHANCED Image Slider - can't find this on the JED probably because it is for Joomla 2.5 and early 3.0 but not 4.x.
• Visitors Counter 2.0.4 - (perhaps this one https://extensions.joomla.org/extension ... s-counter/ ) but in any case it is for very old Joomla versions - 1.5, 2,5,3.x but not 4.x
• Also, for some reason you have an admin template (Bluestork) from Joomla 2.5 - uninstall that template.
• Last one - "Allrounder 3" template (http://www.marocjoomla.com/joomla-templ ... joomla-3-5 ) says it works on Joomla 3.10 but not 4.x - not to say it won't but I wouldn't guarantee it. **the template developer does appear to have available templates for J4, just not this one specifically**

Any or all of these could be contributing factors to your problem. This is also looking more and more like a site that was originally running Joomla 2.5 (due to the above old extensions) that was updated to 3.x and eventually to 4.x.

[frostmakk]

Don't get confused by the false positive
Database Supports J! 4.0.6: No
It's probably a MariaDB that is confusing the FPA by not reporting that it is a MariaDB.

[frostmakk]

As far as I can see the query() method has not been available since J1.5, so probably a very old extension to blame for this error.

[TheWeps]

It's correct. This site was originally build in 2.5

And yes, the database is MariaDB.

How can I unstall bluestork, or change it to the default template? I can't change it from the system dashboard. So I have to change it in some of the configuration files. But which one?

And when the Control Panel runs again, I can search for the extension which cause the site to crash.

[frostmakk]

Before doing anything else, make sure you have a backup of the database and your file structure.
Open the database in phpMyAdmin or similar database tool from your hosts control panel. Find the bluestork template in the xxxxx_extensions table, and delete that record. Then delete the \administrator\template\bluestork folder.
Find the other suspected extensions in the same database table and change the field "enabled" to 0 and check what happens.

Edit.
Also delete the bluestork record in the xxxxx_template_styles table.

[TheWeps]

ok, thanks.

Back in business now. The site doens't look as it used to be, but I can manage it again. The control panel is working again.

[TheWeps]

I have a additional question. I ask it in this thread because maybe it's because of the above problems.

I see only the 'main page' now on the site. No header, no menu. Any ideas?

Found it. All the 'positions' are different

[Per Yngve Berg]

Your template ALLROUNDER-3 (1.1) is made for Joomla 3.x and does not work in J4.

Set Cassiopeia as default template.

[TheWeps]

I'm going back to J3. Nothing is working anymore. Template is not usable. And all the plugins are not compatible. And during the update Joomla gave only a warning...

I'm back in J3.

But now I get a lot of other error messages in the control panel like:
Class "JFormFieldList" not found
Call to a member function order() on null
Class "JFormFieldPredefinedList" not found

Nothing is accessible anymore

[toivo]

How did you go back to Joomla 3.x? The correct method is to restore the site from a full Joomla 3.x backup, including the file system and the database, to a blank Joomla folder and a new database schema.

[TheWeps]

I used Akeeba backup and restored it back to the original site

[toivo]

I used Akeeba backup and restored it back to the original site

On the top of the Joomla 4 installation? Clear the main Joomla folder and restore again, otherwise the website remains inconsistent.

[TheWeps]

What is the main joomla folder? Everything in httpdocs?

[toivo]

The folder may be called httpdocs or something else, but the main joomla folder contains the files configuration.php and index.php and all the sub folders, starting from 'administrator' and ending in 'templates' and 'tmp'. All the files and the sub folders need to be deleted before copying the backup file and the Kickstart utility there.

[TheWeps]

Thanks!!!

Control panel is working again.

I only have some strange text in the articles:
DH 2021         € 16.884,=

[trongthang]

You should replace $db->query(); by $db->execute();