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

Toxid’s picture

Toxid commented

Okay 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.

Toxid’s picture

Toxid commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.