Community Auth

Dear SB,

Thanks for taking the time to reply.

The weird bit is that I have no idea where this MEDIA database has been set up - I have a local server for testing, and I can see the MEDIA database, but I have no idea how that was created - perhaps dementia is setting in! That is the database where all the tables for Auth have been created.

When I change one of my Model functions to show the contents of say, the users table in there, it works fine. But if I reference a table that I have specified in the database that my connection settings are pointing at, it tells me there's no such table:

Code:

Table 'media.sermons' doesn't exist

These are the connection settings in the database.php files in the development version of my code:

'hostname' => 'localhost',
'username' => 'test_admin',
'password' => '*******',
'database' => 'test',
'dbdriver' => 'mysqli',

But my code appears to connect to a 'MEDIA' database on the local server!

Interestingly, in the test database mentioned above, all the tables for CommAuth are there - but they are all empty... the tables in the MEDIA database are where all the data actually resides!

I don't understand why the code is connecting to this MEDIA database when I don't appear to have specified that database anywhere in my code.

I am a bit stumped.

JMB