Can not see all DB's

[expired user #9925]'s profile image [expired user #9925] posted 8 years ago in General Permalink

Hey hey! I have got a bugreport (see appendix). After this I can not see all db's in the right DB view anymore. But "show databases;" show all DBs. What is wrong? Greetings Erik

1 attachment(s):
ansgar's profile image ansgar posted 8 years ago Permalink

I guess you are talking about tables, not db's, as the callstack you provided ends in ListTablesGetImageIndex, which is a place where HeidiSQL gets the icon for an object in a database, e.g. a table or procedure.

Please post a screenshot of what you actually see on the screen when that happens.

[expired user #9925]'s profile image [expired user #9925] posted 8 years ago Permalink

Thank you for reply.

No, I mean really the Databases. The bug happens as I copy tables from one Database to a other in the mass table editor. Before I saw 7 DB, after that I see only the actual DB and I can not change the DB over the mouse, only with the SQL statement "use <database>".

Please see attachment.

1 attachment(s):
  • DB-View
ansgar's profile image ansgar posted 8 years ago Permalink

Makes no sense in the code somehow. The callstack you provided tells me the exception happens in the "Database" tab, where a table or whatever asks for its icon. But the object's type seems to be some broken type of object, instead of "table", "view" or something. Probably one or more tables in that copied database is broken? Could you try to repair your tables using REPAIR TABLE yourtable?

[expired user #9925]'s profile image [expired user #9925] posted 8 years ago Permalink

I can not repair the tables, because I don't have anymore any tables in the DB. The bug occur as I copy all tables from one DB to a other. All tables are copy, but now I can see only on DB with no tables. It is not that much so bad, because I can work with the root and I have solve the problem on a other way.

Many Thanks for you help.

Please login to leave a reply, or register at first.