#4161 (ok 4.1.0-rc2) after UPDATE-query from inline edited SQL box, empty result table shows

Latest_Git
fixed
None
1
2013-12-12
2013-11-22
Raimund Meyer
No

Steps to reproduce
1. click Browse tab
2. click "Inline" below the SQL box
3. change "SELECT * FROM ..." to "UPDATE ..."
4. click Go
5. an empty result table and several PHP errors/warnings appear

See attached screenshot.

Tested on demo server

1 Attachments

Discussion

  • Raimund Meyer
    Raimund Meyer
    2013-11-22

    These are the warnings:

    Warning in ./libraries/dbi/DBIMysqli.class.php#617
    mysqli_fetch_fields() expects parameter 1 to be mysqli_result, boolean given

    Backtrace

    ./libraries/dbi/DBIMysqli.class.php#617: mysqli_fetch_fields(boolean true)
    ./libraries/DatabaseInterface.class.php#2267: PMA_DBI_Mysqli->getFieldsMeta(boolean true)
    ./libraries/sql.lib.php#2025: PMA_DatabaseInterface->getFieldsMeta(boolean true)
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Warning in ./libraries/sql.lib.php#313
    Invalid argument supplied for foreach()

    Backtrace

    ./libraries/sql.lib.php#2048: PMA_resultSetContainsUniqueKey(
    string 'test',
    string 'users',
    boolean false,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Warning in ./libraries/dbi/DBIMysqli.class.php#617
    mysqli_fetch_fields() expects parameter 1 to be mysqli_result, boolean given

    Backtrace

    ./libraries/dbi/DBIMysqli.class.php#617: mysqli_fetch_fields(boolean true)
    ./libraries/DatabaseInterface.class.php#2267: PMA_DBI_Mysqli->getFieldsMeta(boolean true)
    ./libraries/sql.lib.php#1848: PMA_DatabaseInterface->getFieldsMeta(boolean true)
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#458
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#4498: PMA_DisplayResults->_setDisplayMode(
    string 'nnnn010111',
    integer 1,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#470
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#4498: PMA_DisplayResults->_setDisplayMode(
    string 'nnnn010111',
    integer 1,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#1120
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#4603: PMA_DisplayResults->_getTableHeaders(
    array,
    array,
    string '',
    string '',
    string '',
    boolean false,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#1122
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#4603: PMA_DisplayResults->_getTableHeaders(
    array,
    array,
    string '',
    string '',
    string '',
    boolean false,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#1797
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#1128: PMA_DisplayResults->_getCommentForRow(
    array,
    NULL,
    )
    ./libraries/DisplayResults.class.php#4603: PMA_DisplayResults->_getTableHeaders(
    array,
    array,
    string '',
    string '',
    string '',
    boolean false,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#2233
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#1158: PMA_DisplayResults->_getDraggableClassForNonSortableColumns(
    boolean false,
    NULL,
    boolean false,
    string 'horizontal',
    NULL,
    string '',
    )
    ./libraries/DisplayResults.class.php#4603: PMA_DisplayResults->_getTableHeaders(
    array,
    array,
    string '',
    string '',
    string '',
    boolean false,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#2244
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#1158: PMA_DisplayResults->_getDraggableClassForNonSortableColumns(
    boolean false,
    NULL,
    boolean false,
    string 'horizontal',
    NULL,
    string '',
    )
    ./libraries/DisplayResults.class.php#4603: PMA_DisplayResults->_getTableHeaders(
    array,
    array,
    string '',
    string '',
    string '',
    boolean false,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#1164
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#4603: PMA_DisplayResults->_getTableHeaders(
    array,
    array,
    string '',
    string '',
    string '',
    boolean false,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Notice in ./libraries/DisplayResults.class.php#1166
    Trying to get property of non-object

    Backtrace

    ./libraries/DisplayResults.class.php#4603: PMA_DisplayResults->_getTableHeaders(
    array,
    array,
    string '',
    string '',
    string '',
    boolean false,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    Warning in ./libraries/dbi/DBIMysqli.class.php#334
    mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given

    Backtrace

    ./libraries/dbi/DBIMysqli.class.php#334: mysqli_fetch_array(
    boolean true,
    integer 2,
    )
    ./libraries/DatabaseInterface.class.php#2112: PMA_DBI_Mysqli->fetchRow(boolean true)
    ./libraries/DisplayResults.class.php#2549: PMA_DatabaseInterface->fetchRow(boolean true)
    ./libraries/DisplayResults.class.php#4608: PMA_DisplayResults->_getTableBody(
    boolean true,
    array,
    array,
    array,
    boolean false,
    )
    ./libraries/sql.lib.php#1864: PMA_DisplayResults->getTable(
    boolean true,
    string 'nnnn010111',
    array,
    )
    ./libraries/sql.lib.php#2121: PMA_getHtmlForSqlQueryResultsTable(
    NULL,
    object,
    string 'test',
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    string 'nnnn110111',
    string '',
    boolean false,
    integer 1,
    integer 1,
    NULL,
    boolean true,
    array,
    )
    ./libraries/sql.lib.php#2221: PMA_sendQueryResponseForResultsReturned(
    boolean true,
    boolean true,
    array,
    string 'test',
    string 'users',
    NULL,
    NULL,
    NULL,
    object,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    integer 1,
    integer 1,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./libraries/sql.lib.php#2334: PMA_sendQueryResponse(
    integer 1,
    integer 1,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    array,
    object,
    NULL,
    boolean true,
    boolean true,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    string '',
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    )
    ./import.php#631: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean false,
    string 'test',
    string 'users',
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    boolean false,
    NULL,
    NULL,
    NULL,
    NULL,
    string 'tbl_structure.php',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'UPDATE users SET active = 0',
    NULL,
    NULL,
    )
    phpMyAdmin Demo Server: Currently running Git revision RELEASE_4_1_0BETA2-239-g6161c10 from the master branch.

     
  • Marc Delisle
    Marc Delisle
    2013-11-22

    In 4.0.9, I obtain the Structure page for this table, which is still different than the results page.

     
    • assigned_to: Madhura Jayaratne
     
    • summary: after UPDATE-query from inline edited SQL box, empty result table shows --> (ok 4.1.0-rc2) after UPDATE-query from inline edited SQL box, empty result table shows
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle
    Marc Delisle
    2013-12-12

    • Status: resolved --> fixed