jheidi - no database tree in left pane

[expired user #3779]'s profile image [expired user #3779] posted 16 years ago in jHeidi (discontinued) Permalink
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
[expired user #3375]'s profile image [expired user #3375] posted 16 years ago Permalink
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
[expired user #3779]'s profile image [expired user #3779] posted 16 years ago Permalink
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
[expired user #3375]'s profile image [expired user #3375] posted 16 years ago Permalink
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.
[expired user #3779]'s profile image [expired user #3779] posted 16 years ago Permalink
ohhh. Okay.
Thanks.
I wonder if its time we moved to a later version of MySQL.

Regards
Robert
[expired user #3375]'s profile image [expired user #3375] posted 16 years ago Permalink
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.
[expired user #3779]'s profile image [expired user #3779] posted 16 years ago Permalink
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.
[expired user #3375]'s profile image [expired user #3375] posted 16 years ago Permalink
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.