[Loris-dev] Troubleshooting Imaging Browser not loading for 22.0.0 release

[Christine Rogers, Ms.]

Hi Blake,
First/next troubleshooting question --

Could you verify you're using the latest update from this bugfix:
https://github.com/aces/Loris/pull/6089/commits/c78af4ebc97d354b6820c51c8bb746e0e0e554f5

This may resolve it, let us know --
Thanks,
Christine

On Mon, Feb 24, 2020 at 1:23 PM Christine Rogers, Ms. <christine.rogers at mcgill.ca<mailto:christine.rogers at mcgill.ca>> wrote:
Hi Loris team and community,
i'm forwarding a question from Blake (below) from Max Planck in Tuebingen --he's encountering a (known) bug in the 22.0.0 Imaging Browser where the module doesn't load (issue #6088)

His apache error log output is below.
Blake is running Ubuntu and has installed 22.0.0, and uploaded some test DICOMs.  He's applied the proposed bugfix #6089, without success (see below).

Could someone help resolve / share a solution for this ?
Thanks,
Christine

---------- Forwarded message ---------
From: Blake Fitch <blake.fitch at tuebingen.mpg.de<mailto:blake.fitch at tuebingen.mpg.de>>
Date: Fri, Feb 21, 2020 at 11:11 AM
Subject: Re: Fix for Imaging Browser not loading
To: Christine Rogers, Ms. <christine.rogers at mcgill.ca<mailto:christine.rogers at mcgill.ca>>



Hi Christine,

I did the new patch. Looks the same. here's there error log entry that pops out.

[Fri Feb 21 16:09:51.361760 2020] [php7:warn] [pid 25261] [client 10.38.124.254:55712<http://10.38.124.254:55712>] PHP Warning:  PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '//              \n            CASE \n                WHEN s.MRIQCPending='Y' THEN ' at line 30 in /var/www/loris/src/Data/Provisioners/DBRowProvisioner.php on line 81, referer: http://10.38.133.3/imaging_browser/
[Fri Feb 21 16:09:51.361873 2020] [php7:error] [pid 25261] [client 10.38.124.254:55712<http://10.38.124.254:55712>] PHP Fatal error:  Uncaught Exception: Invalid SQL statement: SELECT \n              p.Name as Site,\n              c.PSCID as PSCID,\n              c.CandID as DCCID,\n              Project.Name as project,\n              s.Visit_label as visitLabel,\n              \n            CASE s.MRIQCStatus\n                WHEN 'Fail' THEN\n                    IF(s.MRIQCPending='Y', 'Pending Fail', 'Fail')\n                WHEN 'Pass' THEN\n                    IF(s.MRIQCPending='Y', 'Pending Pass', 'Pass') \n                ELSE s.MRIQCStatus\n            END \n             as Visit_QC_Status,\n              DATE_FORMAT(MIN(pf.Value), "%Y-%m-%d") as First_Acquisition,\n              FROM_UNIXTIME(MIN(f.InsertTime)) as First_Insertion,\n              FROM_UNIXTIME(MAX(fqc.QCLastChangeTime)) as Last_QC,\n              \n            CASE \n                COALESCE(Max(fqc.QCLastChangeTime), 'new')\n                WHEN 'new' THEN 'new'\n                WHEN ''    THEN 'new'\n                WHEN NULL  THEN 'new'\n                ELSE ''\n            END as New_Da in /var/www/loris/src/Data/Provisioners/DBRowProvisioner.php on line 84, referer: http://10.38.133.3/imaging_browser/

Best,
Blake


--

christine.rogers at mcgill.ca<mailto:christine.rogers at mcgill.ca>
McGill Centre for Integrative Neuroscience | MCIN.ca
Montreal Neurological Institute
McGill University | Montreal | Canada
_______________________________________________
Loris-dev mailing list
Loris-dev at bic.mni.mcgill.ca<mailto:Loris-dev at bic.mni.mcgill.ca>
https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev


--

christine.rogers at mcgill.ca<mailto:christine.rogers at mcgill.ca>
McGill Centre for Integrative Neuroscience | MCIN.ca
Montreal Neurological Institute
McGill University | Montreal | Canada
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20200224/18b270b3/attachment-0001.html>