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.