[Therion] SQL problem - solved/possible bug

[Pavel Herich]

In newer Therion releases (previously using 6.1.8 version) something has 
been changed for sql creation:
column "nan" is produced when a survey doesn´t contain any centerline 
with (underground) lenght. So if there are only surface legs, an error 
importing sql file will occur based on line:

insert into MAPS values (110, 32, 'velky_previs_elem', NULL, 3, 0.000, 
nan);

Adding underground leg 1  1_  0.00  0  0  to centerline changes result 
as following:

insert into MAPS values (110, 32, 'velky_previs_elem', NULL, 3, 0.000, 
0.000);


I really don´t know how things work in these exports, hope this will 
help to improve things. Or maybe I am missing something.

Pavel



Dňa 2025-03-31 12:20 Pavel Herich napísal(a):
> Hi all,
> 
> recently, when I try to import an sql Therion export in DB browser, an 
> error message apears (in attachment):
> 
> Error importing data: Error in statement #67789: no such column: nan. 
> Aborting execution.
> 
> Any idea what might be the problem? Especially how to find it in source 
> Therion data...
> 
> Thank you
> Pavel
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk
> https://mailman.speleo.sk/listinfo/therion