Sequence Table Issues

Hello,

I'm not quite sure I followed that, so let me try to recap: You have multiple drupal installs sharing a database and recently switched your sequences table to be shared across the sites and installed FierceSSO. And now you're having problems adding menu items... right?

This isn't a problem with this module per se, but with how Drupal uses the sequences table. It has to work this way -- how else would it tell which sequence number references the menu id for sitea versus siteb?

How did you create shared_sequences in the first place? Did you just rename the table from one of the sites? If you've still got the old tables laying around, a quick bit of SQL magic should be able to automatically append the proper prefix onto the entries. (Or you could just go through the table by hand -- I doubt there are many rows)

Eli

So just to be 100% clear, the items in the original sequence table did not have any prefix, right? (That is, it just looked like "menu_cid" not "something_menu_cid")

Well, how comfortable are you with SQL? If you open up your database using the mysql command line client or phpMySQL and enter the following two commands (replacing the prefix and table names with your names)... Don't forget to back up your database first!

replace into shared_sequences (select concat('siteone_',name),id from siteone_sequences);
replace into shared_sequences (select concat('sitetwo_',name),id from sitetwo_sequences);

it should populate the shared sequences table properly (possibly blowing away whatever values are in there currently).

If after doing that you still have errors about duplicate IDs (which would happen if you created new content since merging the tables the first time), here's a little SQL hack:

update shared_sequences set id = id + 100;

That just skips 100 values for each of the sequences.

Cheers,
Eli

Well, you might want to consider starting the merge over again at this point, if you haven't added much.

But this should fix the table for you:

update shared_sequences set name = concat('site1_',name) where name not like 'site2\_%';

And then I'd throw in:

update shared_sequences set id = id + 100;

for good measure

Are you sure you ran this?

update shared_sequences set id = id + 100;

If it's still a problem, I think you'll get better help opening an issue in the Drupal support forum or posting on the Multisite Drupal group. It's not an issue with this module, and I'm about out of ideas.

Eli