Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Access Violation error when pushing database changes to server from query results

ducpham posted 5 days ago in General

Hi,

I have run some SQL queries like this one:

SELECT t. FROM emails t WHERE t.person_id = (SELECT t2.person_ID FROM emails t2 WHERE t2.address = "aaa");

This shows all of the emails of the user who has the aaa address.

After this I make one change to a value in a field and hit the green check mark (Post) to push to the server. However HeidiSQL gives me an Access Violation error (log attached).

  • date/time : 2019-06-13, 18:46:54, 221ms
  • computer name : DESKTOP-GBI4LJH
  • user name : ducpham
  • registered owner : Windows User
  • operating system : Windows 10 x64 build 17763
  • system language : English
  • system up time : 6 hours 21 minutes
  • program up time : 1 minute 31 seconds
  • processors : 4x Intel(R) Core(TM) i5-7400 CPU @ 3.00GHz
  • physical memory : 1965/8083 MB (free/total)
  • free disk space : (C:) 87.58 GB
  • display mode : 1920x1080, 32 bit
  • process id : $3be4
  • allocated memory : 81.76 MB
  • largest free block : 1.10 GB
  • executable : heidisql.exe
  • exec. date/time : 2019-06-13 14:05
  • version : 10.1.0.5464
  • compiled with : Delphi 10.3 Rio
  • madExcept version : 5.0.0
  • callstack crc : $00000000, $37b74238, $37b74238
  • exception number : 10
  • exception class : EAccessViolation
  • exception message : Access violation at address 00000000 in module 'heidisql.exe'. Read of address 00000000.
  • main thread ($39b8):
  • 00000000 ???
  • 006c4d02 heidisql.exe Vcl.Forms TApplication.IsHintMsg
  • 006c4eff heidisql.exe Vcl.Forms TApplication.ProcessMessage
  • 006c4f86 heidisql.exe Vcl.Forms TApplication.HandleMessage
  • 006c52b9 heidisql.exe Vcl.Forms TApplication.Run
  • 773c0417 KERNEL32.DLL BaseThreadInitThunk

After this i restarted HeidiSQL. Interestingly, the change was pushed successfully to the server! However everytime I try to change a value this way I saw the Access Violation error again.

Is there anyway around it?

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