[Loris-dev] radiology reviews - error in saving data

[Justin Kat]

Turn on showDatabaseQueries in /var/www/abcd/project/config.xml by setting
it to "1", look for the "UPDATE radiology_review SET ...." query upon
saving the instrument, log in to MySQL from the command line or otherwise,
copy paste that query(you may have to clean up the syntax for the "WHERE
CommentID= ..." part), run and see what the error is - most likely a
mismatch with your radiology_review table definition vs the update columns,
fix or continue debugging and set showDatabaseQueries back to 0 when you're
done

On Thu, Jun 1, 2017 at 1:16 PM, Carolina Makowski <carolina.mak3 at gmail.com>
wrote:

> Hi LORIS team!
> I've started a thread with Christine regarding this but thought I would
> bring this to the larger group as well since Christine is heading off on
> vacation.
>
> I am having trouble saving data for a candidate's radiology review,
> although I can enter data with no problems through the front end.
>
> The last error in my loris-error.log is:
>
> [Thu Jun 01 10:07:32.133258 2017] [:error] [pid 844] [client
> 169.228.191.13:62590] Could not execute UPDATE radiology_review SET
> `Date_taken`=:set_Date_taken,`Examiner`=:set_Examiner,`Scan_
> done`=:set_Scan_done,`MRI_date`=:set_MRI_date,`MRI_date_
> status`=:set_MRI_date_status,`Review_date`=:set_Review_date,
> `Review_date_status`=:set_Review_date_status,`Review_
> results`=:set_Review_results,`abnormal_atypical_
> exclusionary`=:set_abnormal_atypical_exclusionary,`
> Incidental_findings`=:set_Incidental_findings,`
> Incidental_findings_status`=:set_Incidental_findings_
> status,`Candidate_Age`=:set_Candidate_Age,`Window_Difference`=:set_Window_Difference
> WHERE `CommentID`=:where_CommentID. Stack trace#0
> /var/www/abcd/php/libraries/Database.class.inc(391):
> Database->_realupdate('radiology_revie...', Array, Array, true)\n#1
> /var/www/abcd/php/libraries/NDB_BVL_Instrument.class.inc(706):
> Database->update('radiology_revie...', Array, Array)\n#2
> /var/www/abcd/php/libraries/NDB_BVL_Instrument.class.inc(681):
> NDB_BVL_Instrument->_save(Array)\n#3 /var/www/abcd/php/libraries/LorisForm.class.inc(1326):
> NDB_BVL_Instrument->_saveValues(Array)\n#4 /var/www/abcd/php/libraries/
> NDB_BVL_Instrument.class.inc(486): LorisForm->process(Array, true)\n#5
> /var/www/abcd/php/libraries/NDB_Caller.class.inc(484):
> NDB_BVL_Instrument->save()\n#6 /var/www/abcd/php/libraries/NDB_Caller.class.inc(288):
> NDB_Caller->loadInstrument('radiology_revie...', '',
> '152475NDARINV1K...', NULL)\n#7 /var/www/abcd/htdocs/main.php(180):
> NDB_Caller->load('radiology_revie...', '')\n#8 {main}, referer:
> http://169.228.56.161/radiology_review/?commentID=
> 152475NDARINV1K3LDK3L112261496267818&sessionID=11&candID=152475
>
>
> I can confirm that this commentID exists in the flag table and I have an
> instrument table for radiology_review. Let me know if one of you might have
> some insight into this.
>
> Thanks a lot!
>
> Carolina
>
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> http://www.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20170601/6f319725/attachment-0001.html>