I installed this plugin in Moodle 3.4.2+ and the database is MS SQL Server 2012 R2, installation was successful but when I clicked the mentor configuration link in the Block I got the below error, any suggestions?



Debug info: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column 'mdl_user.firstname' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

SELECT u.id,
u.firstname,
u.lastname,
u.email
FROM mdl_role_assignments ra
INNER JOIN mdl_user u
ON ra.userid = u.id
WHERE u.deleted = '0'
AND u.suspended = '0'
AND ra.roleid = '1'


GROUP BY u.id
ORDER BY u.lastname ASC
[array (
0 => 0,
1 => 0,
2 => '1',
)]
Error code: dmlreadexception
×Stack trace:
line 486 of \lib\dml\moodle_database.php: dml_read_exception thrown
line 324 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
line 431 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
line 896 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
line 972 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
line 406 of \blocks\fn_mentor\lib.php: call to sqlsrv_native_moodle_database->get_records_sql()
line 61 of \blocks\fn_mentor\assign.php: call to block_fn_mentor_get_all_mentors()

HI Mohammed - it's not yet ready for 3.4 yet so we are all waiting like you. test at your own risk. Only some parts work for me. HSU Tech guy, that sounds strange as it detects course activity not login activity. With my courses if the don't access the course but did log into Moodle for x number of days then it sends it out regardless if if they logged in or not to Moodle. Maybe you mean they accessed "logged in" to the course but did no activity in the course. That's sounds like it might be a feature request Fernando would have to have programmed as it only detects access to the course not activity except being below a certain grade average. here is the link to current feature requests he is working on: http://ned.ca/plugins/#wishlist

Buen día Fernando,
He buscado y no encontrado, cómo podemos enviarle notificaciones a usuarios que NUCNA han ingresado a la plataforma?.
Espero me puedas ayudar.
Saludos

Hello,

I liked this plugins, please, How i can send email automatically to students if i select some criteria.
I had used Ned Manager, and i select 1 day for no logged users to send them notifications , if i run rules, it's work, but after one day, notifications doesn't work automatically.

Thank you a lot.

Hi Said, maybe cron is not running properly. check that first. https://docs.moodle.org/32/en/Cron

Hi, i'm using NED mentor 3.3.0 (2017072502) wit moodle 3.5.1+. when i'm trying to import users it doesn't seem to override old values. like for instance if i have user1 as a mentee for mentor1 . and now i'm updating to have user1 to be a mentee under mentor 2. i end up having 2 mentors for the same user. is there a way that i can override existing relation/records. i tried using the exported sheet as well . but it doesn't seem to respond to my overrides .

Hi team,

Recently upgraded Moodle and we're getting the following error.

running 3.5.1+ (Build: 20180817)
Php 7.2.9
Apache 2.3.34
NED Marking Manager
block_fn_marking
3.3.2
2017101200

NED Mentor Manager
block_fn_mentor
3.3.0
2017072502

Error

object of type stdClass as array Debug: \nError code: generalexceptionmessage\n* line 2483 of /blocks/fn_mentor/lib.php: Error thrown\n* line 2488 of /blocks/fn_mentor/lib.php: call to block_fn_mentor_get_selected_courses()\n* line 154 of /blocks/fn_mentor/block_fn_mentor.php: call to block_fn_mentor_get_selected_courses()\n* line 288 of /blocks/moodleblock.class.php: call to block_fn_mentor->get_content()\n* line 230 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()\n* line 1211 of /lib/blocklib.php: call to block_base->get_content_for_output()\n* line 1263 of /lib/blocklib.php: call to block_manager->create_block_contents()\n* line 604 of /lib/outputrenderers.php:
call to block_manager->ensure_content_created()\n* line 185 of /theme/adaptable/layout/includes/header.php: call to core_renderer->standard_head_html()\n* line 30 of /theme/adaptable/layout/frontpage.php: call to require_once()\n* line 1287 of /lib/outputrenderers.php: call to include()\n* line 1217 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()\n* line 112 of /index.php: call to core_renderer->header()\n, referer

Turn the initial update the site loaded correctly. It wasn't until after the teachers got into the system that this bug appeared. The only way to resolve it was for me to hide the plug in temporarily.

If you'd like to work out some time to debug, please let me know

Is this an error or by design, I have added students to the mentor block and also have set up non activity notifications. Student get the emails all fine so far. But if I remove a student from the mentor section, but keep the enrolled on a course they still get the notification emails. Should this be the case?
My situation is student leave the course, but I need to keep them on as a student on that course for reporting / financial reporting reasons. I remove them from the mentor area, but they still get emails from the notifications. Any help on this?

This plugin is very helpful. I need help regarding addition of actual and required score for each course and the result should be in the "Current grade:" section. Thanks.

How can i get the activity scores uploaded in the grade book?

Is this plugin being updated for use in higher moodle versions (3.5 and later)?

Hello, first I want to thanks Fernando for the great plugin! We are using moodle 2.8 and installed the block successful. I managed to manually give mentor and mentee roles to our users. The notifications seems to work fine too. However I have a problem. I don't have that import/export feature and I am not able to import roles with .csv. We have 3000+ users and it is impossible to give them mentor/mentee roles manually. Do you know where the problem might be? Thank you!

Hello, I have installed this plugin and it is very useful. However, I would like to ask:
1. Is it possible to merge scheduler with mentor block?
2. How would you modify so that scheduled appointments are only visible to the assigned mentor/mentee pair and the category manager?
3. Is it possible to only apply mentor block to one category instead of the whole site?
Thank you!

This plugin is very useful for Teachers and Parents. Great job!

Hello, I am currently using Moodle 3.8
Is this plugin going to work for mine? Thanks.