MySQL Bugs: #62686: Alter Table not Working in MySQL Workbench

Bug #62686	Alter Table not Working in MySQL Workbench
Submitted:	11 Oct 2011 20:46	Modified:	3 Feb 2012 1:40
Reporter:	Thomas Cushing	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.34, 5.2.35	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	ALTER TABLE, bug

Description:
When I right-click on a table in MySQL Workbench and select "Alter Table", nothing happens.  No window appears.  Absolutely nothing happens.

To compound issues, if I right-click on a table and click "Send to SQL Editor" and then select "Create Table", nothing happens either.

How to repeat:
Right-click on a table in MySQL Workbench and select "Alter Table"

Could you please try version 5.2.35. Thanks.

I installed version 5.2.35 CE but I still have the same problem.  Right-clicking on a table an selecting "Alter Table" has no effect.  Also if I right-click on a table and select "Send to SQL Editor" and "Create Table", nothing happens as well.

It seems like it might be a permissions issue, but I have Global Alter permissions on that server.  Any other ideas?

I'm having the same problem.

My server is Ubuntu 10.10, running MySQL 5.1.49-1ubuntu8.1. 

If I try to alter table from a Mac client, it says "Failed to create/alter 'Database'.'Table' Can't connect to MySQL server on 'IP addr' (61).

I'm getting a very similar problem with a Ubuntu 11.10 client.  When I right click to alter a table the window does appear, but the window is transparent and I can only see the frame of the window.

My issue is specific to MySQL Workbench.  It appears to be permissions based, since it only affects me when I connect to a specific server.  It's strange because I have Alter Table permissions and can alter a table using DDL.  But when I right-click and select Alter Table, the GUI will not appear.  It does appear when I do it on against another server.

So I can't really tell which permission is causing the problem.  I wonder if I need DBA rights to use the GUI.

If you click Send to Editor -> Create Script for the table, does it work?

No, unfortunately that doesn't work either which compounds the problem.

Now we're getting somewhere. What about executing show create table <table> ?

That works.  Any commands I run seem to work.  I just can't get the Alter table GUI to come up, or the right-click "Send to SQL Editor > Create Statement" to work.

Can you attach the log file at ~/.mysql/workbench/logs  after repeating the problem?
Also, can you paste the definition of the table? Does the problem appear with any table at all?

These are the queries done by Send Create Table:

111108 12:37:07	  132 Query	SELECT 'trigger' AS 'OBJECT_TYPE', TRIGGER_CATALOG as 'CATALOG', TRIGGER_SCHEMA as 'SCHEMA', TRIGGER_NAME as 'NAME' FROM information_schema.triggers WHERE trigger_schema = 'sakila'  AND 'customer'=EVENT_OBJECT_TABLE
		  132 Query	SELECT 'trigger' AS 'OBJECT_TYPE', TRIGGER_CATALOG as 'CATALOG', TRIGGER_SCHEMA as 'SCHEMA', TRIGGER_NAME as 'NAME', EVENT_MANIPULATION, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_ORDER, 	ACTION_CONDITION, ACTION_STATEMENT, ACTION_ORIENTATION, ACTION_TIMING, DEFINER	FROM information_schema.triggers  WHERE trigger_schema = 'sakila'  AND 'customer'=EVENT_OBJECT_TABLE
		  132 Query	SELECT 'table' AS 'OBJECT_TYPE', TABLE_CATALOG as 'CATALOG', TABLE_SCHEMA as 'SCHEMA', TABLE_NAME as 'NAME' FROM information_schema.tables WHERE table_type<>'VIEW' AND table_schema = 'sakila'  AND 'customer'=TABLE_NAME
		  132 Query	SHOW CREATE TABLE `sakila`.`customer`

Can you execute them to see if any is failing?

The issues occur with all tables.

When I run the first two statements for the triggers, I get the following error:

Error Code: 1102. Incorrect database name '#mysql50#mysqq.bak'

Not sure where that's coming from.  They are querying from the information_schema.triggers database.  

The other statements run successfully.

What version of MySQL server?

