Use of undefined constant MYSQLI_TYPE_JSON #16043

jsfrerot · 2020-03-25T17:40:03Z

Describe the bug

I get the following error when browsing data in tables:
Warning in ./libraries/classes/Dbi/DbiMysqli.php#463
Use of undefined constant MYSQLI_TYPE_JSON - assumed 'MYSQLI_TYPE_JSON' (this will throw an Error in a future version of PHP)

To Reproduce

Steps to reproduce the behavior:
Install phpmyadmin 5.0.2

Connect to a db server
click on a table to browse it's content
a popup will appear "Some errors have been detected on the server!
Please look at the bottom of this window."
See error

Warning in ./libraries/classes/Dbi/DbiMysqli.php#463
 Use of undefined constant MYSQLI_TYPE_JSON - assumed 'MYSQLI_TYPE_JSON' (this will throw an Error in a future version of PHP)

Backtrace

./libraries/classes/DatabaseInterface.php#2911: PhpMyAdmin\Dbi\DbiMysqli->getFieldsMeta()
./libraries/classes/Sql.php#1845: PhpMyAdmin\DatabaseInterface->getFieldsMeta()
./libraries/classes/Sql.php#2271: PhpMyAdmin\Sql->getQueryResponseForResultsReturned(
,
array,
string 'luna_test_config',
string 'config_db',
NULL,
NULL,
,
string './themes/pmahomme/img/',
string '402',
integer 25,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'SELECT * FROM `config_db`',
NULL,
)
./libraries/classes/Sql.php#2117: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean true,
string 'luna_test_config',
string 'config_db',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `config_db`',
NULL,
NULL,
)
./sql.php#241: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
array,
boolean true,
string 'luna_test_config',
string 'config_db',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `config_db`',
NULL,
NULL,
)

Expected behavior

No errors ;)

Screenshots

Server configuration

Operating system: Centos 7
Web server: nginx 1.16.1
Database version: mysql 5.5
PHP version: 7.2.27
phpMyAdmin version: 5.0.2

Client configuration

Browser: chrome
Operating system: ubuntu 19.10

The text was updated successfully, but these errors were encountered:

williamdes · 2020-03-25T17:55:05Z

I was looking for a way to reproduce this issue that I see very often on the reporting server.
I hope to reproduce it this time, this error does not make sense in php 7

jsfrerot · 2020-03-30T12:51:37Z

Let me know if you need more informations.

williamdes · 2020-04-05T21:51:01Z

@jsfrerot could you send the output of php -m ?

jsfrerot · 2020-04-07T12:17:22Z

He, here is the output of "php -m" as requested

[PHP Modules]
bz2
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
ftp
gd
geoip
gettext
gmp
hash
iconv
json
libxml
mbstring
mysqli
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
zip
zlib

[Zend Modules]

redrain-wang · 2020-04-07T12:18:56Z

if (!defined('MYSQLI_TYPE_JSON')) {
define('MYSQLI_TYPE_JSON', 245);
}

williamdes · 2020-04-09T21:03:54Z

If someone want to investigate before I have time to do so I would really appreciate

This constant exists on my version of php

williamdes · 2020-04-20T05:57:24Z

I think I will revert the commit that removed this safe guard
I does not make sense but I do not understand what is wrong

Could someone post his phpinfo?

williamdes · 2020-04-20T10:29:32Z

On yours

MysqlI Support	enabled
Client API library version	10.2.26
Active Persistent Links	0
Inactive Persistent Links	0
Active Links	0
Client API header version	10.2.31-MariaDB
MYSQLI_SOCKET	/var/lib/mysql/mysql.sock

mysqlnd	enabled
Version	mysqlnd 7.4.4
Loaded plugins	mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions	no value

On my setup

MysqlI Support	enabled
Client API library version	mysqlnd 7.4.2
Active Persistent Links	0
Inactive Persistent Links	0
Active Links	0

mysqlnd	enabled
Version	mysqlnd 7.4.2
Loaded plugins	mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions	mysqli,pdo_mysql

Maybe this is causing this issue

And you setup has --without-mysqli flag when it was compiled

rd18aac · 2020-04-20T10:41:44Z

I don't have much experience with PHP modules so if anyone knows why this worked, please let me know...

I simply unchecked mysqli (red) and enabled nd_mysqli (green).

I did this once on another web host to get an MVC application working and I only just thought of trying it.

rd18aac · 2020-04-20T10:43:11Z

Is this looking correct?

williamdes · 2020-04-20T10:46:29Z

Is this looking correct?

🤷‍♂️
Is the issue fixed by changing extensions ?

rd18aac · 2020-04-20T10:54:17Z

Yeah, beats me.

WordPress, Adminer and my other custom PHP sites had no issue with the change.

This article goes through the the process and apparently changing allows certain functions...

https://www.plus2net.com/php_tutorial/mysqli_mysqlnd.php

williamdes · 2020-04-20T11:42:23Z

Thank you !
This will help me document why I am adding back the constant, this issue will be fixed in the next 5.0 version

williamdes · 2020-04-25T10:13:31Z

Ref: #11438 (comment)
#11438

williamdes · 2020-04-25T10:14:42Z

Removed by c6313ac

Signed-off-by: William Desportes <williamdes@wdes.fr>

williamdes · 2020-04-25T11:27:00Z

Could you apply dc38860 and let me know if it fixes the issue ?

