[Loris-dev] Problems accessing the Examiner page under Clinical

[Zain Virani]

Hello Ganesh,

Loris v17.0.5 was just released which should fix the issue you found in the
Examiner page.

Thanks for your patience,
Zain

On Thu, Jun 8, 2017 at 10:34 PM, Ganesh Chauhan (CBR) <
ganesh.chauhan at cbr.iisc.ac.in> wrote:

> Hi,
>
> I am getting the following error while accessing the Examiner page via the
> front end. Please can you suggest me how to resolve this.
> However when I add an examiner via the back end using the mysql database I
> can do so and they are available for entering data for an instrument.
>
> Many thanks for your help.
>
> With best regards,
> Ganesh
>
> The following errors occured while attempting to display this page:
>
>    - *Expression #2 of SELECT list is not in GROUP BY clause and contains
>    nonaggregated column 'LORIS.e.examinerID' which is not functionally
>    dependent on columns in GROUP BY clause; this is incompatible with
>    sql_mode=only_full_group_by*
>    - *Query:*
>
>    SELECT COUNT(*) FROM (SELECT e.full_name as Examiner, e.examinerID as ID, psc.Name as Site, e.radiologist as Radiologist, GROUP_CONCAT(tn.full_name) as Certification
>                            FROM
>                             examiners e LEFT JOIN psc ON
>                            (e.centerID=psc.CenterID)
>                            LEFT JOIN certification c ON
>                            (c.examinerID=e.examinerID and c.pass = 'certified')
>                            LEFT JOIN test_names tn ON (tn.ID = c.testID) WHERE 1=1  GROUP BY e.full_name,psc.Name  ORDER BY e.full_name) as tmptable LIMIT 1
>
>    - *Bind parameters: Array ( )*
>    - *Stack Trace:*
>
>    #0 /var/www/lorisinstall/Loris/php/libraries/Database.class.inc(716): Database->execute(Object(PDOStatement), Array)
>    #1 /var/www/lorisinstall/Loris/php/libraries/Database.class.inc(733): Database->pselect('SELECT COUNT(*)...', Array)
>    #2 /var/www/lorisinstall/Loris/php/libraries/Database.class.inc(751): Database->pselectRow('SELECT COUNT(*)...', Array)
>    #3 /var/www/lorisinstall/Loris/php/libraries/NDB_Menu_Filter.class.inc(600): Database->pselectOne('SELECT COUNT(*)...', Array)
>    #4 /var/www/lorisinstall/Loris/php/libraries/NDB_Menu_Filter.class.inc(492): NDB_Menu_Filter->_getNumberPages('SELECT COUNT(*)...')
>    #5 /var/www/lorisinstall/Loris/php/libraries/NDB_Menu_Filter.class.inc(392): NDB_Menu_Filter->_getList()
>    #6 /var/www/lorisinstall/Loris/php/libraries/NDB_Menu_Filter.class.inc(157): NDB_Menu_Filter->_build()
>    #7 /var/www/lorisinstall/Loris/php/libraries/NDB_Caller.class.inc(322): NDB_Menu_Filter->setup()
>    #8 /var/www/lorisinstall/Loris/php/libraries/NDB_Caller.class.inc(187): NDB_Caller->loadMenu(Object(NDB_Menu_Filter_Form_Examiner), '')
>    #9 /var/www/lorisinstall/Loris/htdocs/main.php(180): NDB_Caller->load('examiner', '')
>    #10 {main}
>
>
>
>
> --
> Ganesh Chauhan (PhD)
> Scientist
> Centre for Brain Research (CBR)
> Indian Institute of Science (IISc)
> Bengaluru, INDIA
> +91 80 2293 3009 <+91%2080%202293%203009>
> https://www.cbr.iisc.ac.in
>
> --
> This message has been scanned for viruses and
> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
> believed to be clean.
>
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> http://www.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20170621/4966f7d5/attachment.html>