[Loris-dev] CouchDB MRI Importer errors on Loris v17.0.5

[Mouna Safi-Harab]

Hi Michael,


In general, to fix the problem, we would add the columns causing the issues to the SELECT statement (as opposed to disabling the full_group_by mode).

I tagged you on a Loris pull request that has made changes to the MRI importer script, so you can track progress there for an eventual solution!


Thanks,


- Mouna

________________________________
From: loris-dev-bounces at bic.mni.mcgill.ca <loris-dev-bounces at bic.mni.mcgill.ca> on behalf of Michael Joseph <michael.joseph at sickkids.ca>
Sent: Tuesday, July 4, 2017 1:01:13 PM
To: loris-dev at bic.mni.mcgill.ca
Subject: [Loris-dev] CouchDB MRI Importer errors on Loris v17.0.5


Hi Loris dev team,


I received some errors when running the CouchDB_Import_MRI.php script. I've attached a log of the errors. It seems like a MySQL 5.7 issue and disabling "ONLY_FULL_GROUP_BY" mode fixed it. Without disabling the mode, the script wasn't able to populate the CouchDB database.


Michael



________________________________

This e-mail may contain confidential, personal and/or health information(information which may be subject to legal restrictions on use, retention and/or disclosure) for the sole use of the intended recipient. Any review or distribution by anyone other than the person for whom it was originally intended is strictly prohibited. If you have received this e-mail in error, please contact the sender and delete all copies.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20170705/e9b9e9d9/attachment-0001.html>