[Therion] SQL problem - solved/possible bug

[Stacho Mudrak]

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 at 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 at speleo.sk
> > https://mailman.speleo.sk/listinfo/therion
>
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk
> https://mailman.speleo.sk/listinfo/therion
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20250404/f3c244ce/attachment.htm>