<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div dir="ltr">
<div dir="ltr">Hi Blake,
<div>First/next troubleshooting question --
<div><br>
</div>
<div>Could you verify you're using the latest update from this bugfix: </div>
<div><a href="https://github.com/aces/Loris/pull/6089/commits/c78af4ebc97d354b6820c51c8bb746e0e0e554f5" target="_blank">https://github.com/aces/Loris/pull/6089/commits/c78af4ebc97d354b6820c51c8bb746e0e0e554f5</a><br>
</div>
<div><br>
</div>
<div>This may resolve it, let us know --</div>
<div>Thanks,</div>
<div>Christine </div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, Feb 24, 2020 at 1:23 PM Christine Rogers, Ms. <<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">Hi Loris team and community,
<div>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)
<div><br>
</div>
<div>His apache error log output is below. </div>
<div>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). </div>
<div><br>
</div>
<div>Could someone help resolve / share a solution for this ? <br>
</div>
<div>Thanks,</div>
<div>Christine<br>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">---------- Forwarded message ---------<br>
From: <strong class="gmail_sendername" dir="auto">Blake Fitch</strong> <span dir="auto">
<<a href="mailto:blake.fitch@tuebingen.mpg.de" target="_blank">blake.fitch@tuebingen.mpg.de</a>></span><br>
Date: Fri, Feb 21, 2020 at 11:11 AM<br>
Subject: Re: Fix for Imaging Browser not loading<br>
To: Christine Rogers, Ms. <<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a>><br>
</div>
<br>
<br>
<div>
<p>Hi Christine,</p>
<p>I did the new patch. Looks the same. here's there error log entry that pops out.</p>
<p><tt>[Fri Feb 21 16:09:51.361760 2020] [php7:warn] [pid 25261] [client <a href="http://10.38.124.254:55712" target="_blank">
10.38.124.254:55712</a>] 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:
<a href="http://10.38.133.3/imaging_browser/" target="_blank">http://10.38.133.3/imaging_browser/</a></tt><tt><br>
</tt><tt>[Fri Feb 21 16:09:51.361873 2020] [php7:error] [pid 25261] [client <a href="http://10.38.124.254:55712" target="_blank">
10.38.124.254:55712</a>] 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:
<a href="http://10.38.133.3/imaging_browser/" target="_blank">http://10.38.133.3/imaging_browser/</a></tt><br>
<br>
Best,<br>
Blake<br>
</p>
<div><br>
</div>
</div>
</div>
<div><br>
</div>
-- <br>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><br>
<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a><br>
McGill Centre for Integrative Neuroscience | MCIN.ca</div>
<div>Montreal Neurological Institute</div>
<div>McGill University | Montreal | Canada</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote>
</div>
<br clear="all">
</div>
<div><br>
</div>
-- <br>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><br>
<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a><br>
McGill Centre for Integrative Neuroscience | MCIN.ca</div>
<div>Montreal Neurological Institute</div>
<div>McGill University | Montreal | Canada</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>