One specific table can not be browsed anymore: preg_match() expects parameter 2 to be string, null given #15877

felsd · 2020-01-29T17:34:36Z

Since today I can't view the data of only one specific table anymore. I have been using phpMyAdmin on this server since several months with multiple databases and until today everything was working fine.

phpMyAdmin 4.9.4 in combination with PHP 7.0 displayed only the first column of the table and a long error message at the end of the page. Unfortunately I don't have the full message anymore, the only part that I remember is Undefined offset: 2 in the file Display/Results.php.

The 2nd column of that table is a varchar(64) with collation utf8mb4_general_ci.

After upgrading to phpMyAdmin 5.0.1 and PHP 7.3 I get an error dialog with the following message:

Error in processing request
Error code: 500
Error text: Internal Server Error (rejected)
It seems that the connection to server has been lost. Please check your network connectivity and server status.

nginx error.log:

2020/01/29 18:04:50 [error] 3521#3521: *1100 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught TypeError: preg_match() expects parameter 2 to be string, null given in /usr/share/phpmyadmin/libraries/classes/Display/Results.php:1804
Stack trace:
#0 libraries/classes/Display/Results.php(1804): preg_match('@time|date@i', NULL)
#1 libraries/classes/Display/Results.php(1695): PhpMyAdmin\Display\Results->_getSingleAndMultiSortUrls(Array, Array, '', NULL, Array, NULL)
#2 libraries/classes/Display/Results.php(1103): PhpMyAdmin\Display\Results->_getOrderLinkAndSortedHeaderHtml(NULL, Array, Array, NULL, 'SELECT * FROM `...', 25, '', Array, Array, NULL)
#3 libraries/classes/Display/Results.php(1220): PhpMyAdmin\Display\Results->_getTableHeadersForColumns(Array, Array, Array, Array, Array, false, 'SELECT * FROM `...')
#4 libraries/classes/Display/Results.php(4292): PhpMyAdmin\Display\Results->_getTableHeaders(Array, Array, 'SELECT * FROM `...', Array, Arr" while reading response header from upstream,
client: y.y.y.y, server: _, request: "GET /phpmyadmin/sql.php?server=1&db=database_name&table=accounts&pos=0&ajax_request=true&ajax_page_request=true&_nocache=1580317489743773774&token=xxxxxxxxxxxxxxxxxxxxxxxxxx
HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.3-fpm.sock:", host: "x.x.x.x"

Server configuration

Operating system: Debian 9
Web server: nginx/1.10.3
Database version: 10.1.41-MariaDB-0+deb9u1 - Debian 9.9
PHP version: 7.3.14-1+0~20200123.51+debian9~1.gbpcf42df
phpMyAdmin version: 5.0.1

Client configuration

Browser: Chromium 79.0.3945.79
Operating system: Lubuntu 18.04

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

williamdes · 2020-01-29T17:47:05Z

@yashrajbothra could you please have a look? (if you want ^^)

yashrajbothra · 2020-01-29T18:28:14Z

Definitely👍

yashrajbothra · 2020-01-29T22:01:48Z

After some lookup in error log i found error is related to sorting of table headers. Can you please try to elborate whole story of the issue @felsd which can help me reproducing.

if you can give structure of those tables it can help?

felsd · 2020-01-30T05:56:07Z

Only one table is affected.

Structure


#	Name		Type		Collation	Attributes			Null	Default		Comments	Extra
1	id (Primary)	int(11)								No	None				AUTO_INCREMENT
2	column_1	varchar(64)	utf8mb4_general_ci				No	None		
3	column_2	varchar(64)	utf8mb4_general_ci				No	None		
4	column_3	varchar(64)	utf8mb4_general_ci				No	None		
5	column_4	varchar(64)	utf8mb4_general_ci				No	None		
6	column_5	varchar(64)	utf8mb4_general_ci				Yes	NULL		
7	column_6	varchar(128)	utf8mb4_general_ci				Yes	NULL		
8	column_7	text		utf8mb4_general_ci				Yes	NULL		
9	column_8	int(11)								No	None		
10	column_9	tinyint(1)							No	None		
11	column_10	tinyint(1)							No	None		
12	column_11	tinyint(1)							No	0		
13	column_12	tinyint(1)							No	0		
14	column_13	tinyint(1)							No	None		
15	column_14	timestamp							No	CURRENT_TIMESTAMP		
16	column_15	timestamp			on update CURRENT_TIMESTAMP	No	0000-00-00 00:00:00		ON UPDATE CURRENT_TIMESTAMP
17	column_16	timestamp							Yes	NULL		
18	column_17	varchar(16)	utf8mb4_general_ci				Yes	NULL		
19	column_18	timestamp							Yes	NULL

Indexes

Keyname		Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY		BTREE	Yes	No	id	17390		A		No

Partitions

 No partitioning defined!

Additional Info

