Undefined constant "MYSQLI_OPT_LOCAL_INFILE"

Support & Bugs
1

Greetings! Installed Matomo on a DigitalOcean VPS and use DigitalOcean Managed DB service that doesn’t allow local_infile variable for their MySQL databases. When trying to run core:archive operation i get this error message. Is it possible to successfuly do archive operation without local_infile variable enabled on database?

ERROR [2023-02-16 13:02:55] 555234  Uncaught exception: Error: Undefined constant "Piwik\Db\Adapter\MYSQLI_OPT_LOCAL_INFILE" in /var/www/matomo/core/Db/Adapter/Mysqli.php:35
Stack trace:
#0 /var/www/matomo/core/Db/Adapter.php(49): Piwik\Db\Adapter\Mysqli->__construct()
#1 /var/www/matomo/core/Db.php(157): Piwik\Db\Adapter::factory()
#2 /var/www/matomo/core/Db.php(56): Piwik\Db::createDatabaseObject()
#3 /var/www/matomo/core/Db.php(302): Piwik\Db::get()
#4 /var/www/matomo/core/Option.php(288): Piwik\Db::fetchAll()
#5 /var/www/matomo/core/Option.php(178): Piwik\Option->autoload()
#6 /var/www/matomo/core/Option.php(48): Piwik\Option->getValue()
#7 /var/www/matomo/plugins/UserCountry/LocationProvider.php(341): Piwik\Option::get()
#8 /var/www/matomo/plugins/UserCountry/LocationProvider.php(357): Piwik\Plugins\UserCountry\LocationProvider::getCurrentProviderId()
#9 /var/www/matomo/plugins/GeoIp2/Commands/ConvertRegionCodesToIso.php(34): Piwik\Plugins\UserCountry\LocationProvider::getCurrentProvider()
#10 /var/www/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(388): Piwik\Plugins\GeoIp2\Commands\ConvertRegionCodesToIso->isEnabled()
#11 /var/www/matomo/core/Console.php(175): Symfony\Component\Console\Application->add()
#12 /var/www/matomo/core/Console.php(133): Piwik\Console->addCommandIfExists()
#13 /var/www/matomo/core/Console.php(87): Piwik\Console->doRunImpl()
#14 /var/www/matomo/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun()
#15 /var/www/matomo/console(32): Symfony\Component\Console\Application->run()
#16 {main}
Uncaught exception in /var/www/matomo/core/Db/Adapter/Mysqli.php line 35:
Undefined constant "Piwik\Db\Adapter\MYSQLI_OPT_LOCAL_INFILE"
2

Seen on:

Maybe ask your server admin if there had been any changes to your server. The error message indicates, that the MYSQLi extension for PHP might not be loaded correctly. The missing constant MYSQLI_OPT_LOCAL_INFILE should be defined by this extension.