Q: Sharing The Sequences Table Is Ignored

Events happening in the community are now at Drupal community events on www.drupal.org.

Posted by slayerment on September 23, 2007 at 2:39am

I am creating a new multisite domain that is going to be sharing users and nodes.

Right now I have it set to where my sequences table is shared in my $db_prefix array.

Despite having this set up to where it should be sharing, the sequences table is automatically putting a new row in my sequence table with the new site name (site2).

Rather than just pulling menu_mid and incrementing off that it is creating a new row called site2_menu_mid and incrementing off that.

Is there a way to fix this?

Thanks,
Quinton

Categories: multisite, sequences

Comments

add a prefix to main site

Posted by Michael Hofmockel on September 23, 2007 at 3:53am

Michael Hofmockel's picture

Sounds like one site is getting prefix and other is not. If you create prefixes for both sites it should solve your problem.

I think if you add a prefix to the first site it will solve your problem.

I'm setting up a multi- site right now. two sites - two databases - shared users.

settings.php from site one
$db_url = 'mysql://drupal:ilovedrupal@localhost/main';
$db_prefix = array(
'default' => 'main.',
);

Settings.php from site two
$db_url = 'mysql://drupal:ilovedrupal@localhost/test';
$db_prefix = array(
'default' => 'test.',
'access' => 'main.',
'authmap' => 'main.',
'filters' => 'main.',
'filter_formats' => 'main.',
'permission' => 'main.',
'role' => 'main.',
'sequences' => 'main.',
'sessions' => 'main.',
'users' => 'main.',
);

I am not sharing Menu table but if you add that to the second site prefix array, should work.

Regards,
Michael Hofmockel

Open Source || Open Access || Open Mind