can't edit rows or perform select statement on a table with a MEDIUMTEXT field in it

Hi there. Please refer back to a ticket of mine from years ago. https://www.heidisql.com/forum.php?t=41502 With the recent install of 12.15.0.7171, this problem started happening again. If I change my Preferences -> Grid rows from 1 to 2, Heidi doesn't freeze when I try to perform a SELECT statement on a table with a MEDIUMTEXT field in it. I prefer to work with 1 row, but for now, I have no choice but to work with 2.

Joyce

Yes, there were quite a few changes since back then, not in v12.15 but in the releases before. Hard to fix issue.

Ticket where others reported similar things after your mentioned forum post: issue #2000

I think I have to try a different strategy for long string content in grids. Perhaps display a few kb only in the grid but keep the whole content in the back.

Could you please once again in short describe what exactly is now the issue, and what you clicked or not?

This is the table structure: CREATE TABLE IF NOT EXISTS cronlist ( batchnum varchar(18) NOT NULL, batchflag enum('P','N','R','D','T') NOT NULL DEFAULT 'P', sendDateTime datetime NOT NULL DEFAULT '0000-00-00 00:00:00', datesent date NOT NULL, actualtimestarted datetime NOT NULL DEFAULT '0000-00-00 00:00:00', timestarted time NOT NULL, subject varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, message mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, attach1 varchar(100) NOT NULL, attach2 varchar(100) NOT NULL, timelastsent time NOT NULL, UNIQUE KEY batchnum (batchnum) USING BTREE, KEY batchflag (batchflag) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC COMMENT='list of email jobs';

If I run the query: SELECT * FROM cronlist WHERE batchnum = "2026-02-1913:22:50" and try to edit any field in the resulting row, I can not and sometimes (the worst times of course) HeidiSQL locks up. I can't do anything other than go to the Task Manager and close HeidiSQL. Same thing if I click on this table and click the Data tab. The only way that I can edit the data is if I build a SELECT statement with all columns except for the message column or change the Preferences to 2 grid rows.

You are correct that it may not have been this last update that "caused" the problem. I am not always working in a table with a MEDIUMBLOB trying to change or copy a piece of data. But there was definitely a point where I wasn't having this problem anymore.

I like your idea of displaying a few kb in the grid and keeping the whole content in the back. That is basically what the grid looks like to me anyway.

Thank you for your responsiveness. If you need some real data to work with, I am happy to send you 50 rows or so. Have a great weekend!

Joyce

Please update to the latest build (Help > Check for updates). My last modification disables the syntax highlighting in the text popup editor. I'm not yet sure that is what affects you, but for a similar table with values of > 100 k text this made a big difference.

If that is not yet helping out of this issue then please send some sample data, probably by mail.

Seems to be resolved with your update. I appreciate your time and effort.