I'm setting up a simple Moodle site and I'm trying to use the external database method of registering and enrolling students.
The workflow I've got so far is customers will come to a wordpress site. They choose to buy access to the course (one day of content that must be done in order and can only be viewed once) via WP eStore. Once the purchase has been processed, the customer ends on a thank you for paying page where there is a form waiting for them where they can input their username and password. Once they submit that form they are taken over to the moodle side where they can log in.
After trying several different form plugins for Word Press I finally found one that stored the data from the users all in one row with each item in its own field. (Form Manager by Campbell Hoffman). I thought I was past the hard part, but the moodle external database plugins don't connect properly to the database.
I don't know much about this side of database stuff, so there could very well be a simple setting that I'm overlooking or have set wrong.
Here's the error message I get back when testing the connection for the authentication via external database:
1054: Unknown column 'text' in 'where clause'
ADOConnection._Execute(SELECT * FROM wp_fm_data_1 WHERE text-5361773777c2d <> 'random_..., false) % line 1044, file: adodb.inc.php ADOConnection.Execute(SELECT * FROM wp_fm_data_1 WHERE text-5361773777c2d <> 'random_...) % line 837, file: auth.php auth_plugin_db.test_settings() % line 75, file: test_settings.php