Judy Hsu

Hi, thank you for helping out with this thread.

We are trying to setup an offline "archive" Moodle server on a Windows 7 workstation. Initially I installed the Moodle Windows package (which came with xampp lite 1.7.4 I believe) on C drive. Then later we found out that our moodledata is quite big and we don't have enough disk space on C drive, so we bought an external hard drive (F and I tried to install the same "Moodle Windows package" on F drive. After the installation was completed and I rebooted the machine, somehow I could NOT start MySQL from F drive. I then went into the F drive F:\0amp\server\xampp-control, and tried to manually start MySQL. It just won't start (see the screenshot below):



Does anyone know how to resolve this problem? It looks like MySQL might have been installed as a windows "service" at some point (we didn't install any standalone MySQL package though, only the "Windows Moodle Distribution." I tried to look at the Task Manager but before I click on "Start Moodle" I couldn't see MySQLd running. Please help, thanks!

Oh by the way, if I click on the "Stop Moodle" then it will prompt me:

Hi, thanks for reading this,

I recently encountered some weird behavior of Moodle. In my local dev environment I have several Moodle instanced installed (using Moodle's windows installation package but instead of just one moodle instance under the /amp/server/moodle folder, I have several under different folders). Each Moodle instance has its own config.php (of course) and different salt. However, sometimes when I go to http://localhost/moodle1919 (for example, not sure if this also happens when I go to Moodle2 instances), I would get something like this:

I guess it's really not a big deal as I can always just replace those junk characters with the correct username, but just wondering why this would happen? Any ideas? Thanks you for your help.

Hi all, thanks for reading this thread.

I'm working on the following database query (using Ad-hoc database query plugin), and this is what I have now:

-------------

SELECT u.id AS 'user ID', concat(u.firstname, ' ',u.lastname) AS name, c.id AS 'Course_ID', c.fullname AS 'Course', g.id as 'Group ID', g.name as 'Group_Name', u.email AS 'Email address', da.fieldid AS 'Field ID', da.data AS 'Job_title/Employer/Primary',
CASE WHEN gi.itemtype = 'Course'
THEN c.fullname + ' Course Total'
ELSE gi.itemname
END AS 'Item Name', ROUND(gg.finalgrade,2) AS Score,ROUND(gg.rawgrademax,2) AS MAX, ROUND(gg.finalgrade / gg.rawgrademax * 100 ,2) AS Percentage,

IF (ROUND(gg.finalgrade / gg.rawgrademax * 100 ,2) > 79,'Yes' , 'No') AS Pass

FROM prefix_course AS c
JOIN prefix_groups AS g ON g.courseid = c.id
JOIN prefix_groups_members AS m ON g.id = m.groupid
JOIN prefix_user AS u ON m.userid = u.id

JOIN prefix_user_info_data AS da ON da.userid = u.id
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON (gi.courseid = c.id AND gi.id = gg.itemid)
JOIN prefix_course_categories AS cc ON cc.id = c.category
WHERE c.id = 101 AND gi.itemname = 'Final Assessment'
ORDER BY u.id ASC

---------------

As you can see the current query will generate a list of students (and which group they belong to) in a specific course (course id 101), and list out who passed (or not pass) the final exam. However, it seems that the query will NOT include students who didn't try the final exam (with no assessment score). Is there a way to fix this issue so that it would also display those students who did not take the final exam (but are enrolled in the same course)? Thanks for your help!

Judy

Hi there how are you doing?

Thanks for reading this. We have a Moodle 2.4.4 site that we upgraded from Moodle 1.9.19 few months ago and just recently we are experiencing some really weird problems.

We setup using "Self enrollment" to allow students to use a "Enrollment key" (and a group enrolment key) so that they would automatically enroll into a course (and a group). After the 1.9 to 2.4.4 upgrade everything seems to be fine. However we do have some old courses that students are no longer accessing these old courses but for record keeping purposes (and to run statistics/queries) so we want those students to continue to stay enrolled in those courses.

However, just recently we found that those enrolled students start to disappear from those old courses. I took a quick look and those student accounts are these there (in the Site administration -> Users -> Accounts -> Browse list of users), just that they are NO LONGER enrolled in those courses. Does anyone know what might be the cause? I checked with the "Self-enrollment" settings in the Course administration block (Users -> Enrolled users -> Self-enrollment (Student) and all the settings seem to be OK (see screenshot below):

Anyone know what might be the cause of this problem? Thanks!

 

By the way the worst thing is now that I'm stuck at this page whenever I'm logging in as an admin. If I login as a student or teacher it's OK I won't see any errors, but if I login as admin I simply can not move away from this "Number of plugins requiring your attention: 22" ... any idea how to resolve this? Thanks!