Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp
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.

SQL queries

SQL queries settings.

Documentation Defines whether SQL queries generated by phpMyAdmin should be displayed.
Documentation Whether a warning ("Are your really sure…") should be displayed when you're about to lose data.
Documentation How many queries are kept in history.i
Documentation If enabled, phpMyAdmin continues computing multiple-statement queries even if one of the queries failed.
Documentation Maximum number of characters used when a SQL query is displayed.
Documentation Defines whether the query box should stay on-screen after its submission.
Documentation Use user-friendly editor for editing SQL queries (CodeMirror) with syntax highlighting and line numbers.
Documentation Find any errors in the query before executing it. Requires CodeMirror to be enabled.
Documentation Autocomplete of the table and column names in the SQL queries.
Documentation Default value for foreign key checks checkbox for some queries.
Run SQL query/queries on database herp: Documentation
xxxxxxxxxx
1
 
1
Documentation
]
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 *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'table_stats\' ORDER BY Name ASC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'table_stats\' ORDER BY Name ASC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'table_stats\' ORDER BY Name ASC',
NULL,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#570: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'table_stats\' ORDER BY Name ASC',
array,
NULL,
NULL,
)
./libraries/Table.class.php#321: PMA_DatabaseInterface->getTablesFull(
string 'mysql',
string 'table_stats',
)
./libraries/controllers/DatabaseStructureController.class.php#294: PMA_Table->getStatusInfo(
NULL,
boolean true,
)
./db_structure.php#54: PMA\Controllers\DatabaseStructureController->indexAction()
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 *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'table_stats\' ORDER BY Name ASC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'table_stats\' ORDER BY Name ASC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'table_stats\' ORDER BY Name ASC',
NULL,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#570: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'table_stats\' ORDER BY Name ASC',
array,
NULL,
NULL,
)
./libraries/Table.class.php#321: PMA_DatabaseInterface->getTablesFull(
string 'mysql',
string 'table_stats',
)
./libraries/controllers/DatabaseStructureController.class.php#294: PMA_Table->getStatusInfo(
NULL,
boolean true,
)
./db_structure.php#54: PMA\Controllers\DatabaseStructureController->indexAction()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
Error while sending QUERY packet. PID=3773480

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'table_stats\' ORDER BY version DESC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'table_stats\' ORDER BY version DESC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#94: PMA_DatabaseInterface->tryQuery(
string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'table_stats\' ORDER BY version DESC',
object,
integer 0,
boolean false,
)
./libraries/relation.lib.php#38: PMA_DatabaseInterface->query(
string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'table_stats\' ORDER BY version DESC',
object,
integer 0,
boolean false,
)
./libraries/Tracker.class.php#143: PMA_queryAsControlUser(string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'table_stats\' ORDER BY version DESC')
./libraries/controllers/DatabaseStructureController.class.php#447: PMA_Tracker::isTracked(
string 'mysql',
string 'table_stats',
)
./db_structure.php#54: PMA\Controllers\DatabaseStructureController->indexAction()