Posted by Toxid on March 15, 2010 at 6:27pm
2 followers
Jump to:
| Project: | Table Wizard |
| Version: | 6.x-1.1 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
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
#1
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.
#2
#3
Automatically closed -- issue fixed for 2 weeks with no activity.