[User Notice] mysqlnd PHP library is not available, numeric values will be fetched from the DB as strings

Questions
1

Silverstripe Version: 4.6.1

**What could be the reason for this: [User Notice] mysqlnd PHP library is not available, numeric values will be fetched from the DB as strings - Line 89 in vendor/silverstripe/framework/src/ORM/Connect/MySQLiConnector.php **?

_mysqlnd is enabled

Has anybody come across this or knows what could cause this error?

[Emergency] Uncaught LogicException: Cookie can't be set. The site started outputting content at line 419 in public_html/vendor/silverstripe/framework/src/Control/HTTPResponse.php
2

Sorry, for the late reply. This all happened while I was on holidays.
It turned out that the web hosting company did some changes in the configuration.
fileinfo and mysqlnd, pdo_mysql and mysqli were not present and inconsistent in version.

https://forum.silverstripe.org/t/emergency-uncaught-logicexception-cookie-cant-be-set-the-site-started-outputting-content-at-line-419-in-public-html-vendor-silverstripe-framework-src-control-httpresponse-php/3762?u=kimk

3

I have already enabled fileinfo and mysqlnd, pdo_mysql and mysqli.

But still getting below issue:

[User Notice] mysqlnd PHP library is not available, numeric values will be fetched from the DB as strings

GET /mintdesign/4econsulting/dev/build/?flush=all

Line 89 in /home/tenderne/public_html/mintdesign/4econsulting/vendor/silverstripe/framework/src/ORM/Connect/MySQLiConnector.php

Please advice.

Thanks.

4

I guess then there is a version inconsistency.
I was lucky enough to have a working version on one server and could compare the versions and point the web hosting company to the expected versions this way.
Which PHP version are you on?

5

Php version 7.4

composer details:
{
“name”: “silverstripe/installer”,
“type”: “silverstripe-recipe”,
“description”: “The SilverStripe Framework Installer”,
“require”: {
“php”: “^7.3 || ^8.0”,
“silverstripe/recipe-plugin”: “^1.2”,
“silverstripe/recipe-cms”: “~4.10.0@stable”,
“silverstripe-themes/simple”: “~3.2.0”,
“silverstripe/login-forms”: “~4.6.0@stable”,
“dnadesign/silverstripe-elemental”: “^4.8”,
“silverstripe/blog”: “^3.9”,
“silverstripe/elemental-fileblock”: “2.0”,
“silverstripe/elemental-bannerblock”: “2.0”,
“dnadesign/silverstripe-elemental-userforms”: “3.x-dev”,
“dnadesign/silverstripe-elemental-list”: “^1.2”,
“dnadesign/silverstripe-elemental-virtual”: “1.x-dev”,
“dynamic/silverstripe-elemental-blocks”: “^3.0”,
“silvershop/core”: “^3.0”,
“gorriecoe/silverstripe-linkfield”: “^1.0”
},
“require-dev”: {
“phpunit/phpunit”: “^9.5”
},
“extra”: {
“resources-dir”: “_resources”,
“project-files-installed”: [
“app/.htaccess”,
“app/_config.php”,
“app/_config/mimevalidator.yml”,
“app/_config/mysite.yml”,
“app/src/Page.php”,
“app/src/PageController.php”
],
“public-files-installed”: [
“.htaccess”,
“index.php”,
“web.config”
]
},
“config”: {
“process-timeout”: 600
},
“prefer-stable”: true,
“minimum-stability”: “dev”
}

6

Sorry, no I meant on your server.
If you do

<?php phpinfo();

on the server what info do you get about your mysqlnd version and which PHP version is this on.

7

Hello, does anyone have a resolution for this? I got this exact error upon upgrading PHP 7.1 → 7.4 (on GoDaddy hosting), using SS v4.4 (the first step in a website overhaul project). mysqlnd is enabled.

8

The resolution is in the thread here. If the PHP code is reporting that the extension is not available, then it’s not enabled (or at least not enabled in the right places). You’ll need to contact your hosting provider to resolve this.