Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Undefined index: Key_block_size #17697

Open
liviuconcioiu opened this issue Aug 28, 2022 · 0 comments
Open

Undefined index: Key_block_size #17697

liviuconcioiu opened this issue Aug 28, 2022 · 0 comments
Labels
Bug A problem or regression with an existing feature
Milestone

Comments

@liviuconcioiu
Copy link
Contributor

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:

  1. Go to structure tab of any table
  2. Create two columns, add index on them
  3. 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(
    ,
    ,
    ,
    )
@williamdes williamdes added this to the 5.3.0 milestone Aug 29, 2022
@williamdes williamdes added the Bug A problem or regression with an existing feature label Aug 29, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug A problem or regression with an existing feature
Projects
None yet
Development

No branches or pull requests

2 participants