unrecoverable error when accidentally adding string to int field

[expired user #9506]'s profile image [expired user #9506] posted 8 years ago in General Permalink

I have a table with an INT field. I tried to add a row but inserted a string into the INT field by accident. I get an error message and it keeps reappearing no matter what I do. I click ok, then try to change tables, change the INT to varchar, etc. I have to shut down heidisql and restart the program to get it to stop reappearing. I know I shouldn't be adding a string to an INT field but it should allow the user to recover from a mistake like this. Here is the text of the error message box that repeatedly comes up: SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '4 iPhone case.png, 700, 700)' at line 1.

Attached is the bug report which is visible after the alert box.

PS. thanks for creating heidisql. it's a great program and i've been using it for about 5 years.

1 attachment(s):
[expired user #9506]'s profile image [expired user #9506] posted 8 years ago Permalink

I actually got it to disappear. The only thing that allowed me to go anywhere was to delete the row.

I wouldn't say this is a bug... it's more of a usability issue.

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