distal-attribute
distal-attribute
distal-attribute
distal-attribute

jheidi - no database tree in left pane

User, date Message
Written by Jacques
6 years ago
Category: jHeidi (discontinued)
8 posts since Mon, 01 Dec 08
Hello There,
when I run jheidi I cannot get the database "tree" to show in the left pane the way that it does in "normal" HeidiSQL. Is this a bug or am I doing something wrong?

regards
Robert
Written by servertude
6 years ago
39 posts since Wed, 27 Feb 08
It could be a timing issue in the GUI.

To verify that the tree was actually loaded, please start jheidi connect to the database in question.

Double click on the "host" icon in the top of the left pane. That should force the tree to expand and show you the databases. I have only seen this very rarely, not sure the cause.

If that doesnt work then please give more details such as platform, version etc and we can check the log files for an error.

- Bill
Written by Jacques
6 years ago
8 posts since Mon, 01 Dec 08
Hello Bill,
Thanks for replying.

There is no host icon in the left pane.

Platform is Windows XP SP3 but I get the same result with my openSuse Linux laptop

java version "1.6.0_10"



Host is running LEAF linux

Linux tch 2.6.23.1-tch2.8.57.8 #1 Sun Nov 11 16:29:44 EST 2007 i686 unknown

mysqld Ver 3.23.49 for pc-linux-gnu on i686



SQL log says:

show databases where `database` in ('siteconfigDB')
select version()
show variables
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax near 'where `database` in ('siteconfigDB')' at line 1
show full processlist
show /*!50002 global*/ status



regards
Robert
Written by servertude
6 years ago
39 posts since Wed, 27 Feb 08
Are you running mysql 3?

mysqld Ver 3.23.49 for pc-linux-gnu on i686

Currently jHeidi only supports mysql >=5.0
We will be adding some backward compatible code when jHeidi hits the beta stage.
Written by Jacques
6 years ago
8 posts since Mon, 01 Dec 08
ohhh. Okay.
Thanks.
I wonder if its time we moved to a later version of MySQL.

Regards
Robert
Written by servertude
6 years ago
39 posts since Wed, 27 Feb 08
Im surmising that you put a database siteConfigDB in the "databases" field on the connection dialog. You could remove that and see if you get any further, but you will definitely run into other issues as I dont think jHeidi even works on mysql 4 but I havent done any testing of it in a while.
Written by Jacques
6 years ago
8 posts since Mon, 01 Dec 08
That was experimental to see if could get any further. There are in fact three databases but the user doesn't have access to the first one.
this is what happens if I leave it out:

show databases
select version()
show tables from `mysql`
show variables
show full processlist
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for user: 'crewpc@192.168.100.69' to database 'mysql'
show /*!50002 global*/ status



It's always worked fine with HeidiSQL, though.
Written by servertude
6 years ago
39 posts since Wed, 27 Feb 08
ok thats a bummer. I guess I can only refer you to HeidiSQL! jHeidi will eventually be more compatible, thanks for giving it a try.

- Bill
 

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