competence-rs.com / localhost

Recent

There are no recent tables.

Favorites

There are no favorite tables.

Drop files here

SQL upload ( 0 ) x-

Server: localhost

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Import

More settings

You can set more settings by modifying config.inc.php, eg. by using Setup script.

Export

Reset

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 `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
NULL,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#460: PMA_DatabaseInterface->fetchResult(string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC')
./libraries/navigation/NavigationTree.class.php#279: Node->getData(
string 'databases',
integer 0,
string '',
)
./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 `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
NULL,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#460: PMA_DatabaseInterface->fetchResult(string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC')
./libraries/navigation/NavigationTree.class.php#279: Node->getData(
string 'databases',
integer 0,
string '',
)
./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(): 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()

Notice in ./libraries/DatabaseInterface.class.php#2623

Undefined offset: 1

Backtrace

./libraries/Menu.class.php#522: PMA_DatabaseInterface->isUserType(string 'grant')
./libraries/Menu.class.php#108: PMA_Menu->_getServerTabs()
./libraries/Menu.class.php#73: PMA_Menu->_getMenu()
./libraries/Header.class.php#456: PMA_Menu->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()

Notice in ./libraries/DatabaseInterface.class.php#2618

Undefined offset: 1

Backtrace

./libraries/Menu.class.php#523: PMA_DatabaseInterface->isUserType(string 'create')
./libraries/Menu.class.php#108: PMA_Menu->_getServerTabs()
./libraries/Menu.class.php#73: PMA_Menu->_getMenu()
./libraries/Header.class.php#456: PMA_Menu->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()