Workbench: 5.2.35 CE
MySQL: 5.1.53-community

Sounds like you have corrupted system tables.

That makes sense.  Thanks for your help.  I guess we'll have to take a shot at repairing the system tables.

Please, inform about any further results related to this report.

Have same problem with 5.2.36 on ubuntu 10.04 32-bits.

Not response for "Alter Table..." option from context menu. But can see columns from column node of tree view.

Tried with MySQL server 5.0 and 5.5. Both failed to open table editor. 

Here is what I got from Terminal screen after I clicked "Alter Table...":
------
(mysql-workbench-bin:1697): glibmm-CRITICAL **: 
unhandled exception (type Glib::Error) in signal handler:
domain: gtk-builder-error-quark
code  : 6
what  : Unknown internal child: selection
------

Here is list of *.so files on the machine related to GTK:
------
$ ls /usr/lib/libgtk*
libgtk2.0-0/                   libgtkmm-2.4.so.1.1.0
libgtkglext-x11-1.0.so.0       libgtksourceview-2.0.so.0
libgtkglext-x11-1.0.so.0.0.0   libgtksourceview-2.0.so.0.0.0
libgtkhtml-2.so.0              libgtkspell.so.0
libgtkhtml-2.so.0.0.0          libgtkspell.so.0.0.0
libgtkhtml-3.14.so.19          libgtk-vnc-1.0.so.0
libgtkhtml-3.14.so.19.1.1      libgtk-vnc-1.0.so.0.0.1
libgtkhtml-editor.so.0         libgtk-x11-2.0.so.0
libgtkhtml-editor.so.0.0.0     libgtk-x11-2.0.so.0.2000.1
libgtkmm-2.4.so.1              
------

The wb.log is attached.

Thanks  a lot for your report Thomas.

Verified as reported.
Ubuntu 10.04x32
WB 5.2.36 rev 8542

Terminal output:
(mysql-workbench-bin:1694): glibmm-CRITICAL **: 
unhandled exception (type Glib::Error) in signal handler:
domain: gtk-builder-error-quark
code  : 6
what  : Unknown internal child: selection

I have the same issue with MySQL Workbench 5.2.36, CentOS 5.0:

(mysql-workbench-bin:3824): glibmm-CRITICAL **: 
unhandled exception (type Glib::Error) in signal handler:
domain: gtk-builder-error-quark
code  : 6
what  : Unknown internal child: selection

I think this issue might be raised to S2, although there are workarounds, it's really preventing from using the software.

Can't alter table. Ubuntu 10.04, 64bit.

(mysql-workbench-bin:4080): glibmm-CRITICAL **: 
unhandled exception (type Glib::Error) in signal handler:
domain: gtk-builder-error-quark
code  : 6
what  : Unknown internal child: selection

Such buggy software, bugs wherever you point finger :(.

I confirm this on MySQL Worbench 5.2.37 on Ubuntu 10.04 64bit (MySQL version is 5.1.41, standard package from Ubuntu's repository):

(mysql-workbench-bin:3300): glibmm-CRITICAL **: 
unhandled exception (type Glib::Error) in signal handler:
domain: gtk-builder-error-quark
code  : 6
what  : Unknown internal child: selection

I can't use (at least) "alter table" and "create table" wizards.

Everithing works fine with 5.2.35

I'm having the same problem here...is there a solution for this problem?

The alter table windows is a "essential" part of the application, this bug should be raised to critical cause of that.

This bug degenerated into 2 different bugs, original one was probably a problem with table corruption in user's table. The second a specific problem with Ubuntu 10.04.
To workaround the Ubuntu 10.04 problem, you can edit
/usr/share/mysql-workbench/modules/data/editor_mysql_table_live.glade 
with a text editor and delete all XML nodes like

                <child internal-child="selection">
                  <object class="GtkTreeSelection" id="treeview-selection5"/>
                </child>

Thanks Alfredo, the workaround works great :)

Fixed as of 5.2.38:

On Linux, right-clicking on a table and choosing the
"Alter Table" feature would perform no
function.

Also added the workaround.