search

aces / Loris-MRI

The set of scripts that preprocess and insert MRI data into the database.
10 stars 50 forks source link

[imaging_non_minc_insertion] Script crashes when an invalid acquisition date is specified #986

Closed nicolasbrossard closed 1 year ago

nicolasbrossard commented 1 year ago

I ran script imaging_non_minc_insertion and specified the option -date_acquired zz (an obviously invalid date). The script crashed:

log dir is /data1/loris/data/logs and log file is /data1/loris/data/logs/FileLoad-19-56-7HhOGF.log.
PSCID is: DCC090
 CandID id: 587630
 visit_label is: V1
PSCID is: DCC090
 CandID id: 587630
 visit_label is: V1
    -> ScannerID was set to 1

    -> SessionID was set to 1053

    -> Acquisition date was set to zz

    -> Output type was set to rrr

Use of uninitialized value $yy in addition (+) at uploadNeuroDB/imaging_non_minc_insertion.pl line 533.
Use of uninitialized value $month in addition (+) at uploadNeuroDB/imaging_non_minc_insertion.pl line 533.
Use of uninitialized value $day in sprintf at uploadNeuroDB/imaging_non_minc_insertion.pl line 533.
Acquisition date: 1900-01-00
DBD::mysql::db do failed: Incorrect date value: '1900-01-00' for column 'AcquisitionDate' at row 1 at /data1/loris/bin/mri/uploadNeuroDB/NeuroDB/MRI.pm line 811.
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`nbrossard_sandbox`.`parameter_file`, CONSTRAINT `FK_parameter_file_1` FOREIGN KEY (`FileID`) REFERENCES `files` (`FileID`)) at /data1/loris/bin/mri/uploadNeuroDB/NeuroDB/MRI.pm line 836.