Hi,
I try to clean fog database because I had strange behavior today when I deployed some computers : snapin in pending task didn’t match to the right computer. And indeed there were a lot of snapin task and snapin job in database, thaht didn’t appear un web UI.
So i clean some database (and forgot to made a backup before, of course…) but now I have this message when I click on “tasks” database
Notice in ./libraries/classes/Display/Results.php#4442
Trying to access array offset on value of type null
Backtrace
./libraries/classes/Display/Results.php#4175: PhpMyAdmin\Display\Results->_getSortedColumnMessage(
,
string '`taskCreateTime`',
)
./libraries/classes/Sql.php#1759: PhpMyAdmin\Display\Results->getTable(
,
array,
array,
boolean true,
)
./libraries/classes/Sql.php#1533: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean false,
integer 0,
integer 0,
boolean true,
,
array,
boolean true,
)
./libraries/classes/Sql.php#2260: PhpMyAdmin\Sql->getQueryResponseForNoResultsReturned(
array,
string 'fog',
string 'tasks',
NULL,
integer 0,
,
NULL,
string './themes/pmahomme/img/',
NULL,
,
string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
NULL,
)
./libraries/classes/Sql.php#2137: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean true,
string 'fog',
string 'tasks',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
NULL,
NULL,
)
./sql.php#220: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
array,
boolean true,
string 'fog',
string 'tasks',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tasks`',
NULL,
NULL,
)
Notice in ./libraries/classes/Display/Results.php#4468
Trying to access array offset on value of type null
Backtrace
./libraries/classes/Display/Results.php#4175: PhpMyAdmin\Display\Results->_getSortedColumnMessage(
,
string '`taskCreateTime`',
)
./libraries/classes/Sql.php#1759: PhpMyAdmin\Display\Results->getTable(
,
array,
array,
boolean true,
)
./libraries/classes/Sql.php#1533: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean false,
integer 0,
integer 0,
boolean true,
,
array,
boolean true,
)
./libraries/classes/Sql.php#2260: PhpMyAdmin\Sql->getQueryResponseForNoResultsReturned(
array,
string 'fog',
string 'tasks',
NULL,
integer 0,
,
NULL,
string './themes/pmahomme/img/',
NULL,
,
string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
NULL,
)
./libraries/classes/Sql.php#2137: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean true,
string 'fog',
string 'tasks',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tasks` ORDER BY `taskCreateTime` ASC ',
NULL,
NULL,
)
./sql.php#220: PhpMyAdmin\Sql->executeQueryAndSendQueryResponse(
array,
boolean true,
string 'fog',
string 'tasks',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `tasks`',
NULL,
NULL,
)
I don't now if it's a problem but if you have some advces...
Thanks !
Matthieu