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

[David Blader]

Hi Ganesh,
Just to confirm, you are using MySQL version 5.7? If so, we will be issuing
a release soon that will address this issue.
You should be notified soon after the release is pushed. We apologize for
the inconvenience in the mean time.
If you are using a different MySQL version, could you please let us know
which you are using so we may better investigate the issue?
Thank you,
David B.

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/20170613/92f25706/attachment.html>