#3445 Tables not found in DB with 123 tables

3.4.7
fixed
nobody
5
2013-06-11
2011-10-03
No

I have DB with 123 tables, but phpmyadmin shows me "No tables found in database." when i try to enter in it.

All other databases works correctly.

When i try to connect to DB using ssh it works fine, and site that uses this DB works fine too

Discussion

  •  
    Attachments
    • labels: --> Displaying results
    • milestone: --> 1232560
     
  • Marc Delisle
    Marc Delisle
    2011-10-03

    Can you try with the current stable version of phpMyAdmin (3.4.5)?

     
  • Marc Delisle
    Marc Delisle
    2011-10-03

    • status: open --> pending
     
  • I tried with phpmyadmin 3.4.7 and bug is present.

    Using "SHOW TABLES" i can see all tables in this database.

     
  • show tables found my tables

     
    Attachments
    • milestone: 1232560 --> 3.4.7
    • status: pending --> open
     
  • Yeah! i'm fixed it!

    I read the function PMA_DBI_get_tables_full, and tried to do a query

    SELECT *,
    `TABLE_SCHEMA` AS `Db`,
    `TABLE_NAME` AS `Name`,
    `TABLE_TYPE` AS `TABLE_TYPE`,
    `ENGINE` AS `Engine`,
    `ENGINE` AS `Type`,
    `VERSION` AS `Version`,
    `ROW_FORMAT` AS `Row_format`,
    `TABLE_ROWS` AS `Rows`,
    `AVG_ROW_LENGTH` AS `Avg_row_length`,
    `DATA_LENGTH` AS `Data_length`,
    `MAX_DATA_LENGTH` AS `Max_data_length`,
    `INDEX_LENGTH` AS `Index_length`,
    `DATA_FREE` AS `Data_free`,
    `AUTO_INCREMENT` AS `Auto_increment`,
    `CREATE_TIME` AS `Create_time`,
    `UPDATE_TIME` AS `Update_time`,
    `CHECK_TIME` AS `Check_time`,
    `TABLE_COLLATION` AS `Collation`,
    `CHECKSUM` AS `Checksum`,
    `CREATE_OPTIONS` AS `Create_options`,
    `TABLE_COMMENT` AS `Comment`
    FROM `information_schema`.`TABLES`
    WHERE `TABLE_SCHEMA` IN ('some_base')

    And it shows me error "user ''@'%' don't have permissions to select blah blah"

    I tried to do:
    CREATE USER ''@'%' IDENTIFIED BY '***';
    GRANT SELECT ON * . *
    TO ''@'%'
    IDENTIFIED BY '***'
    WITH MAX_QUERIES_PER_HOUR 0
    MAX_CONNECTIONS_PER_HOUR 0
    MAX_UPDATES_PER_HOUR 0
    MAX_USER_CONNECTIONS 0 ;

    And now all works fine!

     
  • i think you need to show this error if PMA_DBI_get_tables_full fails

     
    • status: open --> closed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed --> fixed