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

Error code 500 during pagination in table overview #15772

Closed
TobiasGrave opened this issue Jan 10, 2020 · 6 comments
Closed

Error code 500 during pagination in table overview #15772

TobiasGrave opened this issue Jan 10, 2020 · 6 comments
Assignees
Labels
Bug A problem or regression with an existing feature
Projects
Milestone

Comments

@TobiasGrave
Copy link

When selecting another page in the left table overview on a database with many tables so that pagination is required, I get the following error in the web browser:

Error in processing request
Error code: 500
Error text: Internal Server Error (rejected)
It seems that the connection to server has been lost. Please check your network connectivity and server status.

The error occurs with Firefox and Chrome, so it's probably not a browser problem.

I see the following error in the PHP error logs:

[10-Jan-2020 14:38:28 Europe/Berlin] PHP Fatal error:  Uncaught TypeError: Argument 2 passed to PhpMyAdmin\DatabaseInterface::dataSeek() must be of the type integer, string given, called in /var/www/phpmyadmin/libraries/classes/Navigation/Nodes/NodeDatabase.php on line 488 and defined in /var/www/phpmyadmin/libraries/classes/DatabaseInterface.php:2730
Stack trace:
#0 /var/www/phpmyadmin/libraries/classes/Navigation/Nodes/NodeDatabase.php(488): PhpMyAdmin\DatabaseInterface->dataSeek(Object(mysqli_result), '50')
#1 /var/www/phpmyadmin/libraries/classes/Navigation/Nodes/NodeDatabase.php(514): PhpMyAdmin\Navigation\Nodes\NodeDatabase->getTablesOrViews('tables', '50', '')
#2 /var/www/phpmyadmin/libraries/classes/Navigation/Nodes/NodeDatabase.php(373): PhpMyAdmin\Navigation\Nodes\NodeDatabase->getTables('50', '')
#3 /var/www/phpmyadmin/libraries/classes/Navigation/NavigationTree.php(400): PhpMyAdmin\Navigation\Nodes\NodeDatabase->getData('tables', '50', '')
#4 /var/www/phpmyadmin/libraries/classes/Navigation/NavigationTree.php(330): PhpMyAdmin\Navigation\NavigationTree->buildPathPart(Array in /var/www/phpmyadmin/libraries/classes/DatabaseInterface.php on line 2730

phpMyAdmin version is 5.0.1
PHP version is 7.2.26

@williamdes
Copy link
Member

@TobiasGrave can you send your config.inc.php file ?

@williamdes williamdes added this to Needs triage in issues via automation Jan 10, 2020
@williamdes williamdes added this to the 5.0.2 milestone Jan 10, 2020
@williamdes williamdes added the Bug A problem or regression with an existing feature label Jan 10, 2020
@TobiasGrave
Copy link
Author

TobiasGrave commented Jan 10, 2020

<?php

$cfg['blowfish_secret'] = 'SECRET'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */


$i = 0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = "localhost";
$cfg['Servers'][$i]['DisableIS'] = true;



?>

@yashrajbothra
Copy link
Contributor

Can anyone help me reproduce this error?

@williamdes williamdes self-assigned this Jan 10, 2020
@williamdes
Copy link
Member

Can anyone help me reproduce this error?

Yes
image

I am sending the fix, to simple for a PR

williamdes added a commit that referenced this issue Jan 10, 2020
Signed-off-by: William Desportes <williamdes@wdes.fr>
@williamdes
Copy link
Member

@TobiasGrave can you apply 6981910 and let us know if that solved the issue ?

@TobiasGrave
Copy link
Author

@williamdes Yes, that cast to int solved the issue.

issues automation moved this from Needs triage to Closed Jan 10, 2020
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jan 10, 2021
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

3 participants