v.20 compatibility with Reporting Module (by Andy Statham)

Administration
1

My Gibbon installation is v.20 and I’m installing the extension Reporting (by Andy Statham). This error is generated when I click on “MAKE PDF” in PDF Creation.

<<PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘gibbonCourseClassPerson.gibbonCourseClassID’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /home/modules/Reporting/pdf_create_function.php:942 Stack trace: #0 /home/modules/Reporting/pdf_create_function.php(942): PDOStatement->execute(Array) #1 /home/modules/Reporting/pdf_create_function.php(454): readStudentClassListNoRepeat(Object(PDO), ‘0000001291’, ‘025’) #2 /home/modules/Reporting/pdf_create.php(98): setpdf->subjectReportRow(Object(MYPDF)) #3 {main}>>

Can you help me please?

2

Hi @andystat any thoughts on this one? Thanks!

3

Hi KMS. Isn’t Gibbon still on v19? Can’t speak for @andystat but personally I wouldn’t support a Gibbon version still WIP. Just my opinion tho. :wink:

4

Hi Roman, true indeed, we are still on v19. That said, with v20 just around the corner (8 days to go!), and the code freeze in place, now is a good time to test for compatibility.

5

v20 already has me scared. I haven’t even updated the below to avoid making a hash of everything :smiley:

6

We’ve not had any problems with the database engine migration so far!