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

[Carolina Makowski]

Excellent, Justin! It worked. Turns out I was missing columns for
Candidate_Age and Window_Difference, so I added those to the
radiology_review table. Data saved :)

thanks a lot!

Carolina

On Thu, Jun 1, 2017 at 6:59 PM, Justin Kat <justinkat at gmail.com> wrote:

> 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_stat
>> us`=: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/ND
>> B_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=152475NDAR
>> INV1K3LDK3L112261496267818&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/3b257c5c/attachment.html>