Menu

#3902 (ok 4.0.2) Cannot browse when table name contains keyword "call"

4.0.0
fixed
None
1
2015-01-29
2013-05-01
No

There is no contents shown in the Browse tab, just the Bookmark box.

Import this table:

--
-- Table structure for table `mpapi_apicalls`
--

CREATE TABLE IF NOT EXISTS `mpapi_apicalls` (
  `id` int(1) NOT NULL AUTO_INCREMENT,
  `called` datetime NOT NULL,
  `query` text NOT NULL,
  `reply` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mpapi_apicalls`
--

INSERT INTO `mpapi_apicalls` (`id`, `called`, `query`, `reply`) VALUES
(1, '2013-05-01 00:00:00', 'test', 'test');

Open the table's Browse tab, and get this (developer-mode) error:

Notice in .\sql.php#1086
Undefined variable: sql_data

Warning in .\sql.php#1280
implode(): Invalid arguments passed

Backtrace

.\sql.php#1280: implode(
string ;,
NULL,
)
.\sql.php#1088: getTableHtmlForMultipleQueries(
object,
string test1,
NULL,
string tbl_structure.php,
string ./themes/pmahomme/img/,
string ltr,
NULL,
string db=test1&table=mpapi_apicalls&token=6a2435c059f342752fc89cb09955db74&goto=tbl_sql.php&back=tbl_sql.php,
string urdr111101,
string LIMIT 0, 30 ,
)

Warning in .\libraries\dbi\mysqli.dbi.lib.php#587
mysqli_fetch_fields() expects parameter 1 to be mysqli_result, boolean given

Backtrace

.\libraries\dbi\mysqli.dbi.lib.php#587: mysqli_fetch_fields(boolean )
.\sql.php#1297: PMA_DBI_get_fields_meta(boolean )
.\sql.php#1088: getTableHtmlForMultipleQueries(
object,
string test1,
NULL,
string tbl_structure.php,
string ./themes/pmahomme/img/,
string ltr,
NULL,
string db=test1&table=mpapi_apicalls&token=6a2435c059f342752fc89cb09955db74&goto=tbl_sql.php&back=tbl_sql.php,
string urdr111101,
string LIMIT 0, 30 ,
)

Runtime Notice in .\libraries\dbi\mysqli.dbi.lib.php#367
mysqli_next_result(): There is no next result set. Please, call mysqli_more_results()/mysqli::more_results() to check whether to call this function/method

Backtrace

.\libraries\dbi\mysqli.dbi.lib.php#367: mysqli_next_result(object)
.\sql.php#1370: PMA_DBI_next_result()
.\sql.php#1088: getTableHtmlForMultipleQueries(
object,
string test1,
NULL,
string tbl_structure.php,
string ./themes/pmahomme/img/,
string ltr,
NULL,
string db=test1&table=mpapi_apicalls&token=6a2435c059f342752fc89cb09955db74&goto=tbl_sql.php&back=tbl_sql.php,
string urdr111101,
string LIMIT 0, 30 ,
)>


9f1f8d6c75c4f4332f5e78ffd9fc66747c2ea226 is the first bad commit
commit 9f1f8d6c75c4f4332f5e78ffd9fc66747c2ea226
Author: Chanaka Indrajith
Date: Sun Jul 22 16:22:49 2012 +0530

Support for stored procedures with multiple queries

:040000 040000 d9d44cf656672310de0e5c9196dbfaf768f5b772 04de70c1cb270a1cf90455bb
176d02c17100f53a M libraries
:100644 100644 27df11e36b3f3c4c2ce3a6902b57e02e8c6c0aad 654f8ab96e2e0927ea5b9b4c
326cbcca18bd6c1c M sql.php

Discussion

  • Marc Delisle

    Marc Delisle - 2013-05-12
    • summary: No table contents shown in browse mode --> Cannot browse when table name contains keyword "call"
     
  • Marc Delisle

    Marc Delisle - 2013-05-14
    • summary: Cannot browse when table name contains keyword "call" --> (ok 4.0.2) Cannot browse when table name contains keyword "call"
    • status: open --> open-fixed
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2013-05-24
    • Status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed