SELECT MAX(version) - pma tracking - PMA does not detect that table is not accessible

[aavinseth]

Steps to reproduce

1. add aws db config code
2. restart xampp

Expected behaviour

Remote db should be open on selecting it and i should be able to view a table

Actual behaviour

showing SQL query error

Server configuration

Operating system: Amazon AWS Linux

Web server:

Database:

PHP version: 7.1.11

phpMyAdmin version: 4.7.7

Client configuration

Browser: Google Chrome

Operating system: Windows 10

[nijel]

Can you please share your configuration? It seems that you have phpMyAdmin configugation storage configured without the needed database setup...

[aavinseth]

Hey @nijel here is my xampp phpmyadmin config file

config.inc.txt

<?php

$i = 0;

$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';



?>

[nijel]

It seems that phpMyAdmin fails to detect that tracking tables are not there and still issues the query...

[williamdes]

@aavinseth Can you confirm having this issue on latest version of phpMyAdmin ?

[aavinseth]

@williamdes i have not checked it in new version yet. Will let you know soon about the same.

[aavinseth]

@williamdes this issue still exists in latest version i.e 4.8.5

[williamdes]

Is this issue similar to #15123 ?

[aavinseth]

@williamdes most probably its not similar to #15123

[williamdes]

mysql> use phpmyadmin;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from pma__tracking;
ERROR 1146 (42S02): Table 'phpmyadmin.pma__tracking' doesn't exist
mysql> show tables;
+------------------------+
| Tables_in_phpmyadmin   |
+------------------------+
| pma__bookmark          |
| pma__central_columns   |
| pma__column_info       |
| pma__designer_settings |
| pma__export_templates  |
| pma__favorite          |
| pma__history           |
| pma__navigationhiding  |
| pma__pdf_pages         |
| pma__recent            |
| pma__relation          |
| pma__savedsearches     |
| pma__table_coords      |
| pma__table_info        |
| pma__table_uiprefs     |
| pma__tracking          |
| pma__userconfig        |
| pma__usergroups        |
| pma__users             |
+------------------------+
19 rows in set (0.01 sec)

[williamdes]

@aavinseth can you try #15565 if you still have the server ?