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
Comments
add a prefix to main site
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
Ah, right now I have my main
Ah, right now I have my main site using no prefix, I will try that out and let you know.
Appreciate the response :).
It appears as though the
It appears as though the reason this was happening is because my menu table was not shared. Thanks for the help :).