Application: KiCad x64 on x64
Version: 7.0.7, release build
Libraries:
wxWidgets 3.2.2
FreeType 2.12.1
HarfBuzz 6.0.0
FontConfig 2.14.1
libcurl/7.88.1-DEV Schannel zlib/1.2.13
Platform: Windows 10 (build 19045), 64-bit edition, 64 bit, Little endian, wxMSW
Build Info:
Date: Aug 14 2023 02:42:39
wxWidgets: 3.2.2 (wchar_t,wx containers)
Boost: 1.81.0
OCC: 7.7.1
Curl: 7.88.1-DEV
ngspice: 40
Compiler: Visual C++ 1936 without C++ ABI
Build settings:
KICAD_SPICE=ON
When opening symbol editor I get an error:
11:52:07 AM: Unhandled exception class: class nanodbc::index_range_error what: index out of range
11:52:07 AM: Error loading editor.
11:52:07 AM: Application failed to load.
The cause of the crash is a piece of my .kicad_dbl file. We use an externel SQL database. This has been working fine but now I added an extra table to the database and added the link to the dbl file. The link looks as follows:
{
"name": "Crystals",
"table": "Crystals",
"key": "Artikelomschrijving",
"symbols": "Schematic symbol",
"footprints": "Footprint",
"fields":
[
{ "column": "Artikelnummer", "name": "Artikelnummer", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Artikelomschrijving", "name": "Artikelomschrijving", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Part type", "name": "Part type", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Value", "name": "Value", "visible_on_add": true, "visible_in_chooser": true, "show_name": false },
{ "column": "Tolerance", "name": "Tolerance", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Rating", "name": "Rating", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Temperature", "name": "Temperature", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Mfr", "name": "Mfr", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Mfr code", "name": "Mfr code", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Datasheet", "name": "Datasheet", "visible_on_add": false, "visible_in_chooser": true, "show_name": false },
{ "column": "Date added", "name": "Date added", "visible_on_add": false, "visible_in_chooser": true, "show_name": false }
],
"properties":
{
"description": "Beschrijving", "exclude_from_bom": "No BOM", "exclude_from_board": "No PCB"
}
},
So now i wonder, what causes these crashes? when I remove this text from the dbl, kicad runs fine. This behavior also causes me to not be able to add parts to a schematic. When I open the Symbol Editor a second time the editor loads but only loads the parts in the tables before the crystal table. The Crystals table only contains one part. Other tables contain many but this has not caused any problems.