Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Problems after updating

azielnik's profile image azielnik posted 4 months ago in General Permalink

I updated revision 6350 to 6394 and see some new problems.

When in table is BLOB, clicking it gives editor, but now it is very small, and there's a need of more clicking, previously it was better

When in table are records without BLOB, so there's no editor now. It's unconfortable when the content is long. But now it's better simple editing and faster. But editor is needed.

How can I recover the proevious version of HeidiSQL without this problems. Could you send me old version?

Artur

azielnik's profile image azielnik posted 4 months ago Permalink

maybe the reason of the lack of editor is the table was made byc Create TABLE ... As Select ..., made type fields as UNKNOWN

Could it be done to change the type in the name how now we can change name of table?

ansgar's profile image ansgar posted 4 months ago Permalink

Please post the whole CREATE TABLE statement here.

azielnik's profile image azielnik posted 4 months ago Permalink

CREATE TABLE DOMEK (NAZWA TEXT, PLIK BLOB)

but the definitions its not the matched with the problem of small editor window. When I make it larger manually it works as far as I reopen heidisql. This is a little terrible, as after each click on the blob, you have to enlarge the window, and go home. So there are not needed clicking.

This is the case of options.

New problem I encounter, I added a file, and want to past some characters at the very beginning, so I can't save it. TOO BIG LITERAL, but it was only 10000 characters.

As far as, the problem that records are not opened in editor, it was matched only to the fields marked UNKNOWN after I create table from select. When fields have the data tape, the editor open, but also so small window.

3 attachment(s):
  • heidi01
  • heidi02
  • heidi03
ansgar's profile image ansgar posted 4 months ago Permalink

Binary value editing is indeed buggy in HeidiSQL.

But the text editor should be resizable using the lower right corner of the dialog, isn't it?

Description

azielnik's profile image azielnik posted 4 months ago Permalink

Generally it works in another way like before update. It's less comfortable now. Yes, I spread this dialog window in that way, but it's neede everytime when it's reopen. No memory of settings. It's like you get into your car and everytime to set the mirrors or seat.

I don't know, it should be resizable in that way. More natural is maximisation and minimalisation icon, and the memory of setting, or setting in options. The previouse one was more comfortable.

How I can recover the previouse version of Heidisql? Is there any repository of versions?

But what this error? I used not binary BLOB. That was only text file, so strange

ansgar's profile image ansgar posted 4 months ago Permalink

The window dimensions should definitely be stored and restored. I am just testing that again, and it still works with the same build as you use (6394). Please verify the window is not maximized, and then set the wanted width and height.

azielnik's profile image azielnik posted 4 months ago Permalink

I do it again tomorrow, but I did it yesterday in that way. I spread it with right bottom corner, and when I started work today, I gave you the above screens.

Anyway, new problem, when I delete table, and the data was edited on DATA BOOKMARK, they don't disappear after deletion. I don't know how it worked previously.

But the very fine solution is renaming the name of table in TABLE bookmark. It would be good to change the name of fields and data types in that way :).

Let you know tomorrow

azielnik's profile image azielnik posted 4 months ago Permalink

When I run select and saw uneeded records, I tried to delete them by red button. Then GRID ERROR appear. When I thought thats only the problem of display, I check the select again, and only some part of records was deleted. So I wanted to delete the rest, and keep the last record in base. So I select some records to be deleted. Once again GRID ERROR

... but also unselected record disappeared (this one I wanted to keep). It's something wrong with it.

This problem of GRID ERROR was in previouse versions too, but I thought it delete the records I wanted. Unfortunatelly I didn't check it but only believe it. Now, I am not sure, all was reliable and match my will :(

3 attachment(s):
  • heidi05
  • heidi06
  • heidi07
azielnik's profile image azielnik posted 4 months ago Permalink

at this moment i deleted only by one record, and it works I did it twice. When I check to delete two records, there was grid error but when select once again only 3 las records left.

I don't know how it works and whats the rules.

Of course when I used DELETE, it was OK, by manualy gave these problems

ansgar's profile image ansgar posted 4 months ago Permalink

You write much about various issues here. Please stay in one topic, otherwise noone can help you.

azielnik's profile image azielnik posted 4 months ago Permalink

So comming back to the problem of minimazied editor window.

When you resize it with right bottom corner, later it starts work with the same size. But if you during your job maximize the editor as normal windows window to be full screen, then when you use editor it starts as minimized, so once again you have to resize it manually

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.