(apologies if you see this as a duplicate, I had signed up with the incorrect email and wasn't sure if it'd get through).
Hi Folks,
I'm developing a module at the moment that runs on a cron job. The task of the module at the moment is to get all the users from the drupal database, then connect to a EMS database and insert the users into this database. It allows the site to keep registered users and mailing list users in sync.
At the moment, I have the two connection strings in the settings.php file:
$db_url['ems'] = 'mysql://client_ems:client_ems@localhost/client_ems'; $db_url['default'] = 'mysql://client:client@localhost/client';
$db_prefix = array( 'default' => 'main_', 'ems' => 'ems_', );
Then within the module, I have my hook_cron function, at the moment it's just for debugging:
function copycontacts_cron() {
// First lets get our users $get_users_query = db_query("SELECT * FROM {users} WHERE STATUS = 1");
while ( $user[] = db_fetch_array($get_users_query) ) { echo '<xmp>'; print_r($user); echo '</xmp>'; }
if (db_set_active('ems')) { echo 'DB Selected'; } $moo = db_query('SELECT * FROM {cron}'); while ($foo = db_fetch_array($moo)) { echo $foo; } db_set_active('default'); }
The function gets as far as the DB Selected message, and then gives me this error:
Warning: Table 'client_ems.main_system' doesn't exist query: SELECT * FROM main_system WHERE type = 'theme' in /path/to/client/public_html/includes/database.mysql.inc on line 172
However I am not making this request, it seems to be coming from drupal somehow. Can anyone suggest what might be up?.