jheidi - no database tree in left pane

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

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

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

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.

ohhh. Okay.
Thanks.
I wonder if its time we moved to a later version of MySQL.

Regards
Robert

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.

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.

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