Thanks for letting us know about the "remind password" problem. Not sure if we will fix it now, though, as we are planning on upgrading the site...we may wait for that.
Anyway, as for your problem: a client had this problem, and just this week we traced it down to the "concat" function not being available on postgres databases. I guess you are running postgres?
To fix it, I changed the queries that contain the concat, to get the fields separated, and then join them in PHP.
For example:
Code:
$users = $DB->get_records_sql("SELECT id, username, email, concat(firstname, ' ', lastname) as name,auth
FROM {$CFG->prefix}user
WHERE deleted = 0
AND auth != 'webservice'
AND (username not in ($userlist))");
I changed it by:
Code:
$users = $DB->get_records_sql("SELECT id, username, email,firstname, lastname, auth
FROM {$CFG->prefix}user
WHERE deleted = 0
AND auth != 'webservice'
AND (username not in ($userlist))");
And then, did the concat in PHP:
Code:
$u[$i]['name'] = $user->firstname . ' ' . $user->lastname;
You will need to search moodle/auth/joomdle/auth.php and replace the queries.... or better yet, you may prefer for me to have a fixed file (guess tomorrow) and can send it to you if you write me at antonio@joomdle.com
