Anyone?
Jerry Lau
مطالب مطرح شده توسط Jerry Lau
Hello everyone.
We are on:
O/S: Ubuntu 16.04+, Version: 3.9.4+ (2020061504.01), Release: 01.22.2021, PHP: 7.2.34-21, MySQL: 5.7.31
Trying to get an understanding about OneDrive.
Once we implement this, my questions are:
1. If a student/user/teacher is connected to their oneDrive and using the file picker, they "upload" or submit their file (say 5 GB - a video or drawing file) as an assignment or something to a course, is this file an actual file that is "pushed" to our moodle data directly and stored there or IS IT just a link to the user's OneDrive repository? If not, would it not defeat the purpose of reducing large moodledata directory space?
2. I hope it the previous where it is just a link and not an actually file stored on the moodle data folder. I think so because uploading large files is resource intensive and could time out.
3. If it is a link, what happens if the student or user has left the school, would the link still be active where the instructor can still view their file?
Ideally, we'd like to inform our instructors to backup their course files and save it to their OneDrive repository instead to save space on the moodle server.
Thank you in advance for clarifying and educating me on the 3 questions I have above.
Regards.
Dave.
Hello.
We have moodle 3.9.x running on ubuntu with php 7.3.x and mysql 5.7.x
Our webwork server is running the latest build
I created the webwork cours; set up the secret "password" in webwork and configured the authen_LTI.conf file in WebWork..
I created a test moodle course and added students to them.
I created the external tool to the WebWork class and when users click on that LTI LINK, it shows them the login page of their webwork course.
Shouldn't they be SSO'd in there?
thanks
check your space quota, delete what is in your trashdir and temp directories. Make sure your db connection is sound. any patches applied at server level? any new software installed on the server(s)? Reboot the machine? Did you truncate or trim your log table? How large is your db "inno" file, if applicable, etc.
Hello folks.
I am getting close.. running rhel 6.8, php 7.3.4 moodle 3.9.4 and mysql 5.7
I wrote a query to find out which courses have students (identified using their email and not via roleid) that have enrolled BOTH via "database" and "manual" method but having problems trying to find their course id.
The purpose is to delete the "database" method only IF BOTH exist. For example if course A has a student who was enrolled BOTH via DB and Manual enrolment plugin, I want to delete their "db method" and leave their "manual" intact. Again only when both occur. If not, then it skips to next record. This is in preparation to start a new and clean db enrolment method moving forward with new enrolments .
this is my sample query for now. I don't know how to get it to show on the query result the course id if I do not selectively choose one, as shown in my example:
SELECT userid , enrolid FROM mdl_user_enrolments WHERE enrolid IN (Select e.id FROM mdl_enrol e where (e.enrol ='database' or e.enrol='manual') and e.courseid IN (SELECT c.id FROM mdl_role_assignments ra, mdl_user u, mdl_course c, mdl_context cxt WHERE ra.userid = u.id AND ra.contextid = cxt.id AND cxt.contextlevel =50 AND cxt.instanceid = c.id AND roleid =5 AND u.email like '%@student.school.com%' and c.id ='XXXXXX'));
Note the dupes in the userid column. the enrolid contain both the enrolment id's of manual and db of course
+--------+---------+
| userid | enrolid |
+--------+---------+
| 142276 | 33442 |
| 145150 | 33442 |
| 145181 | 33442 |
| 145417 | 33442 |
| 145420 | 33442 |
| 145422 | 33442 |
| 145428 | 33442 |
| 145863 | 33442 |
| 145870 | 33442 |
| 146019 | 33442 |
| 146020 | 33442 |
| 146022 | 33442 |
| 146023 | 33442 |
| 146024 | 33442 |
| 146026 | 33442 |
| 146193 | 33442 |
| 146197 | 33442 |
| 146327 | 33442 |
| 146328 | 33442 |
| 148172 | 33442 |
| 148661 | 33442 |
| 163621 | 33442 |
| 142276 | 33477 |
| 145150 | 33477 |
| 145181 | 33477 |
| 145417 | 33477 |
| 145420 | 33477 |
| 145422 | 33477 |
| 145428 | 33477 |
| 145863 | 33477 |
| 145870 | 33477 |
| 146019 | 33477 |
| 146020 | 33477 |
| 146022 | 33477 |
| 146023 | 33477 |
| 146024 | 33477 |
| 146026 | 33477 |
| 146193 | 33477 |
| 146197 | 33477 |
| 146327 | 33477 |
| 146328 | 33477 |
| 148172 | 33477 |
| 148661 | 33477 |
+--------+---------+
43 rows in set (0.00 sec)
How can I change my query?
Thank you