Record audio/video question type

At the MoodleMoot DACH a few weeks ago, I spent some time with Luca Bosch and others, trying to work out if it would be possible to add Rubrics to the standard Essay question type (and other similar types like this). We were unfortunately forced to the conclusion that that was essentially impossible. When the Moodle robric system was created, they did not consider this possibility at all, and adding it now would require rebuilding a lot of things, so would be a huge amount of work.
Regarding grader information, like Essay. Yes, adding that would be very possible. It just needs someone with time to do the work.

Dear Tim Hunt, would it be possible to add a text field for grader informations in this question type like in the essay question type? (linking it to rubrics would be perfect, but as a first step, the grader information would allready be a great help).
Thanks a lot for your help!

V1.7 released. As well as the upgrade fix, includes one small enhancement that was done recently.

Thanks for testing and confirming. I will get another version released today.

The change worked. I downloaded the main branch from GitHub, then just copied the contents of the /db directory to the directory on my server. (I had been having problems with a test site.)
On my production site, routine installation from the /admin/notifications page worked without problems.

I have just pushed code which should fix this to the main branch on github. It works in my simple testing, but it woudl be nice if someone having problems with the upgrade could test it for real, before I release it. Thanks.

Or, an aditional option to get out of your immediate issue:
In this chunk of upgrade code, the 'LEFT JOIN' appears twice on lines 229 and 235. If you changed that to JOIN, then the upgrade would run without the missing data causing issues. Then you cound investigate the broken questions later.

This is coming from this chunk of code: https://github.com/moodleou/moodle-qtype_recordrtc/blob/main/db/upgrade.php#L220
The problem can only happen if you have recordrtc questions in your database which missing the corresponding row in qtype_recordrtc_options - which should be impossible.
If you can directly access your database, a query like
SELECT * FROM mdl_question q
WHERE qtype='recordrtc'
AND NOT EXISTS (SELECT 1 FROM mdl_qtype_recordrtc_options o WHERE o.questionid = q.id)
will find which questions are affected.
Then there is the issue of what do do about it. If the rows in mdl_question look like junk, you could consider deleting them. If you can get to the edit form for these particular questions, you might be able to save the question again, which might fix things, or you could manually try to insert the missing data in mdl_qtype_recordrtc_options .
Sorry for the hassle.

Now a different no joy: plugin update sets me into a database upgrade loop and I'm now stuck on this screen each time I try to update:
The new version of qbehaviour_selfassess now installs OK, but now I get:
Upgrading to new version
qtype_recordrtc
Setting default values of 'canselfrate' and 'canselfcomment' - 0/29 (id = ).
Coding error detected, it must be fixed by a programmer: moodle_database::update_record_raw() id field must be specified.
More information about this error
Debug info:
Error code: codingerror×Dismiss this notification
Stack trace:
line 1575 of /lib/dml/mysqli_native_moodle_database.php: coding_exception thrown
line 1632 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->update_record_raw()
line 251 of /question/type/recordrtc/db/upgrade.php: call to mysqli_native_moodle_database->update_record()
line 784 of /lib/upgradelib.php: call to xmldb_qtype_recordrtc_upgrade()
line 1953 of /lib/upgradelib.php: call to upgrade_plugins()
line 721 of /admin/index.php: call to upgrade_noncore()

OK, working qbehaviour_selfassess now released. I hope that works for you @Doug.

Acutally, it is not a matter of testing, it is me being stupid. I forgot how interdependent qtype_recordrtc and qbehaviour_selfassess are. If I release one, I almost certainly need to do the other. I will release the latest qbehaviour_selfassess today, and that should solve this.

@Doug Apologies as we've not picked that up in our testing (we're only up to M4.1 ourselves). We're all at the Moodle Moot UK/Ireland Monday-Wednesday this week, but will investigate as soon as we can.

With the latest version, I'm getting a dependency problem: I'm getting the message that qbehaviour_selfassess_moodle40_202203200 is not installed, but it is installed. Tried reinstalling the 'missing' selfassess, but no joy. Problem is reproduced on three sites: two running 4.1+ (20230512) and one running 4.2+ (20230512).

@ Chris Nelson. Thank you for your quick response. It's a fresh instance of Moodle 4.1 with the default theme. I then installed the latest version of the plugin and it happened. I solved it by uninstalling the plugin and installed its older version 1.4. Thank you.

@Mão Doãn. Thanks for the feedback. I'm not aware that we've made any theme changes our end, and we're only just moving to M4.1 ourselves. It sounds like something has changed in the theme you use. You may be able to modify the CSS to get it back to how you want. https://docs.moodle.org/dev/Themes is probably a good starting point for looking into how to do it.