When there are multiple databases defined in settings.php the data migration does not work.

I had the following settings:

$db_url['default'] = 'mysql://drupal_user:changeme@localhost/drupal';
$db_url['xxx'] = 'mysql://xxx_user:changeme@localhost/xxx';
$db_prefix = array('default' => '');

And it looked like the drupal DB name was 'Array' instead of 'drupal'.

Comments

liam mcdermott’s picture

liam mcdermott commented

Sounds like a bug, don't think I accounted for this. Thanks for the report. :)

liam mcdermott’s picture

liam mcdermott commented

Marking #307149: Table 'Array.users_signature' doesn't exist query: INSERT IGNORE INTO Array.users_signature... as duplicate (has useful information for testing)

cyberswat’s picture

cyberswat commented
Version: 5.x-1.0 » 6.x-1.0-rc1
ManyNancy’s picture

ManyNancy commented

Has this been fixed yet?

tranquille’s picture

tranquille commented

I get the same error with my multisite setup of Drupal 6.16.
Sub-Sites work via path - www.maindomain.com/sub1.
Several user-related tables are shared - the main-site is working just fine.
Errors are thrown within _db_query (mysqli.inc.php or mysql.inc.php - line 141); error messages look like
'INSERT INTO Arraysemaphore...' respectively the error message error:Table 'db.arraysemaphore' doesn't exist

sorry! posted in the wrong place - general drupal issue and solved.

liam mcdermott’s picture

liam mcdermott commented
Title: Migration does not work with multiple databases defined in settings.php » Migration failing with multiple databases defined in settings.php
Version: 6.x-1.0-rc1 » 6.x-1.x-dev
Status: Active » Fixed

This should be fixed. Please test in the dev version and re-open this bug if the problem is not resolved. Thank you and sorry it's taken so long to get to this bug.

Status: Fixed » Closed (fixed)

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