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

[Blake Fitch]

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 <mailto: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
>     <mailto: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
>     <mailto: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 <http://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 <http://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 <mailto: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 <mailto:Loris-dev at bic.mni.mcgill.ca>
>     https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>
>
>
> -- 
>
> christine.rogers at mcgill.ca <mailto:christine.rogers at mcgill.ca>
> McGill Centre for Integrative Neuroscience | MCIN.ca
> Montreal Neurological Institute
> McGill University | Montreal | Canada
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20200225/1a714966/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/1a714966/attachment-0001.png>