insert into import_file_log fails

[andersonwinkler]

First import on a new server:

 NiDB version 2025.10.1305
   Build date [Oct 21 2025 15:52:33]
   C++ [201703]
   Qt compiled [6.9.1]
   Qt runtime [6.9.1]
   Build system [x86_64-little_endian-lp64]
Not debug mode
[2025/12/10 16:17:01][157662] Entering the import module
[2025/12/10 16:17:01][157662] ********** Working on directory [/nidb/data/dicomincoming] with importRowID [0] **********
[2025/12/10 16:17:01][157662] Module running check-in
[2025/12/10 16:17:01][157662] Found 39 total files in path [/nidb/data/dicomincoming]
[2025/12/10 16:17:01][157662] SQL ERROR (Module: import Function: ParseDirectory File: ../../../SOURCES/src/nidb/moduleImport.cpp Line: 657)

SQL (1) [insert into import_file_log (filename, importfile_datetime, file_datetime, file_size, file_type, Modality, PatientID, StudyUID, SeriesUID, StudyDescription, SeriesDescription, SeriesNumber, AcquisitionNumber, InstanceNumber) values (?, now(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [/nidb/data/dicomincoming/1.3.12.2.1107.5.2.50.176815.2023111409493693640406378] [2025-12-10T16:15:27.836] [12212886] [DICOM] [MR] [SolutionN] [] [] [(TSP)] [resolve_4scan_trace_tra_p2_s2_224_TRACEW] [18] [] [2]]

SQL (2) [insert into import_file_log (filename, importfile_datetime, file_datetime, file_size, file_type, Modality, PatientID, StudyUID, SeriesUID, StudyDescription, SeriesDescription, SeriesNumber, AcquisitionNumber, InstanceNumber) values (?, now(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]

Database error [Incorrect integer value: '' for column `nidb`.`import_file_log`.`AcquisitionNumber` at row 1]

Driver error [QMYSQL: Unable to execute statement]
[2025/12/10 16:17:01][157662] SQL error, exiting program

It looks like it's the datatype of some columns. I can probably fix here but it may be something that needs to be changed in the schema.

Thanks!

Anderson

[andersonwinkler]

PS: another possibility might be to change from empty [] to NULL in the insert statement when the field doesn't exist or is empty.

[gbook]

Hopefully fixed in latest release. I'll post the release soon.