Data: 6.5 MiB
Overhead: 4.0 MiB
Effective: 2.5 MiB
Total: 6.5 MiB
---
Format: Compact
Collation: utf8mb4_general_ci
Next autoindex: 30,300

The Story

When I click on "Browse" I get the error dialog that I mentioned and the exception appears in the nginx log.

The previous sorting of that table was either by id descending or by of the timestamp columns (column_14, column_15, column_16 or column_18).
I can't tell you that with certainty because I am not the only one browsing that table.
(preg_match('@time|date@i', NULL) might suggest that it is one of the timestamp columns?)

yashrajbothra · 2020-01-30T08:28:29Z

@felsd Are you getting error again n again or it was only one time?

felsd · 2020-01-30T10:54:10Z

I still get that error.

yashrajbothra · 2020-01-30T12:20:29Z

I added the affected table structure to my local machine and tried reproducing the issue but unfortunately i was unable to reproduce the error.

table structure

-- phpMyAdmin SQL Dump
-- version 5.1.0-dev
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2020 at 01:10 PM
-- Server version: 10.1.35-MariaDB
-- PHP Version: 7.2.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `bsr`
--

-- --------------------------------------------------------

--
-- Table structure for table `table`
--

CREATE TABLE `table` (
  `id` int(11) NOT NULL,
  `column_1` varchar(64) CHARACTER SET utf8mb4 NOT NULL,
  `column_2` varchar(64) CHARACTER SET utf8mb4 NOT NULL,
  `column_3` varchar(64) CHARACTER SET utf8mb4 NOT NULL,
  `column_4` varchar(64) CHARACTER SET utf8mb4 NOT NULL,
  `column_5` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `column_6` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL,
  `column_7` text CHARACTER SET utf8mb4,
  `column_8` int(11) NOT NULL,
  `column_9` tinyint(1) NOT NULL,
  `column_10` tinyint(1) NOT NULL,
  `column_11` tinyint(1) NOT NULL DEFAULT '0',
  `column_12` tinyint(1) NOT NULL DEFAULT '0',
  `column_13` tinyint(1) NOT NULL,
  `column_14` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `column_15` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `column_16` timestamp NULL DEFAULT NULL,
  `column_17` varchar(16) CHARACTER SET utf8mb4 DEFAULT NULL,
  `column_18` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `table`
--
ALTER TABLE `table`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `table`
--
ALTER TABLE `table`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

@williamdes Can You please help me reproducing the issue ?

williamdes · 2020-01-30T14:35:24Z

@yashrajbothra sorry, no computer for now
I am traveling, when I get home in a week if no one found a solution :)

yashrajbothra · 2020-02-11T18:58:39Z

Ping @williamdes

williamdes · 2020-02-11T21:38:21Z

I could not reproduce the issue but I am investigating
Thank you for the ping

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

williamdes · 2020-02-11T22:46:02Z

@felsd can you try af18dce ?

felsd · 2020-02-17T08:05:09Z

@williamdes Sorry for the late response - I just tried that but it didn't to the trick unfortunately.

Here is a more detailed error message:

 Undefined offset: 2

Backtrace

./libraries/classes/Display/Results.php#2614: PhpMyAdmin\Display\Results->_getRowValues(
,
array,
integer 0,
boolean false,
array,
string 'grid_edit click2',
array,
string 'SELECT * FROM `accounts` ORDER BY `last_session` ASC ',
array,
)
./libraries/classes/Display/Results.php#4300: PhpMyAdmin\Display\Results->_getTableBody(
,
array,
array,
array,
boolean false,
)
./libraries/classes/Sql.php#1666: PhpMyAdmin\Display\Results->getTable(
,
array,
array,
boolean false,
)
./libraries/classes/Sql.php#2002: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean true,
string '20095',
integer 25,
NULL,
,
array,
)
./libraries/classes/Sql.php#2271: PhpMyAdmin\Sql->getQueryResponseForResultsReturned(
,
array,
string 'MY_DATABASE_NAME',
string 'accounts',
NULL,
NULL,
,
string './themes/pmahomme/img/',
string '20095',
integer 25,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'SELECT * FROM `accounts` ORDER BY `last_session` ASC ',
NULL,
)
./libraries/classes/Sql.php#2100: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean true,
string 'MY_DATABASE_NAME',
string 'accounts',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `accounts` ORDER BY `last_session` ASC ',
NULL,
NULL,
)
./sql.php#241: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
array,
boolean true,
string 'MY_DATABASE_NAME',
string 'accounts',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `accounts`',
NULL,
NULL,
)

williamdes · 2020-02-17T08:16:00Z

Thank you
I opened a new bug #15972

hcniet · 2020-03-11T11:49:29Z

I had the same issue. i try go to table options (operations) -> flush table and OPTIMIZE TABLE. This work for me. Maybe the problem is with mysql cache.

felsd · 2020-03-11T13:47:14Z

@hcniet Thank you, that fixed it for me.

ajengrf · 2020-05-17T09:53:28Z

