Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench - Cannot add columns to a table

I have a critical problem with MySQL Workbench: I actually cannot edit the "Columns" tab, because it is greyed out.

I tried to edit a table's columns both for a newly created diagram and for an existing diagram, but with no luck. Is there a bug in the last versions of WB, or am I missing something else?

I found this problem both with the WB version installed via the OS package management (apt) and with the version installed from source.

OS: debian jessie/sid

WB version (installed via APT): 6.1.7 build 1788 (6.1.7+dfsg-1)

WB version (installed from source): 6.2.3 build 2280

P.S. I have already readed a couple of similar questions (see here and here), but they don't fit with my problem.

Columns not editable

like image 279
ramo102 Avatar asked Oct 02 '14 16:10

ramo102


1 Answers

If you want it to work before Debian updates it, I suggest you to download the mysql-workbench source, apply this patch, build the package and then install it.

EDIT:

Instructions

As normal user, open a terminal and do the following:

cd ~
mkdir mysql-workbench-source
cd mysql-workbench-source
su root (type root password)
apt-get install build-essential
apt-get install pbuilder
apt-get source mysql-workbench
apt-get build-dep mysql-workbench
cd mysql-workbench-6.1.7+dfsg/frontend/linux/linux_utilities
cp ~/Downloads/glib.diff . (don't forget the last dot).
patch <glib.diff
cd ~/mysql-workbench-6.1.7+dfsg
debuild -us -uc -b (this will take a while)
cd ..
dpkg -i mysql-workbench_6.1.7+dfsg-1_amd64.deb
dpkg -i mysql-workbench-data_6.1.7+dfsg-1_all.deb

It should be fixed now.

like image 88
Felipe Avatar answered Oct 14 '22 04:10

Felipe