MySQL Bugs: #25837: Unable to edit data in any table

Bug #25837	Unable to edit data in any table
Submitted:	24 Jan 2007 18:02	Modified:	28 Mar 2007 7:11
Reporter:	Lukas Kutner	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.9 rc	OS:	Linux (Gentoo Linux, FC5, RHEL4, CentOS)
Assigned to:		CPU Architecture:	Any

Description:
On every table I work with, I'm unable to edit the table data. The 'Start editing' button is grey. Even if I create new table with primary key, it's not possible to edit it. I'm able to add or update the table through SQL queries

How to repeat:
Select some data from table and try to edit.

Thank you for the bug report. I was able to edit a simple with 2 columns:

mysql> show create table ican\G
*************************** 1. row ***************************
       Table: ican
Create Table: CREATE TABLE `ican` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` char(20) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

notice is necessary to have a primary or unique key. The only
strange behavior I noticed is when I click start edit a row
is added with null values which disappears when I click
apply changes. Could you please provide the dump of one table
which you can't edit?. Thanks in advance.

Than you for the reaction.

This is a dump of one of the tables (this one has been created for testing this case) :

CREATE TABLE `test` (
  `pk` int(11) NOT NULL default '0',
  `some_data` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

INSERT INTO `test` VALUES  (1,2);

I also tried to create the table you used, using the same CREATE statement and I attach screenshot of the result.

Screenshot

Attachment: screen.png (image/png, text), 37.86 KiB.

Start Editing enabled

Attachment: editing.PNG (image/png, text), 54.81 KiB.

I've attached a screenshot which shows the Start Editing button enabled
on Ubuntu 6.10. So maybe is something related to your environment: which
host machine 64-bit?, which MySQL server?, which GUI-tool package have
you installed?. Thanks in advance.

I'm running ordinary x86 (32bit) Gentoo system, the database server is running CentOs, MySQL version is 4.1.20.

I've installed mysql-gui-tools-5.0_p9 (it was working fine in 5.0_p6, I couldn't compile 5.0_p8).

If there's any more info I can provide, I'll be more than glad to do so.

And I've just tried the same on MySQL 5.0.32-log, which is running on my localhost, with the full privileges and the result is the same - Start editing is inactive

I managed to compile mysql-gui-tools-5.0_p8 and MySQL Query Browser included (version 1.2.8 beta) is working as expected.

Thank you for the feedback. The version 1.2.9 which presented that issue
is MySQL download package?, otherwise could you please try?. Thanks in
advance.

No, it was from gentoo portage.

I've downloaded the package directly from MySQL site and it is working properly.

I suppose I should fill a bug in gentoo bug tracking site then.

I am having this issue with the 5.0r9/1.2.9beta release as well..  I am using the upstream FC5 i386 RPMS from mysql.com on my FC6 x86_64 system.  All previous released have worked fine, but no matter what I put as my sql query it refuses to allow me to edit.  Even trying things mentioned in but #25862.

Thank you for the feedback. I am changing the status to can't repeat since
our package not presents that issue on your environment.

I think you misread my last comment.. the MySQL provided packages DO cause this issue on my FC6 system  And I also encounter this problem with the MySQL provided FC5 RPMS on my FC5 x86 system.

I have the same behaviour on RHEL4 with 5.0r9, downloaded the package directly from mysql.com

Johannes

Re-opening this bug report, as other Linux distributions may be affected, even when MySQL binaries are used.

I have the same problem on Windows with gui-tools-5.0-r9a from the mysql site.
My ISAM table does have a primary key, but I notice the Index indicator at the far left in the MySQL Table editor (In administrator) is a blue dot, not a key in r9a.  If I look at the Indices tab, it indicates a primary key, and if I try to add another, it won't let me (confirming the presence of a primary key, as expected).
If I reload 5.0-r3, the index is properly identified with a key symbol, and the edit works in query browser.
I'm running administrator 1.2.9 and query browser 1.2.9rc as loaded from the 5.0 r9a msi package.  My server is 5.0.21-standard on Solaris.

Thank you for the report.

I can repeat it with 1.2.9rc version and can not with current 1.2.10. Please try with MySQL Query Browser 1.2.10 and if you still can repeat provide output of SHOW CREATE TABLE for your tables you can not edit.

Confirming that this issue is resolved with the mysql provided 1.2.10/5.0r10 binary FC5 rpms.

Confirming this is resolved on Windows with 5.0-r10 from mysql.org.

Edward, John,

thank you for the comments.

Please provide output of SHOW CREATE TABLE for tables you can not edit.

Please ignore my last comment.

I'll close it as "Can't repeat" again.