mysql-workbench SQL Editor does not show any schemas

This is just a "For the Record" for triagers:
I've attempted to reproduce this in the latest upstream release, 5.2.45, from Oracle/mySQL itself (albeit on Ubuntu 12.04). I was *unable* to reproduce this bug using latest upstream, so this does not need to be forwarded to upstream (Oracle) unless someone else is able to reproduce it with the latest upstream release.

Yes, 5.2.45 works for me in Raring (using the Precise deb).

For the record, I had to manually download the library libctemplate0 that the Precise deb requires from http://packages.ubuntu.com/precise/libs/libctemplate0 because it isn't in Raring's repositories (Raring has libctemplate2).

I had this same issue after updating from 12.10. Downloading the lastest release of Workbench (5.2.45) solved the problem for me.

Marking as confirmed due to multiple users reporting this issue.

I'm tempted to ask to have 5.2.45 synced from Debian Experimental, now that I've figured out how to prevent it from failing to build from source.

HOWEVER: the following is one problem and I'm looking into finding a solution for this:
One of the dependencies of the version in Debian Experimental is an updated version of the packages built from the source package mysql-connector-c++. LibreOffice, or something in it, depends on that package for runtime, and we can't sync one dependency for mysql-workbench if it'll break LibreOffice.

I'm going to leave this at the "Confirmed" status, but i'm definitely working to see if I can't get 5.2.45 synced into Raring (assuming of course libre office won't break with the updated mysql c++ connector).

Hmm. Maybe 5.2.45 isn't the best one to sync. It can open my schemas, and view/edit the stored routines, but it doesn't show any information from tables (I get blank output for 'SELECT * FROM schema.tablename' statements.) Does anyone else experience that issue with 5.2.45?

FYI, mysql-workbench 5.2.46 is now out (but it also doesn't return any results when I try to select records from tables).

Rocko, you may want to read this page: http://packages.qa.debian.org/m/mysql-workbench.html

5.2.46 isn't even in Debian yet (see "Exp") and even if it was, are you reporting a bug different from the bug here?

Actually, better idea, can you attach a screenshot showing what you're trying to do and what is being output, as well as providing a test-case so I can test this with upstream?

Here's a screenshot of the issue, and yes, it's different from this bug (I could file another bug, but I wanted to confirm others get the problem as well). You can see from the terminal window that there is a record in table1, but the 'select * from table1;' command in mysql-workbench shows no records, and the action output window doesn't show anything either.

It's easy to recreate. I reproduced it using a 32-bit version of Raring running in VirtualBox.

1. Install mysql-server. I set no password for the root user.

2. Run "mysql -uroot" to get into mysql, and create a schema and with a table with a record in it:

create schema test1;
use test1;
create table1 (id integer, name text);
insert into table1 values (1, 'test');

3. Download the libctemplate0 deb file via the link at http://packages.ubuntu.com/precise/libs/libctemplate0 and install with 'sudo dpkg -i', then download mysql-workbench.deb file and install it.

4. Open mysql-workbench and create a new connection with default schema test1 for localhost.

5. Open the connection and create the query "select * from table1;" and execute it. The action window and results window appear but both are empty.

mysql-workbench 5.2.47 has the same problem as 5.2.46. It can see schemas and routines, but can't get data out of tables. And it crashes when you close it.

It's almost a month now, and the buggy workbench package is still there.

I can confirm that adding the libctemplate0.deb and then installing the 12.10 version of Workbench (from MySQL.com) works BUT it hangs after about ~20 minutes for me.

It's better then nothing. I'm running an up-to-date 13.04

Edit:
The comment from Rocko on 2013-03-20 is also valid. I can see schemas and routines but when I run "SELECT * FROM exampletable" it returns nothing.

i have this problem also with the latest kernel 3.8.0-15
i can see schemas, tables, views but no result displayed on select.

same here on ati radeon HD 5000 graphics card in case its a display issue, had this issue for a while keep checking but still there quite important bug to see fixed for anyone that does web development on ubuntu :)

Same problems here on Raring 64-bit. mysql-workbench-gpl-5.2.47-1ubu1204 (Oracle package; with libctemplate0 from Precise) does not show query results, nor does it populate any tab in the bottom panel (Action Output, Text Output, History). mysql-workbench-5.2.40+dfsg-2 (Ubuntu package) is the same, with the addition of not displaying schema info in the left sidebar.

Ok, I've reported the lack of query results in Mysql-Workbench/SqlEditor upstream at http://bugs.mysql.com/bug.php?id=68877.

Raring reached EOL in January 27, 2014. Is this still a problem on any of the currently supported Ubuntu releases?

Works fine for me in trusty and nobody spoke up to report problems in the latest releases. Closing.