Skip to content

Crash when trying to export data #2311

@CraftedRO

Description

@CraftedRO

Description

In this case it should properly export maybe only selected column or at least give some error instead direct crash.

HeidiSQL version

12.13.0.7157 (portable)

Database server version

MySQL Server 8.4.7 LTS

Reproduction recipe

I used following query on a database and then on resulted data I clicked right and then export as SQL update:

-- 
SELECT `AllowableRaces` FROM `quest_template` WHERE `ID`=2;

Error/Backtrace

date/time          : 2025-11-25, 20:34:40, 400ms
computer name      : DESKTOP-TEST
user name          : test
registered owner   : [email protected]
operating system   : Windows 11 x64 build 26100
system language    : English
system up time     : 9 days 3 hours
program up time    : 14 seconds
processors         : 8x Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz
physical memory    : 8586/16313 MB (free/total)
free disk space    : (C:) 359,74 GB (D:) 415,45 GB
display mode       : 1920x1080, 32 bit
process id         : $362c
allocated memory   : 95,76 MB
largest free block : 131023,62 GB
executable         : heidisql.exe
exec. date/time    : 2025-11-17 23:48
version            : 12.13.0.7157
compiled with      : Delphi 12
madExcept version  : 5.1.5
callstack crc      : $8f7da88e, $597babb6, $597babb6
exception number   : 1
exception class    : EConvertError
exception message  : Format 'Nu se poate compune clauza WHER' invalid or incompatible with argument.

main thread ($374c):
00a4c8ca heidisql.exe System.SysUtils            FormatError
00a4d7a5 heidisql.exe System.SysUtils            WideFormatBuf
00a4c932 heidisql.exe System.SysUtils            FormatBuf
00a4cb89 heidisql.exe System.SysUtils            FmtStr
00a4cab5 heidisql.exe System.SysUtils            Format
00a4ca87 heidisql.exe System.SysUtils            Format
00a57f86 heidisql.exe System.SysUtils            Exception.CreateFmt
012bae57 heidisql.exe dbconnection    10296   +8 TDBQuery.GetWhereClause
01760be0 heidisql.exe exportgrid       1146 +481 TfrmExportGrid.btnOKClick
00c9f396 heidisql.exe Vcl.Controls               TControl.Click
00cde356 heidisql.exe Vcl.StdCtrls               TCustomButton.Click
00cdfc72 heidisql.exe Vcl.StdCtrls               TCustomButton.CNCommand
009df6f1 heidisql.exe System                     TObject.Dispatch
00c9eca7 heidisql.exe Vcl.Controls               TControl.WndProc
00ca69bb heidisql.exe Vcl.Controls               TWinControl.WndProc
00cddced heidisql.exe Vcl.StdCtrls               TButtonControl.WndProc
00c9e7af heidisql.exe Vcl.Controls               TControl.Perform
00ca6be9 heidisql.exe Vcl.Controls               DoControlMsg
00ca7db3 heidisql.exe Vcl.Controls               TWinControl.WMCommand
00e41753 heidisql.exe Vcl.Forms                  TCustomForm.WMCommand
009df6f1 heidisql.exe System                     TObject.Dispatch
00c9eca7 heidisql.exe Vcl.Controls               TControl.WndProc
00ca69bb heidisql.exe Vcl.Controls               TWinControl.WndProc
00e3bd1b heidisql.exe Vcl.Forms                  TCustomForm.WndProc
00fb683e heidisql.exe SizeGrip          256  +36 TSizeGrip.NewWndProc
00ca5a8a heidisql.exe Vcl.Controls               TWinControl.MainWndProc
00bb2793 heidisql.exe System.Classes             StdWndProc
7ffeaf58 USER32.dll                              SendMessageW
7ffeaf58 USER32.dll                              CallWindowProcW
00ca6b87 heidisql.exe Vcl.Controls               TWinControl.DefaultHandler
00c9fa4c heidisql.exe Vcl.Controls               TControl.WMLButtonUp
009df6f1 heidisql.exe System                     TObject.Dispatch
00c9eca7 heidisql.exe Vcl.Controls               TControl.WndProc
00ca69bb heidisql.exe Vcl.Controls               TWinControl.WndProc
00cddced heidisql.exe Vcl.StdCtrls               TButtonControl.WndProc
00ca5a8a heidisql.exe Vcl.Controls               TWinControl.MainWndProc
00bb2793 heidisql.exe System.Classes             StdWndProc
7ffeaf58 USER32.dll                              DispatchMessageW
00e4c1f0 heidisql.exe Vcl.Forms                  TApplication.ProcessMessage
00e4c263 heidisql.exe Vcl.Forms                  TApplication.HandleMessage
00e44c6b heidisql.exe Vcl.Forms                  TCustomForm.ShowModal
017d58e6 heidisql.exe Main             3646   +4 TMainForm.actExportDataExecute
00bb1231 heidisql.exe System.Classes             TBasicAction.Execute
00c680c5 heidisql.exe Vcl.ActnList               TCustomAction.Execute
00bb0e0a heidisql.exe System.Classes             TBasicActionLink.Execute
00e1837a heidisql.exe Vcl.Menus                  TMenuItem.Click
00e1ac3e heidisql.exe Vcl.Menus                  TMenu.DispatchCommand
00e1cf34 heidisql.exe Vcl.Menus                  TPopupList.WndProc
00e1ce35 heidisql.exe Vcl.Menus                  TPopupList.MainWndProc
00bb2793 heidisql.exe System.Classes             StdWndProc
7ffeaf58 USER32.dll                              DispatchMessageW
00e4c1f0 heidisql.exe Vcl.Forms                  TApplication.ProcessMessage
00e4c263 heidisql.exe Vcl.Forms                  TApplication.HandleMessage
00e4c6ba heidisql.exe Vcl.Forms                  TApplication.Run
01828e49 heidisql.exe heidisql          118  +44 initialization
7ffeaf13 KERNEL32.DLL                            BaseThreadInitThunk
7ffeaff8 ntdll.dll                               RtlUserThreadStart

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project member

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions