As there's no mention of the enrol/database/enrol_database_sync.php script on the enrolment plugin settings page, I must say that I missed it! Should have read the docs...
When I run this after admin/cron.php and auth/db/auth_db_sync_users.php , I'm pleased to say that there are no errors and the courses that I refer to in my external user table are created. What I don't understand is that there are no students in any of these courses, and the "welcome" e-mail is not sent to the newly-enrolled user.
Here are my database mappings:
External |
Local |
username (actually the e-mail address) |
idnumber |
courseid |
idnumber |
role |
shortname |
Here are a few example records out of my external database:
username |
courseid |
role |
test2@test.co.uk | amlcpdas1 | NULL |
test2@test.co.uk | Test |
NULL |
test3@test.co.uk | amlcpdas1 | NULL |
test3@test.co.uk | Test |
NULL |
Do they look sane? As I say, the empty courses are being created correctly. Note that there are two course enrolments for each user.
I would really appreciate some help!
EDIT: I have also noticed that I am running MySQL 4.1.22 , and there is anecdotal evidence to suggest it doesn't work on versions prior to MySQL 5. I would be willing to pay for assistance in altering the script to support this older version of MySQL. Any takers?
Many thanks,
J.