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

Cannot browse when table name contains keyword "call" #10295

Closed
pma-import opened this issue May 1, 2013 · 5 comments
Closed

Cannot browse when table name contains keyword "call" #10295

pma-import opened this issue May 1, 2013 · 5 comments
Labels
Bug A problem or regression with an existing feature
Milestone

Comments

@pma-import
Copy link

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 ,
)>


9f1f8d6 is the first bad commit
commit 9f1f8d6
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


@pma-import
Copy link
Author

  • summary: No table contents shown in browse mode --> Cannot browse when table name contains keyword "call"

  • Original author: lem9

@pma-import
Copy link
Author

Fixed with #375


  • Original author: lem9

@pma-import
Copy link
Author

  • 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

  • Original author: lem9

@pma-import
Copy link
Author

  • Status: open-fixed --> closed-fixed

  • Original author: lem9

@pma-import
Copy link
Author

  • Status: closed-fixed --> fixed

  • Original author: nijel

@pma-import pma-import added the Bug A problem or regression with an existing feature label Jul 24, 2015
@pma-import pma-import added this to the 4.0.2 milestone Jul 24, 2015
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jul 1, 2020
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
None yet
Development

No branches or pull requests

1 participant