Community & Support

Mulitsite with shared database Problem

I am currently trying to run a multi site with a shared database. I have one database setup for all the shared information for the sites and then each site has their own database with all the tables unique to that site. I have the content fields setup to be on the shared database and have both websites set up in the setting.php to access those fields. All of the information currently is pulled from the two databases and is fine. The problem arises when content is added.

The desired action is that content is added and because it is on a shared database it will automatically be added to the other site that it was not created through. This isn't happening. Error messages are coming up such as:

-warning: Invalid argument supplied for foreach() in /var/www/[website]/sites/all/modules/cck/content.module on line 1022.
-warning: Invalid argument supplied for foreach() in /var/www/[website]/modules/taxonomy/taxonomy.module on line 1241.

The following are the tables that have been added to the shared database:
authmap
blocks
comments
content_group
content_group_fields
content_node_field
content_node_field_instance
content_type_ad
content_type_article
facebook_status
facebook_status_tags
fckeditor_role
fckeditor_settings
files
filters
filter_formats
forum
history
image
imagecache_action
imagecache_preset
image_attach
imce_files
invite
invite_notifications
node
node_type
permission
profile_fields
profile_values
role
sessions
term_data
term_hierarchy
term_node
term_relation
term_synonym
tvi_settings
users
users_roles
user_relationships
user_relationship_blocks
user_relationship_elaborations
user_relationship_invites
user_relationship_types
user_relationship_type_roles
user_relationship_type_roles_receive
vocabulary
votingapi_cache
votingapi_vote

All help is EXTREMELY appreciated!

Comments

Use this patch and it will be

Use this patch and it will be fixed: http://drupal.org/files/issues/mysql.multisitefix-D6.patch

After applying the patch, though, make sure you clean out the cache.

nobody click here