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

[Ganesh Chauhan (CBR)]

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 
https://www.cbr.iisc.ac.in 

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20170609/57a6d5e4/attachment.html>