Hi! I'm trying to migrate data from a joomla component. When I try to add the table, I get a lot of "user warning" errors and it says the tables don't exist. That's because it adds the drupal prefix to the external database. How do I get it to not add the prefix on the external database?
I've read the documentation and right now my settings.php looks like this:
$db_url['default'] = 'mysqli://user:pass@localhost/drupal';
$db_url['external'] = 'mysqli://user:pass@localhost/external';
$db_prefix = array(
'default' => 'drupal_',
'external' => 'jos_',
);
From what I can understand through the documentation it shouldn't add the prefix "drupal_" to the external database, yet it does.
Comments
Comment #1
Toxid CreditAttribution: Toxid commentedOkay I figured it out now. I thought I was supposed to put in the same name as the database connection in the array. But I was supposed to put in the table name.
$db_prefix = array(
'default' => 'drupal_',
'external' => 'jos_',
);
should be
$db_prefix = array(
'default' => 'drupal_',
'tablename' => '',
);
It works fine for me now.
Comment #2
Toxid CreditAttribution: Toxid commented