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

Can't View Tables

forums › forums › SQLyog › Using SQLyog › Can't View Tables

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • January 15, 2007 at 4:05 am #10128
      sjbrisson
      Member

      I have been using SQLyog for many months without a problem. For some reason, two days ago, the tables disappeared from the view. I was still able to log into the database server, and I know the tables are still there, but I can't view them. This is specific to certain database servers, so it is not a program wide problem. Has this happened to anyone else? The hosting company has tried everything, but I still cannot view the tables. They said they even tried SQLyog and said they were able to view them, meaning it would be something on my end. Any ideas would be greatly appreciated.

      Thank you.

      UPDATE: I still don't know what was causing the problem on the server side, but I upgraded my SQLyog from 5.21 to the latest 5.22 and the problem is gone. If anyone has any ideas of what would have caused this to begin with, I would still like to know in case it happens again. Thanks.

    • January 15, 2007 at 5:50 am #23232
      peterlaursen
      Participant

      I cannot tell in details what happened on the server side.

      But before 5.22 we used a query like “SELECT …FROM INFORMATION_SCHEMA ….”, now we “SHOW … STATUS ..”.

      Basically it is a configuration error on the server!  You should be able to SELECT details from INFORMATION_SCHEMA the details of those objects that are accessible from the user account that you are using!

    • January 15, 2007 at 2:24 pm #23233
      sjbrisson
      Member
      peterlaursen wrote on Jan 15 2007, 12:50 AM:
      I cannot tell in details what happened on the server side.

      But before 5.22 we used a query like “SELECT …FROM INFORMATION_SCHEMA ….”, now we “SHOW … STATUS ..”.

      Basically it is a configuration error on the server!  You should be able to SELECT details from INFORMATION_SCHEMA the details of those objects that are accessible from the user account that you are using!

      Thank you for the response. That's what I figured since none of the databases on other servers were effected. They admitted they had a problem with that server, but said it was fixed and should not have effected my databases. It's working now and hopefully we don't come across this again. Thanks again.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.