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 table_schema #16791

Closed
liviuconcioiu opened this issue Apr 3, 2021 · 0 comments
Closed

Undefined index table_schema #16791

liviuconcioiu opened this issue Apr 3, 2021 · 0 comments
Assignees
Labels
Bug A problem or regression with an existing feature
Projects
Milestone

Comments

@liviuconcioiu
Copy link
Contributor

Describe the bug

If you run this query SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sakila', it will give a Undefined index: table_schema notice or warning for all table names.

To Reproduce

Steps to reproduce the behavior:

  1. Go to SQL
  2. Enter SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sakila'
  3. Click on Go
  4. Click on Edit inline
  5. Click on Go
  6. See error

Expected behavior

It shouldn't give any notices or warnings (PHP 8.0.3).

Screenshots

Untitled

Client configuration

  • Browser: Firefox
  • Operating system: Windows

Additional context

Notice in ./libraries/classes/Display/Results.php#3125
Undefined index: table_schema

Backtrace

Results.php#2939: PhpMyAdmin\Display\Results->getSpecialLinkUrl(
array,
string 'actor',
array,
string 'table_name',
)
Results.php#2656: PhpMyAdmin\Display\Results->getRowValues(
,
array,
integer 0,
boolean false,
array,
string '',
boolean false,
string 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = \'sakila\'',
array,
)
Results.php#4278: PhpMyAdmin\Display\Results->getTableBody(
,
array,
array,
array,
boolean false,
)
Sql.php#1368: PhpMyAdmin\Display\Results->getTable(
,
array,
array,
boolean false,
)
Sql.php#1624: PhpMyAdmin\Sql->getHtmlForSqlQueryResultsTable(
,
array,
boolean false,
integer 23,
integer 23,
NULL,
,
array,
)
Sql.php#1856: PhpMyAdmin\Sql->getQueryResponseForResultsReturned(
,
array,
string 'INFORMATION_SCHEMA',
string 'TABLES',
NULL,
,
integer 23,
integer 23,
NULL,
NULL,
NULL,
string 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = \'sakila\'',
NULL,
)
ImportController.php#840: PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(
array,
boolean false,
string 'INFORMATION_SCHEMA',
string 'TABLES',
NULL,
NULL,
NULL,
NULL,
NULL,
string 'index.php?route=/table/structure',
NULL,
NULL,
string 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = \'sakila\'',
NULL,
)
Routing.php#189: PhpMyAdmin\Controllers\ImportController->index(array)
index.php#18: PhpMyAdmin\Routing::callControllerForRoute(
string '/import',
,
,
)
@williamdes williamdes added the question Used when we need feedback from the submitter or when the issue is a question about PMA label Apr 12, 2021
@williamdes williamdes added this to Needs triage in Questions via automation Apr 12, 2021
@williamdes williamdes moved this from Needs triage to Needs a second check to be a bug in Questions Apr 12, 2021
@williamdes williamdes added Bug A problem or regression with an existing feature and removed question Used when we need feedback from the submitter or when the issue is a question about PMA labels Apr 12, 2021
@williamdes williamdes added this to Needs triage in issues via automation Apr 12, 2021
@williamdes williamdes removed this from Needs a second check to be a bug in Questions Apr 12, 2021
@williamdes williamdes moved this from Needs triage to Reproduced in issues Apr 12, 2021
@williamdes williamdes self-assigned this Apr 12, 2021
@williamdes williamdes added this to the 5.1.1 milestone Apr 12, 2021
williamdes added a commit that referenced this issue Apr 12, 2021
Signed-off-by: William Desportes <williamdes@wdes.fr>
issues automation moved this from Reproduced to Closed Apr 13, 2021
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Apr 14, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Bug A problem or regression with an existing feature
Projects
issues
  
Closed
Development

No branches or pull requests

2 participants