Cannot select any valid SQL engine. at line 303 in file classes/db/Db.php Error prestashop 8

[radovicn]

Hi, I've changed hosting provider and I uploaded my backups both for shop and db. I connected db and I was getting at first error 500 and 503 in BO and now I'm getting this:

 

Cannot select any valid SQL engine.
at line 303 in file classes/db/Db.php

298. } elseif (extension_loaded('mysqli')) { 299. $class = 'DbMySQLi'; 300. } 301. 302. if (empty($class)) { 303. throw new PrestaShopException('Cannot select any valid SQL engine.'); 304. } 305. 306. return $class; 307. } 308.

DbCore::getClass - [line 236 - classes/db/Db.php]

DbCore::getInstance - [line 47 - config/alias.php]

pSQL - [line 1359 - classes/shop/Shop.php] - [1 Arguments]

ShopCore::findShopByHost - [line 355 - classes/shop/Shop.php] - [1 Arguments]

ShopCore::initialize - [line 117 - config/config.inc.php]

require - [line 40 - admin/index.php] - [1 Arguments]

 

I've added phpinfo file to root of my website and I've checked and changed PHP version to 8.1. Also I've checked database via service provider tool and no errors were found. Any idea how to resolve this? I would really like to restore my shop. 

[Nickz]

Check for differences in DB MySQL vs MariaDB vs MySQL.

Versions and dependencies.

[radovicn]

Sorry, I'm quite beginner, how to check them? 

[Nickz]

You go to you control panel and look there. What kind of control panel do you use?

[radovicn]

cpanel

 

[Nickz]

Look at the multiselector php and apps. Upper corner is a search box. Search for mysql

Edited April 12 by Nickz
spelling (see edit history)

[radovicn]

I checked DB, checked all fields for a changed domain, and cleared the cache but the error still exist. Is there any option to change URL of domain in prestashop files or it is enough just to change in DB? I cannot access BO of presta so I cannot do it via cms

[Knowband Plugins]

7 hours ago, radovicn said:

Is there any option to change URL of domain in prestashop files or it is enough just to change in DB

Also delete var/cache folder via cpanel OR FTP.

 

[radovicn]

Tried and no luck. I checked database integrity, no errors. 

[Knowband Plugins]

WHats the PHP & Prestashop version ?

 

[radovicn]

Current php 8.1 But I've tried 7.4 and 7.3 as well. Prestashop 8.1.2

[Andrei H]

Hello,

The error might be related to not having the PDO / PDO MySQL PHP extensions enabled.

If you do not know how to enable them, you should contact your hosting provider.

Also, make sure the other required PHP extensions are enabled as well.

[radovicn]

Hi, all extensions enabled, look at a screenshot. Pdo included.

 

[radovicn]

My issue is resolved. I've contacted the hosting provider, they restarted mysqli service and my shop is now available again. So it was server side, thanks everyone for help