<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Hi Nicolas,
<div class=""><br class="">
</div>
<div class="">I checked the records, for the 3200 deleted uploadId, and the sessionID was not in there. Also, the UPDATE statement was issues in the same table. Here is an example of INSERT and UPDATE commands in the SQL file:</div>
<div class=""><br class="">
</div>
<div class="">===</div>
<div class="">
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""><font color="#000000" class="">INSERT INTO `mri_upload` VALUES (9,'lorisadmin\n','2017-11-28 16:30:47',’/ABC/AAB21935_880779_m00.tar.gz','/tmp/ImagingUpload-16-30-jIjf1G',1,0,'AAB21935_880779_m00',8,8,6,</font><font color="#ff1f00" class="">4</font><font color="#000000" class="">,1,1,'N');</font></span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; color: rgb(0, 0, 0);" class="">
<span style="font-variant-ligatures: no-common-ligatures" class="">UPDATE session s SET Scan_done = 'Y' WHERE s.ID IN (4) AND (SELECT COUNT(*) FROM mri_upload m WHERE m.SessionID=s.ID) > 0; </span></div>
</div>
<div class="">===</div>
<div class=""><br class="">
</div>
<div class="">Maybe the insertion process didn’t finish properly but the state of the database was updated? As you can see this images were uploaded in 2017 using LORIS v17.0.0 or v18.0.0. Let me know if you have more suggestions on what to check and how we
can solve this.</div>
<div class=""><br class="">
</div>
<div class="">Best,</div>
<div class="">Alfredo.</div>
<div class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Apr 13, 2020, at 8:37 PM, Nicolas Brossard <<a href="mailto:nicolasbrossard.mni@gmail.com" class="">nicolasbrossard.mni@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<p class=""><span style="padding: 3px 10px; border-radius: 5px; color: #ffffff; font-weight: bold; display: inline-block; background-color: #ff0000;" class=""> External Email - Use Caution </span></p>
<div class=""><br class="webkit-block-placeholder">
</div>
<div dir="ltr" class="">Hi Alfredo,
<div class=""><br class="">
</div>
<div class="">I am curious to see the actual records that the delete script removed from your mri_upload table. Since the delete script backs up what it deletes, you can have a look inside the backup file it created. By default, this file is named imaging_upload_backup.tar.gz.
Inside, you'll find an SQL file that should contain all the entries in mri_upload that were deleted. Can you check if all of them have a sessionID set to 845 (they should)? Can you also check in the same file the UPDATE statement that was issued on the session
table? We'll start with these checks first.</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">Best,</div>
<div class="">Nicolas</div>
<div class=""><br class="">
</div>
</div>
<br class="">
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, Apr 13, 2020 at 8:16 PM Morales Pinzon, Alfredo <<a href="mailto:AMORALESPINZON@bwh.harvard.edu" class="">AMORALESPINZON@bwh.harvard.edu</a>> wrote:<br class="">
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div style="overflow-wrap: break-word;" class="">Dear LorisDev Team,
<div class=""><br class="">
</div>
<div class="">I recently removed all the UploadIDs from a study using the script “<font face="Helvetica Neue" class=""><span style="" class=""><a href="http://delete_imaging_upload.pl/" target="_blank" class="">delete_imaging_upload.pl</a></span><span style="" class="">”</span><span style="" class="">.
However, in the front-end I can see some </span><span style="" class="">imaging visits for some candidates of the study. </span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class="">Here is an example for one visit:</span></font></div>
<div class=""><br class="">
</div>
<div class="">Here is the imaging session for one the Candidates with the issue:</div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class="">===</span></font></div>
<div class="">
<div class=""><font face="Menlo" class="">select * from session where CandID in (450030) \G;</font></div>
<div class=""><font face="Menlo" class="">*************************** 1. row ***************************</font></div>
<div class=""><font face="Menlo" class=""> <font color="#ff1f00" class="">
ID: 845</font></font></div>
<div class=""><font face="Menlo" class=""> CandID: 450030</font></div>
<div class=""><font face="Menlo" class=""> CenterID: 60</font></div>
<div class=""><font face="Menlo" class=""> VisitNo: 1</font></div>
<div class=""><font face="Menlo" class=""> Visit_label: m00</font></div>
<div class=""><font face="Menlo" class=""> SubprojectID: 2</font></div>
<div class=""><font face="Menlo" class=""> Submitted: N</font></div>
<div class=""><font face="Menlo" class=""> Current_stage: Not Started</font></div>
<div class=""><font face="Menlo" class=""> Date_stage_change: NULL</font></div>
<div class=""><font face="Menlo" class=""> Screening: NULL</font></div>
<div class=""><font face="Menlo" class=""> Date_screening: NULL</font></div>
<div class=""><font face="Menlo" class=""> Visit: NULL</font></div>
<div class=""><font face="Menlo" class=""> Date_visit: NULL</font></div>
<div class=""><font face="Menlo" class=""> Approval: NULL</font></div>
<div class=""><font face="Menlo" class=""> Date_approval: NULL</font></div>
<div class=""><font face="Menlo" class=""> Active: Y</font></div>
<div class=""><font face="Menlo" class=""> Date_active: 2017-11-10</font></div>
<div class=""><font face="Menlo" class=""> RegisteredBy: 5216-ICR_dataman</font></div>
<div class=""><font face="Menlo" class=""> UserID: 5216-ICR_dataman</font></div>
<div class=""><font face="Menlo" class=""> Date_registered: 2017-11-10</font></div>
<div class=""><font face="Menlo" class=""> Testdate: 2017-11-30 11:07:25</font></div>
<div class=""><font face="Menlo" class=""> Hardcopy_request: -</font></div>
<div class=""><font face="Menlo" class=""> BVLQCStatus: NULL</font></div>
<div class=""><font face="Menlo" class=""> BVLQCType: NULL</font></div>
<div class=""><font face="Menlo" class=""> BVLQCExclusion: NULL</font></div>
<div class=""><font face="Menlo" class=""> QCd: NULL</font></div>
<div class=""><font face="Menlo" class=""> <font color="#ff1f00" class="">
Scan_done: Y</font></font></div>
<div class=""><font face="Menlo" class=""> MRIQCStatus:</font></div>
<div class=""><font face="Menlo" class=""> MRIQCPending: N</font></div>
<div class=""><font face="Menlo" class="">MRIQCFirstChangeTime: NULL</font></div>
<div class=""><font face="Menlo" class=""> MRIQCLastChangeTime: NULL</font></div>
<div class=""><font face="Menlo" class=""> MRICaveat: false</font></div>
</div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class="">===</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class="">However, there is no TarchiveID associated with the session id in the mri_upload table</span></font></div>
<div class=""><span style="" class=""><font face="Menlo" class="">===</font></span></div>
<div class=""><span class=""><font face="Menlo" class="">
<div class=""><span style="" class="">select TarchiveID from mri_upload where SessionID=</span><font color="#ff1f00" class="">845</font><span style="" class=""> \G;</span></div>
<div style="" class="">Empty set (0.00 sec)</div>
</font></span></div>
<div class=""><span style="" class=""><font face="Menlo" class="">===</font></span></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class="">Any ideas on how can I fix this.</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class="">Thank you in advance for your help.</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class="">Regards,</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class="">Alfredo.</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="" class=""><br class="">
</span></font></div>
</div>
_______________________________________________<br class="">
Loris-dev mailing list<br class="">
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank" class="">Loris-dev@bic.mni.mcgill.ca</a><br class="">
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank" class="">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br class="">
</blockquote>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</body>
</html>