Drop files here

SQL upload ( 0 ) x-

Server: localhost
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query
x
 
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
xxxxxxxxxx
 
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:
Some errors have been detected on the server!
Please look at the bottom of this window.

Databases

Database Ascending Collation
herplatin1_swedish_ci Check privileges Check privileges
hmislatin1_swedish_ci Check privileges Check privileges
information_schemautf8_general_ci Check privileges Check privileges
mysqllatin1_swedish_ci Check privileges Check privileges
performance_schemautf8_general_ci Check privileges Check privileges
phpmyadminutf8_bin Check privileges Check privileges
testlatin1_swedish_ci Check privileges Check privileges
Total: 7 latin1_swedish_ci
With selected:With selected:
Note: Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server.
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): MySQL server has gone away

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'hmis\' ) t ',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'hmis\' ) t ',
object,
integer 1,
)
./libraries/DatabaseInterface.class.php#1946: PMA_DatabaseInterface->tryQuery(
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'hmis\' ) t ',
NULL,
integer 1,
boolean false,
)
./libraries/navigation/NavigationTree.class.php#189: PMA_DatabaseInterface->fetchValue(string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'hmis\' ) t ')
./libraries/navigation/NavigationTree.class.php#100: PMA_NavigationTree->_getNavigationDbPos()
./libraries/navigation/Navigation.class.php#37: PMA_NavigationTree->__construct()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): Error reading result set's header

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'hmis\' ) t ',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'hmis\' ) t ',
object,
integer 1,
)
./libraries/DatabaseInterface.class.php#1946: PMA_DatabaseInterface->tryQuery(
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'hmis\' ) t ',
NULL,
integer 1,
boolean false,
)
./libraries/navigation/NavigationTree.class.php#189: PMA_DatabaseInterface->fetchValue(string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'hmis\' ) t ')
./libraries/navigation/NavigationTree.class.php#100: PMA_NavigationTree->_getNavigationDbPos()
./libraries/navigation/Navigation.class.php#37: PMA_NavigationTree->__construct()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): MySQL server has gone away

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#814: PMA_DatabaseInterface->fetchResult(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
string 'db_name',
string 'count',
object,
)
./libraries/navigation/NavigationTree.class.php#280: Node->getNavigationHidingData()
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): Error reading result set's header

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#814: PMA_DatabaseInterface->fetchResult(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
string 'db_name',
string 'count',
object,
)
./libraries/navigation/NavigationTree.class.php#280: Node->getNavigationHidingData()
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()