Undefined index: Key_block_size #17697
Description
Describe the bug
This error happens when you try to create new columns with index. This happens only on master. Also this error pops too The names '' are MySQL reserved keywords.
To Reproduce
Steps to reproduce the behavior:
- Go to structure tab of any table
- Create two columns, add index on them
- See error
Expected behavior
The columns should be created, with index, and no error should be given.
Screenshots
28.08.2022_23.10.47_REC.mp4
Server configuration
- Operating system: Linux
- Web server: nginx/1.14.2
- Database version: MySQL 8.0.18
- PHP version: 7.4.29
- phpMyAdmin version: 5.3.0-dev
Client configuration
- Browser: Firefox
- Operating system: Windows
Additional context
Notice in ./libraries/classes/CreateAddField.php#184
Undefined index: Key_block_size
Backtrace
CreateAddField.php#251: PhpMyAdmin\CreateAddField->buildIndexStatement(
array,
string 'INDEX',
boolean false,
)
CreateAddField.php#462: PhpMyAdmin\CreateAddField->getColumnCreationStatements(boolean false)
AddFieldController.php#116: PhpMyAdmin\CreateAddField->getColumnCreationQuery(string 'usuario')
Routing.php#164: PhpMyAdmin\Controllers\Table\AddFieldController->__invoke(
,
array,
)
index.php#40: PhpMyAdmin\Routing::callControllerForRoute(
,
,
,
)
Notice in ./libraries/classes/CreateAddField.php#193
Undefined index: Index_type
Backtrace
CreateAddField.php#251: PhpMyAdmin\CreateAddField->buildIndexStatement(
array,
string 'INDEX',
boolean false,
)
CreateAddField.php#462: PhpMyAdmin\CreateAddField->getColumnCreationStatements(boolean false)
AddFieldController.php#116: PhpMyAdmin\CreateAddField->getColumnCreationQuery(string 'usuario')
Routing.php#164: PhpMyAdmin\Controllers\Table\AddFieldController->__invoke(
,
array,
)
index.php#40: PhpMyAdmin\Routing::callControllerForRoute(
,
,
,
)
Notice in ./libraries/classes/CreateAddField.php#202
Undefined index: Index_comment
Backtrace
CreateAddField.php#251: PhpMyAdmin\CreateAddField->buildIndexStatement(
array,
string 'INDEX',
boolean false,
)
CreateAddField.php#462: PhpMyAdmin\CreateAddField->getColumnCreationStatements(boolean false)
AddFieldController.php#116: PhpMyAdmin\CreateAddField->getColumnCreationQuery(string 'usuario')
Routing.php#164: PhpMyAdmin\Controllers\Table\AddFieldController->__invoke(
,
array,
)
index.php#40: PhpMyAdmin\Routing::callControllerForRoute(
,
,
,
)