shared_ tables creating error messages

ISchier770 - December 22, 2008 - 16:30

BS"D

I created 2 sites using one database so as to be able to use single sign-on (Fierce SSO). One site had been up and running for some time and has quite a bit of content; the other one is newer and needs to use the user table from the older site.

I edited the Settings.php to include the following:

$db_prefix = array(
'default' => '',
'authmap' => 'shared_',
'profile_fields' => 'shared_',
'profile_values' => 'shared_',
'role' => 'shared_',
'sequences' => 'shared_',
'users' => 'shared_',
'users_uid_seq' => 'shared_',
);

When I try to create content on either site I get error messages such as (for an FAQ):

* user warning: Unknown column 'name' in 'where clause' query: SELECT id FROM shared_sequences WHERE name = 'node_nid' in /home/cybfirmc/domains/millionwordimension.com/includes/database.mysql.inc on line 174.
* user warning: Unknown column 'name' in 'where clause' query: SELECT id FROM shared_sequences WHERE name = 'node_revisions_vid' in /home/cybfirmc/domains/millionwordimension.com/includes/database.mysql.inc on line 174.
* user warning: Duplicate entry '1-1' for key 1 query: INSERT INTO node (nid, vid, title, type, uid, status, created, changed, comment, promote, sticky) VALUES (1, 1, '

Test

', 'faq', 1, 1, 1229963550, 1229963563, 2, 1, 0) in /home/cybfirmc/domains/millionwordimension.com/includes/database.mysql.inc on line 174.
* user warning: Duplicate entry '1' for key 1 query: INSERT INTO node_revisions (nid, vid, title, body, teaser, timestamp, uid, format, log) VALUES (1, 1, '

Test

', '

Test

', '

Test

', 1229963563, 1, 3, '') in /home/cybfirmc/domains/millionwordimension.com/includes/database.mysql.inc on line 174.
* user warning: Duplicate entry '1' for key 1 query: INSERT INTO node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (1, 1229963563, NULL, 1, 0) in /home/cybfirmc/domains/millionwordimension.com/includes/database.mysql.inc on line 174.

What do I need to do with my shared_ tables, and particularly the shared_sequences table, to get my sites working again? Alternately, is there another way to share the users table without dealing with the shared_ table? (I do not have the privileges necessary on my hosting server for a multisite installation).

Thanks, IS.

 
 

Drupal is a registered trademark of Dries Buytaert.