<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">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">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:1707c3b62ddb6d73ac31" alt=""></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">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>
</blockquote>
</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>
</blockquote></div>