#2820 Showing the details of a database fails

1.340
closed
Jamie Cameron
5
2007-04-30
2007-04-30
Gerhard Wanner
No

When I click on one of my databases in the list of databases under server -> mysql the following error occurs:
SQL select table_schema,table_name from information_schema.views schlug fehl: Incorrect table name 'columns_priv'

Mysql is running, all other applications work fine (also mysqladmin)

I recently upgrade from Centos 4.4 to Centos 5 and also to the latest release of Webmin (1.340).

Discussion

  • Jamie Cameron
    Jamie Cameron
    2007-04-30

    Logged In: YES
    user_id=129364
    Originator: NO

    This must be a a MySQL bug - if you look at the query Webmin makes :

    select table_schema,table_name from information_schema.views

    it doesn't refer to columns_priv at all. My guess is that the definition of that view is somehow incorrect.

     
  • Jamie Cameron
    Jamie Cameron
    2007-04-30

    • status: open --> closed