<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Ling Ma,</p>
<p>That made that page work. Thank you.</p>
<p>Best,<br>
Blake<br>
</p>
<div class="moz-cite-prefix">On 25.02.20 13:27, Ling Ma wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAMpvQ9iTTAzaLTcxeWsMeQf==3kq2brVxfVBSFhxUEvvQwdJKg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Correction: That part of code is not a PHP command
line, it is a whole SQL query command separated in several
lines. The SQL doesn't accept "//" as a comment</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Feb 25, 2020 at 7:22
AM Ling Ma <<a href="mailto:lingyun.ma@mcin.ca"
moz-do-not-send="true">lingyun.ma@mcin.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 dir="ltr">Hi Blake,
<div><br>
</div>
<div>I just rechecked the image your shared, I saw the
problem: you should not add "//" in front of the several
lines in your code, I saw three of them, which will make
the syntax totally invalid, because it is not a command
line, they are a whole command wrapped in several lines.</div>
<div><br>
</div>
<div><br>
</div>
<div>Best regards,</div>
<div>Ling Ma<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Feb 25, 2020 at
7:19 AM Ling Ma <<a href="mailto:lingyun.ma@mcin.ca"
target="_blank" moz-do-not-send="true">lingyun.ma@mcin.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 dir="ltr">Hi Blake,
<div><br>
</div>
<div>The $modalities_subquery seems to be the only place
where it is possible to create a wrong SQL when this
variable is empty and when the Loris-MRI is not
installed, which will create a favorite environment
for image_browser. I am wondering what your MySQL
server version is, version 5.7 or above? If yes, what
is the step you have taken to install Loris? If you
have followed the exact installation instructions,
then I am wondering whether you could share your
zipped database dump, which should not be big since
this is a new installation, so that we could
investigate what has happened. Thanks a lot and sorry
for the trouble.</div>
<div><br>
</div>
<div>Another possibility is to check the MySQL
parameters used in sql_mode? Which could be checked
via "<span>SELECT</span><span> </span><span>@@</span><span>sql_mode</span><span>;",
could you also check that value? What is the value
you see? Since image_browser uses a relatively
complicated query, it is possible that a parameter
might make the syntax not valid.</span><br>
</div>
<div><br>
</div>
<div>Best regards,</div>
<div>Ling Ma</div>
<div>Dev consultant.</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Feb 25, 2020
at 4:32 AM Blake Fitch <<a
href="mailto:blake.fitch@tuebingen.mpg.de"
target="_blank" moz-do-not-send="true">blake.fitch@tuebingen.mpg.de</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>
<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:part4.181A8283.0C25A4D9@tuebingen.mpg.de"
alt="" class=""></p>
<p>Best,<br>
Blake<br>
</p>
<div>On 24.02.20 19:33, Christine Rogers, Ms. wrote:<br>
</div>
<blockquote type="cite">
<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>
</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>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</body>
</html>