I had the same issue. i try go to table options (operations) -> flush table and OPTIMIZE TABLE. This work for me. Maybe the problem is with mysql cache.

@hcniet thanks you saved me!

beYondeR732 · 2020-10-30T02:54:25Z

I got the same issue on few tables.
It occured after I changed the position of some columns in a SELECT's results.

To fix it, go to : structure tab > Move columns, switch some columns and save.

williamdes · 2020-10-30T09:38:24Z

Are you using the latest version @beYondeR732 ?

beYondeR732 · 2020-10-31T15:48:41Z

I was on version 4.8 when I had the issue.
I upgraded to the latest version (5.0.4) but it didn't fix the problem.

The solution posted above worked fine for me.

mityan64 · 2021-05-31T15:55:44Z

I was on version 4.8 when I had the issue.
I upgraded to the latest version (5.0.4) but it didn't fix the problem.

The solution posted above worked fine for me.

My phpMyAdmin version : 5.1.0-3.el7.remi (up to date)
Thank you, it really helped me. The problem occurred when I started doing the sorting.

williamdes added the Bug A problem or regression with an existing feature label Jan 29, 2020

williamdes added this to Needs triage in issues via automation Jan 29, 2020

williamdes moved this from Needs triage to Medium priority in issues Jan 29, 2020

williamdes moved this from Medium priority to Needs triage in issues Jan 29, 2020

williamdes moved this from Needs triage to High priority in issues Jan 29, 2020

williamdes added this to the 5.0.2 milestone Jan 29, 2020

williamdes self-assigned this Feb 11, 2020

williamdes added a commit that referenced this issue Feb 11, 2020

Add ChangeLog entry for #15877

a49e051

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

williamdes closed this as completed in af18dce Feb 11, 2020

issues automation moved this from High priority to Closed Feb 11, 2020

williamdes mentioned this issue Feb 17, 2020

Notice in ./libraries/classes/Display/Results.php#2787 Undefined offset: 2 #15972

Closed

github-actions bot locked as resolved and limited conversation to collaborators Jun 1, 2022

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

One specific table can not be browsed anymore: preg_match() expects parameter 2 to be string, null given #15877

One specific table can not be browsed anymore: preg_match() expects parameter 2 to be string, null given #15877

felsd commented Jan 29, 2020 •

edited by williamdes

williamdes commented Jan 29, 2020

yashrajbothra commented Jan 29, 2020

yashrajbothra commented Jan 29, 2020

felsd commented Jan 30, 2020 •

edited

yashrajbothra commented Jan 30, 2020

felsd commented Jan 30, 2020

yashrajbothra commented Jan 30, 2020 •

edited by williamdes

williamdes commented Jan 30, 2020

yashrajbothra commented Feb 11, 2020

williamdes commented Feb 11, 2020

williamdes commented Feb 11, 2020

felsd commented Feb 17, 2020

williamdes commented Feb 17, 2020 •

edited

hcniet commented Mar 11, 2020 •

edited

felsd commented Mar 11, 2020

ajengrf commented May 17, 2020

beYondeR732 commented Oct 30, 2020 •

edited

williamdes commented Oct 30, 2020

beYondeR732 commented Oct 31, 2020

mityan64 commented May 31, 2021 •

edited

One specific table can not be browsed anymore: preg_match() expects parameter 2 to be string, null given #15877

One specific table can not be browsed anymore: preg_match() expects parameter 2 to be string, null given #15877

Comments

felsd commented Jan 29, 2020 • edited by williamdes

Server configuration

Client configuration

williamdes commented Jan 29, 2020

yashrajbothra commented Jan 29, 2020

yashrajbothra commented Jan 29, 2020

felsd commented Jan 30, 2020 • edited

Structure

Indexes

Partitions

Additional Info

The Story

yashrajbothra commented Jan 30, 2020

felsd commented Jan 30, 2020

yashrajbothra commented Jan 30, 2020 • edited by williamdes

williamdes commented Jan 30, 2020

yashrajbothra commented Feb 11, 2020

williamdes commented Feb 11, 2020

williamdes commented Feb 11, 2020

felsd commented Feb 17, 2020

williamdes commented Feb 17, 2020 • edited

hcniet commented Mar 11, 2020 • edited

felsd commented Mar 11, 2020

ajengrf commented May 17, 2020

beYondeR732 commented Oct 30, 2020 • edited

williamdes commented Oct 30, 2020

beYondeR732 commented Oct 31, 2020

mityan64 commented May 31, 2021 • edited

felsd commented Jan 29, 2020 •

edited by williamdes

felsd commented Jan 30, 2020 •

edited

yashrajbothra commented Jan 30, 2020 •

edited by williamdes

williamdes commented Feb 17, 2020 •

edited

hcniet commented Mar 11, 2020 •

edited

beYondeR732 commented Oct 30, 2020 •

edited

mityan64 commented May 31, 2021 •

edited