jsfrerot · 2020-04-27T12:18:46Z

@williamdes I confirm it fixes the issue.
Thank you !

pkbarbiedoll · 2020-04-28T21:03:22Z

dc38860 also worked for me.

BenceSzalai · 2020-05-02T13:43:07Z

FYI: Had the same issue. dc38860 also worked for me.

prepstarr · 2020-05-31T15:01:36Z

I am having a similar issue...

hashtag32 · 2020-06-07T11:13:14Z

Thanks @williamdes!

murelh · 2020-09-06T18:43:57Z

if (!defined('MYSQLI_TYPE_JSON')) {
define('MYSQLI_TYPE_JSON', 245);
}

Hi @redrain-wang
Why 245 ?

williamdes · 2020-09-06T21:08:55Z

if (!defined('MYSQLI_TYPE_JSON')) {
define('MYSQLI_TYPE_JSON', 245);
}

Hi @redrain-wang
Why 245 ?

It is the real value when the constant is defined by/in php itself

MauricioFauth · 2021-02-22T15:56:42Z

Looks like MYSQLI_TYPE_JSON is only defined if the server supports the JSON field type and PHP is using mysqlnd (MySQL 5.7.8+ and MariaDB 10.2.7+, but I didn't test this).

williamdes added the Bug A problem or regression with an existing feature label Mar 25, 2020

williamdes added this to Needs triage in issues via automation Mar 25, 2020

williamdes added this to the 5.0.3 milestone Mar 25, 2020

williamdes self-assigned this Mar 30, 2020

williamdes added a commit that referenced this issue Apr 25, 2020

Add a ChangeLog entry for #16043

2725b6a

Signed-off-by: William Desportes <williamdes@wdes.fr>

williamdes closed this as completed in dc38860 Apr 25, 2020

issues automation moved this from Needs triage to Closed Apr 25, 2020

williamdes mentioned this issue May 31, 2020

importing with CSV generates terrible errors and corrupts entire database #16151

Closed

williamdes mentioned this issue Feb 22, 2021

Refactor field flags to use an object an not strpos #16651

Merged

thompol mentioned this issue Feb 22, 2022

Use of undefined constant - several errors #17416

Closed

github-actions bot locked as resolved and limited conversation to collaborators Feb 23, 2022

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Use of undefined constant MYSQLI_TYPE_JSON #16043

Use of undefined constant MYSQLI_TYPE_JSON #16043

jsfrerot commented Mar 25, 2020 •

edited by williamdes

williamdes commented Mar 25, 2020

jsfrerot commented Mar 30, 2020

williamdes commented Apr 5, 2020 •

edited

jsfrerot commented Apr 7, 2020

redrain-wang commented Apr 7, 2020 •

edited by williamdes

williamdes commented Apr 9, 2020

williamdes commented Apr 20, 2020

williamdes commented Apr 20, 2020 •

edited

rd18aac commented Apr 20, 2020

rd18aac commented Apr 20, 2020

williamdes commented Apr 20, 2020

rd18aac commented Apr 20, 2020

williamdes commented Apr 20, 2020

williamdes commented Apr 25, 2020 •

edited

williamdes commented Apr 25, 2020 •

edited

williamdes commented Apr 25, 2020

jsfrerot commented Apr 27, 2020

pkbarbiedoll commented Apr 28, 2020

BenceSzalai commented May 2, 2020

prepstarr commented May 31, 2020

hashtag32 commented Jun 7, 2020

murelh commented Sep 6, 2020 •

edited

williamdes commented Sep 6, 2020

MauricioFauth commented Feb 22, 2021

Use of undefined constant MYSQLI_TYPE_JSON #16043

Use of undefined constant MYSQLI_TYPE_JSON #16043

Comments

jsfrerot commented Mar 25, 2020 • edited by williamdes

Describe the bug

To Reproduce

Expected behavior

Screenshots

Server configuration

Client configuration

williamdes commented Mar 25, 2020

jsfrerot commented Mar 30, 2020

williamdes commented Apr 5, 2020 • edited

jsfrerot commented Apr 7, 2020

redrain-wang commented Apr 7, 2020 • edited by williamdes

williamdes commented Apr 9, 2020

williamdes commented Apr 20, 2020

williamdes commented Apr 20, 2020 • edited

On yours

On my setup

rd18aac commented Apr 20, 2020

rd18aac commented Apr 20, 2020

williamdes commented Apr 20, 2020

rd18aac commented Apr 20, 2020

williamdes commented Apr 20, 2020

williamdes commented Apr 25, 2020 • edited

williamdes commented Apr 25, 2020 • edited

williamdes commented Apr 25, 2020

jsfrerot commented Apr 27, 2020

pkbarbiedoll commented Apr 28, 2020

BenceSzalai commented May 2, 2020

prepstarr commented May 31, 2020

hashtag32 commented Jun 7, 2020

murelh commented Sep 6, 2020 • edited

williamdes commented Sep 6, 2020

MauricioFauth commented Feb 22, 2021

jsfrerot commented Mar 25, 2020 •

edited by williamdes

williamdes commented Apr 5, 2020 •

edited

redrain-wang commented Apr 7, 2020 •

edited by williamdes

williamdes commented Apr 20, 2020 •

edited

williamdes commented Apr 25, 2020 •

edited

williamdes commented Apr 25, 2020 •

edited

murelh commented Sep 6, 2020 •

edited