Bug #67238 Crash when pasting text in Edit Data window and applying the change
Submitted: 15 Oct 2012 17:17 Modified: 29 Oct 2012 15:40
Reporter: James Fetzner Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.41 OS:Windows (Microsoft Windows 7 Ultimate Edition Service Pack 1 (build 7601), 64-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[15 Oct 2012 17:17] James Fetzner 
Description:
Was editing a field in db using Edit in window feature.  Cut and pasted some text from Word (it had multiple line carrage returns), and hit Apply button.  Then Workbench threw an error.

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.41  revision 9727
Configuration Directory: C:\Users\Jim\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7 Ultimate Edition Service Pack 1 (build 7601), 64-bit
CPU: 4x Intel(R) Core(TM)2 Quad  CPU   Q9100  @ 2.26GHz, 16.0 GiB RAM
Active video adapter (0): NVIDIA Quadro FX 3700M
Installed video RAM: 1024 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 9.18.13.623
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: English (United States)

Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.
   at MySQL.Forms.ButtonImpl.button_click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
Cut and paste text into editor and apply edite.
[15 Oct 2012 17:35] MySQL Verification Team 
Please try version 5.2.44. Thanks.
[15 Oct 2012 20:01] James Fetzner 
I have tried this now using v5.2.44 and same crash occurs.

Basically, I have a longtext field in the table which is encoded utf-8. I sometimes have a problem where the values in the field are not encoded properly (e.g., â€oe instead of "), so I'm trying to update the field so it display correctly on the webpage.  Some of the text can be long, so if I right click on the cell and select "Open Value in Editor" it opens in a bigger window so I can more easily do an edit.

If I open the field and then just click Apply (no edits done), it crashes.  If I edite the â€oe's to " and Apply, it crashes.  So I do not seem to be able to edit these records.  The workbench app does not tell me what error has occurred, just that it crashed and to submit a bug report.  So I'm not sure what is actually causing the problem.

For example, here is the first line of text from one record:
Line 27: Common name of “red swamp crayfish” should be changed to “red swamp crawfish” to conform with accepted common names, revise throughout text

When trying to save it as:
Line 27: Common name of "red swamp crayfish" should be changed to "red swamp crawfish" to conform with accepted common names, revise throughout text

it crashes.

I tried doing this in the cell of the table (not the editor window), and got this error:
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 '27: Common name of “red swamp crayfish” should be changed to “' at line 1

SQL Statement:

UPDATE `iaamanuscripttracking`.`reviews` SET `CommentsForAuthor`=Line 27: Common name of “red swamp crayfish” should be changed to “red swamp crawfish” to conform with accepted common names, revise throughout text WHERE `RID`='302'

Is it a problem that the text string does not have quotes around it?  Shouldn't these automatically be added when applying changes?  Interestingly, if I add single quotes at both ends of the text string in the cell, the save operation completes successfully.

Any ideas?

Thanks!
[29 Oct 2012 14:10] Ruben Dario Morquecho Valdez 
Could you please share table details  in order to reproduce it?

Thanks.
[29 Oct 2012 15:40] Ruben Dario Morquecho Valdez 
Could you please share table details  in order to reproduce it?

Thanks.