SQL error

aotu
Hello, I'm logged in as admin, on Opigno v.1.16. When I go to the 'quiz_by_taker' view and insert an appropriate argument, I receive the following SQL error. 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 '= 'SELECT MAX(__subselect.) FROM {} __subselect WHERE __subselect. = . AND __sub' at line 3 Argument I'm supplying for user is 'student1' or '2' (the students UID) Additionally when I go to the 'View answers' section of the 'My Results' tab as any user i.e. "user/1/myresults" > "user/quiz/92/userresults" , I receive an 'Access Denied' error... All I'm looking to achieve is an output of the students most recent quiz results per course, so I can output them in a custom module in their user profile. It looks like the myresults page will yield that, but I can't actually see the View which generates that either? Admin has full permissions to everything I can see in People > Permissions Can you offer any help? Thanks
Profile picture for user James Aparicio
James Aparicio

Hi aotu,

Hi aotu,

There seems to be a bug with the quiz module. Because Opigno does not use this view, we did not notice it.

Thank you for reporting this. I will look into it. If you figured it out in the meanwhile please lets us know.

Best regards