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

Tue Feb 25 07:19:59 EST 2020

Hi Blake,

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.

Another possibility is to check the MySQL parameters used in sql_mode?
Which could be checked via "SELECT @@sql_mode;", 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.

Best regards,
Ling Ma
Dev consultant.

On Tue, Feb 25, 2020 at 4:32 AM Blake Fitch <blake.fitch at tuebingen.mpg.de>
wrote:

> Hi Christine,
>
> 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:
> "An error occured while loading the page."
>
> Here is a snapshot of the code in that area of the file:
>
> Best,
> Blake
> On 24.02.20 19:33, Christine Rogers, Ms. wrote:
>
> 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> 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>
>> 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>
>>
>>
>> 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] 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] 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
>> 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
>> https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>>
>
>
> --
>
> 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
> https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20200225/18caf8d6/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: idpdinjchipjdbce.png
Type: image/png
Size: 61983 bytes
Desc: not available
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20200225/18caf8d6/attachment-0001.png>