Hi Pali, this bug should be "quickfixed" in 3d1f152 <https://github.com/therion/therion/commit/3d1f1529401ec69c05819e1ab5e4095cbdb75e98> . S. On Mon, 31 Mar 2025 at 14:02, Pavel Herich <herich@speleodd.sk> wrote:

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@speleo.sk https://mailman.speleo.sk/listinfo/therion

_______________________________________________ Therion mailing list Therion@speleo.sk https://mailman.speleo.sk/listinfo/therion