Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Tables Not Listed In Object Browser Since Mysql Upgrade

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Tables Not Listed In Object Browser Since Mysql Upgrade

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 22, 2006 at 5:34 am #23129
      peterlaursen
      Participant

      We have had this issue a couple of times before.  It occurs because of a privilege issue (privileges to the `Information_Schema` table) on the server.  Basically ist is because of a mistake by Sysadmins when upgrading MySQL.

      SQLyog sends the query:

      Code:
      select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = '***' and `TABLE_TYPE` = 'BASE TABLE'

      What happens if you write that query yourself? You SHOULD be able to get result from the objects that are yours!!

      However also read this:

      http://www.webyog.com/forums//index.php?sh…view=getnewpost

      .. from next release we we not query information schema when there are other ways to get the information.

    • December 22, 2006 at 2:54 pm #23130
      peterlaursen
      Participant

      SQLyog 5.22 RC1 is now released.

       

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.