search

remotelearner / moodle-block_grade_me

14 stars 37 forks source link

Error to view and write to the database 3.8.0.0 #44

Open csriveraine opened 4 years ago

csriveraine commented 4 years ago

Hello i got some problem with the plugin My environnement : Moodle 3.8.4 + Plugin grade_me 3.8.0.0 MSSQL / IIS / PHP 7.4.7

My problem is when the schedule task running i got an error : _Execute scheduled task: Activités à noter (block_grade_me\task\cache_grade_data) ... started 15:22:02. Current memory use 19.7Mo. ... used 8 dbqueries ... used 0.027261018753052 seconds Scheduled task failed: Activités à noter (block_grade_me\task\cache_gradedata),Error reading database

My test is i got a course with 1 teacher and 1 student in manuel inscription. The student upload a new homework. When i connect to the teacher and try to saw in the plugin if i got a notification with this student but nothing appear.

klovsb commented 3 years ago

I have same problem in our environment: Moodle 3.8.5 Grade_me 3.8.0.0 MSSQL / IIS / PHP 7.2 Error message indicate Incorrect syntax near the keyword 'user'. I applied the code modification for PostgreSQL and found that it worked on MS SQL.