Import CSV file error

[expired user #8249]'s profile image [expired user #8249] posted 10 years ago in Import/Export Permalink
Selecting Tools->Import CSV file..., throws the following errors.

date/time : 2014-08-22, 09:17:48, 39ms
computer name : USER-PC
user name : User <admin>
registered owner : User
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 5 days 21 hours
program up time : 20 seconds
processors : 4x Intel(R) Core(TM) i3 CPU M 370 @ 2.40GHz
physical memory : 1044/3767 MB (free/total)
free disk space : (C:) 282.06 GB
display mode : 1366x768, 32 bit
process id : $2ddc
allocated memory : 43.37 MB
largest free block : 8181.54 GB
executable : heidisql.exe
exec. date/time : 2014-08-22 09:17
version : 8.3.0.4805
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $4d5fa563, $e6cf0dd8, $e6cf0dd8
exception number : 1
exception class : EAccessViolation
exception message : Access violation at address 0000000000A84FEB in module 'heidisql.exe'. Read of address 0000000000000000.

main thread ($34f0):
00a84feb heidisql.exe dbconnection 5057 +1 TDBQuery.First
00b52e7d heidisql.exe loaddata 189 +27 Tloaddataform.grpParseMethodClick
00b534c7 heidisql.exe loaddata 231 +16 Tloaddataform.comboDatabaseChange
00b52ab5 heidisql.exe loaddata 144 +8 Tloaddataform.FormShow
00803930 heidisql.exe Vcl.Forms TCustomForm.DoShow
0080a2dc heidisql.exe Vcl.Forms TCustomForm.CMShowingChanged
0040cb1e heidisql.exe System TObject.Dispatch
00693453 heidisql.exe Vcl.Controls TControl.WndProc
0069ab1e heidisql.exe Vcl.Controls TWinControl.WndProc
008047eb heidisql.exe Vcl.Forms TCustomForm.WndProc
00692f30 heidisql.exe Vcl.Controls TControl.Perform
00699a42 heidisql.exe Vcl.Controls TWinControl.UpdateShowing
00699b80 heidisql.exe Vcl.Controls TWinControl.UpdateControlState
0069e060 heidisql.exe Vcl.Controls TWinControl.CMVisibleChanged
0040cb1e heidisql.exe System TObject.Dispatch
00693453 heidisql.exe Vcl.Controls TControl.WndProc
0069ab1e heidisql.exe Vcl.Controls TWinControl.WndProc
008047eb heidisql.exe Vcl.Forms TCustomForm.WndProc
00692f30 heidisql.exe Vcl.Controls TControl.Perform
00690c61 heidisql.exe Vcl.Controls TControl.SetVisible
00803d02 heidisql.exe Vcl.Forms TCustomForm.SetVisible
0080b5bd heidisql.exe Vcl.Forms TCustomForm.Show
0080b8ea heidisql.exe Vcl.Forms TCustomForm.ShowModal
00bfbcde heidisql.exe Main 2035 +3 TMainForm.actImportCSVExecute
005d90e0 heidisql.exe System.Classes TBasicAction.Execute
00664463 heidisql.exe Vcl.ActnList TCustomAction.Execute
005d8e14 heidisql.exe System.Classes TBasicActionLink.Execute
007e9f5c heidisql.exe Vcl.Menus TMenuItem.Click
007ec88f heidisql.exe Vcl.Menus TMenu.DispatchCommand
007eede4 heidisql.exe Vcl.Menus TPopupList.WndProc
007eece5 heidisql.exe Vcl.Menus TPopupList.MainWndProc
005da693 heidisql.exe System.Classes StdWndProc
770798d5 USER32.dll DispatchMessageW
00812f6f heidisql.exe Vcl.Forms TApplication.ProcessMessage
00812fe3 heidisql.exe Vcl.Forms TApplication.HandleMessage
008134cf heidisql.exe Vcl.Forms TApplication.Run
00c50a87 heidisql.exe heidisql 77 +24 initialization
76f559eb kernel32.dll BaseThreadInitThunk



[expired user #8249]'s profile image [expired user #8249] posted 10 years ago Permalink
Apologies. I am using connection to PostgreSQL Ver 9.3.5 with PostGIS extension.
ansgar's profile image ansgar posted 10 years ago Permalink
Yes, I am getting the same error, which is due to a MySQL specific query fired in the background when calling the import dialog:
SHOW CREATE DATABASE "schest";

Will see what I can do about that.
ansgar's profile image ansgar posted 10 years ago Permalink
The SHOW CREATE DATABASE is only the first out of two errors happening here. The one causing the crash is a non existing method for getting all supported character sets in PostgreSQL. Like SHOW CHARSET in MySQL, is there a way to do that in PostgreSQL? I cannot find some working solution here. There is just a hardcoded list in their documentation, but Heidi needs to do that in a query.
[expired user #8249]'s profile image [expired user #8249] posted 10 years ago Permalink
I am getting out of my depth here but this seems to imply that SHOW is an extension. Maybe irrelevant to issue
http://www.postgresql.org/docs/9.2/static/sql-show.html
ansgar's profile image ansgar posted 10 years ago Permalink
I have opened a ticket at 2ndquadrant.com. Probably they know some equivalent to MySQL's SHOW CHARSET.
Code modification/commit from ansgar.becker, 10 years ago, revision 4808
Introduce TPgConnection.GetCharsetTable, forgotten to implement yet. Fixes a crash in text import dialog.
* User report: http://www.heidisql.com/forum.php?t=16181
* Ticket at 2ndquadrant: https://support.2ndquadrant.com/rt/SelfService/Display.html?id=37948
ansgar's profile image ansgar posted 10 years ago Permalink
r4808 should fix that. The excellent support from 2ndquadrant.com replied immediately (on a sunday evening!). HeidiSQL uses such a query now to retrieve charsets in PostgreSQL:
SELECT PG_ENCODING_TO_CHAR("encid") AS "Charset", '' AS "Description" FROM (SELECT "conforencoding" AS "encid" FROM "pg_conversion", "pg_database" WHERE "contoencoding"="encoding" AND "datname"=CURRENT_DATABASE()) AS "e";
[expired user #8249]'s profile image [expired user #8249] posted 10 years ago Permalink
Well done ansgar and 2ndquadrant.com.

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