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

Need help upgrading your Joomla! website or converting to Joomla! 4.x?

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
TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Fri Jan 21, 2022 10:02 pm

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

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

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

Post by AMurray » Sat Jan 22, 2022 12:22 am

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?
Regards - A Murray

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sat Jan 22, 2022 12:38 am

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

Forum Post Assistant (v1.6.5) : 22-Jan-2022 wrote:
Basic Environment :: wrote: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
Detailed Environment :: wrote: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
Folder Permissions :: wrote: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 Information :: wrote:Database statistics :: Uptime: 1554595 Threads | Questions: 52457990 | Slow queries: 8621 |
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_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 Discovered :: wrote:Templates :: Site :: ALLROUNDER-3 (1.1) 1 | cassiopeia (1.0) 1 |
Templates :: Admin :: bluestork (2.5.0) 1 | atum (1.0) 1 |
Last edited by toivo on Sat Jan 22, 2022 1:18 am, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 15260
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

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

Post by toivo » Sat Jan 22, 2022 2:47 am

TheWeps wrote:
Sat Jan 22, 2022 12:38 am
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.
Toivo Talikka, Global Moderator

Olympe30
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 106
Joined: Sun Dec 12, 2021 9:28 am

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

Post by Olympe30 » Sat Jan 22, 2022 9:56 am

Hi...

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

Bye

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sat Jan 22, 2022 10:33 am

Where do I have to replace the method?

Rob

Olympe30
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 106
Joined: Sun Dec 12, 2021 9:28 am

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

Post by Olympe30 » Sat Jan 22, 2022 11:34 am

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

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sat Jan 22, 2022 12:05 pm

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

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 15260
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

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

Post by toivo » Sat Jan 22, 2022 12:10 pm

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

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sat Jan 22, 2022 12:14 pm

I can't open the Global Configuration...

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 15260
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

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

Post by toivo » Sat Jan 22, 2022 12:20 pm

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.
Toivo Talikka, Global Moderator

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sat Jan 22, 2022 12:33 pm

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?

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 15260
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

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

Post by toivo » Sat Jan 22, 2022 1:05 pm

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.
Last edited by toivo on Sat Jan 22, 2022 9:20 pm, edited 1 time in total.
Reason: typo
Toivo Talikka, Global Moderator

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sat Jan 22, 2022 4:02 pm

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

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

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

Post by AMurray » Sat Jan 22, 2022 9:53 pm

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.
Regards - A Murray

frostmakk
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 234
Joined: Sun Dec 28, 2014 9:30 am
Location: Stavanger, Norway

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

Post by frostmakk » Sat Jan 22, 2022 10:13 pm

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
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 234
Joined: Sun Dec 28, 2014 9:30 am
Location: Stavanger, Norway

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

Post by frostmakk » Sat Jan 22, 2022 11:22 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sun Jan 23, 2022 12:48 pm

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
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 234
Joined: Sun Dec 28, 2014 9:30 am
Location: Stavanger, Norway

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

Post by frostmakk » Sun Jan 23, 2022 1:48 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sun Jan 23, 2022 2:50 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sun Jan 23, 2022 6:14 pm

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
Last edited by TheWeps on Sun Jan 23, 2022 6:24 pm, edited 1 time in total.

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

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

Post by Per Yngve Berg » Sun Jan 23, 2022 6:21 pm

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

Set Cassiopeia as default template.

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sun Jan 23, 2022 10:42 pm

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

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 15260
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

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

Post by toivo » Sun Jan 23, 2022 11:48 pm

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.
Toivo Talikka, Global Moderator

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Sun Jan 23, 2022 11:54 pm

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

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 15260
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

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

Post by toivo » Mon Jan 24, 2022 12:10 am

TheWeps wrote:
Sun Jan 23, 2022 11:54 pm
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.
Toivo Talikka, Global Moderator

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Mon Jan 24, 2022 12:22 am

What is the main joomla folder? Everything in httpdocs?

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 15260
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

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

Post by toivo » Mon Jan 24, 2022 12:31 am

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.
Toivo Talikka, Global Moderator

TheWeps
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Fri Jan 21, 2022 9:49 pm

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

Post by TheWeps » Mon Jan 24, 2022 12:44 am

Thanks!!!

Control panel is working again.

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

trongthang
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Tue Sep 06, 2022 2:44 am

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

Post by trongthang » Tue Sep 20, 2022 8:16 am

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


Post Reply

Return to “Migrating and Upgrading to Joomla! 4.x”