Posts made by Visvanath Ratnaweera

Moodle in English -> Hardware and performance -> 'sessions' table gets populated, 'dbsessions' is not set [Moodle 4.1.15+] -> Re: 'sessions' table gets populated, 'dbsessions' is not set [Moodle 4.1.15+]

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Hi Ken

Thanks for the deep analysis. I should have added that the 'userid' field of the 'sessions' table is either 0 or contains the id of a user that exists and very recently logged in. All the 'timecreated' values are the present time. So I assume that those are the creation time of the session for each user.

So the data seem to be genuine. The question is why they are there in the database at all? Does Moodle save them temporarily in the database before creating the (longer-term) session file in moodledata/sessions? BTW, within a few hours the number or records has risen from 1 to 190.
Average of ratings: -

Moodle in English -> Hardware and performance -> 'sessions' table gets populated, 'dbsessions' is not set [Moodle 4.1.15+]

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators

Hi all

I was surprised to find some 80 records in the 'sessions' table even though the configuration variable dbsessions is not set.

Even more surprised to find that the number climbed to 30 minutes after I truncated the table! 

Any insight in to this? I've seen MDL-84051. But that is about Moodle 4.5. This one is 4.1.15+ (Build: 20241219).

Average of ratings: -

Moodle in English -> Quiz -> Moodle 4.5.2: Failed to find an answer matching "" in the question_answers database table -> Re: Moodle 4.5.2: Failed to find an answer matching "" in the question_answers database table

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Thanks, it should work then.

I realize that, what we need is not only deleting old quiz attempts but whole question banks. Found this pair, https://moodle.org/plugins/qbank_purgecategory and https://moodle.org/plugins/local_purgequestioncategory. Installed on out 4.1.15 through the Moodle GUI, they passed the version tests. But no new item appear in the drop-down.
Attachment Screenshot_2025-03-07_17-37-25.png
Attachment Screenshot_2025-03-07_17-37-54.png
Average of ratings: -

Moodle in English -> Courses and course formats -> Upgrade 4.1 LTS > 4.5 LTS. format_scorm missing from disk -> Re: Upgrade 4.1 LTS > 4.5 LTS. format_scorm missing from disk

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
That simple!

But now I'm puzzled. The original site, a 4.1.15, doesn't have a format_scorm anywhere, not also marked "Missing from disk". My cloning and upgrading process must have introduced the warning. It is a heavy site - I'm not keen on repeating the exercise immediately. But the next time, I'll watch more carefully.
Average of ratings: -