<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Christine,</p>
<p>I have ensured that he code matches the link you sent. I did the
edit, ran make in /var/www/loris, and restarted apache. I still
get:<br>
"An error occured while loading the page."</p>
<p>Here is a snapshot of the code in that area of the file:</p>
<p><img src="cid:part1.C5C456FB.3E52FE8A@tuebingen.mpg.de" alt=""></p>
<p>Best,<br>
Blake<br>
</p>
<div class="moz-cite-prefix">On 24.02.20 19:33, Christine Rogers,
Ms. wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CALbt7NCe3wMOTVFoWu_7S7nRdBMm7yAwU_Do+t6+WLAj59mJPw@mail.gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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" moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">
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" moz-do-not-send="true">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" moz-do-not-send="true">
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" moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">Loris-dev@bic.mni.mcgill.ca</a><br>
<a
href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">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>
</blockquote>
</body>
</html>