Duplicate menu items (multisite) and broken UI for Navigation Menu (standard)

[bcobin]

One of these issues is multisite and the other confirmed on demo (vanilla) site; I'm reporting both here in case they may be related.

1. I'm getting duplicate Civi Admin Menu items on one subsite out of about a dozen - rebuilding the menu, deleting template_c, clearing caches, rebuilding the menu - nothing works to remove the duplicates. For all the other sites on the network, the menu is fine - so this is really weird. (This is on 3.4.7.)

2. There's a problem with the UI for Administer > Customize Data and Screens > Navigation Menu  - /civicrm/admin/menu?reset=1 - you can't edit the links. I've confirmed this on the demo site on both Safari 5 and Firefox 3.6. (I'm on a Mac PowerPC, so these are the most recent browser versions that will work on my platform.)

Let me know if I should open a separate issue for #2, which is independent of multisite.

And ideas greatly appreciated... thanks!

[Eileen]

Re #1 - check your civicrm_navigation table - that is where it builds from. A common upgrade problem for multisites is that the parent_id refers to an entry with a different domain id (there is a JIRA issue open about this somewhere - if upgrading to 4.1 or 4.2 the patch will help https://github.com/fuzionnz/civicrm/commit/5dbfbb80a7e9dd8a6bdcf44d9aa88cd6fe683eee (4.3 no patch exists as yet AFAIK)

[bcobin]

Thank you, Eileen - that's a big help.

The cause of the problem may have been my initially forgetting to complete the multisite settings at /civicrm/admin/setting/preferences/multisite?reset=1 - oops. (Or perhaps not - see below.)

To try to fix it, I used phpMyAdmin, searching by domain ID and label and, indeed, found duplicate table entries for the top-line menu items. I then deleted the second of each, and the menu is now as it should be.

However...

The multisite settings for this domain now don't "stick" - I check Enable Multisite Configuration and set the parent group, etc. and apparently save successfully, but the settings aren't retained. Everything else seems to behave properly, AFAICT.

I'm assuming I probably deleted the wrong duplicate, but any insight would be appreciated. Mitigating factor is that out of all the domains on the system, I expect this one will be least likely to use Civi, but I'd still like to get it straight.

Thanks, Eileen, as always!

[Eileen]

Does it know which domain it's on? Checking domain address screen is helpful for that. You need to define the domain in civicrm_settings.php

[bcobin]

Oh yes, it definitely knows what domain it's on - things wouldn't work otherwise. Everything else seems to be fine, so far anyway. Hmmmm....

[Eileen]

have you looked in civicrm_settings table to see what's happening. I think I've seen cases where there are too many entries for a given setting in there (causing probs)

[bcobin]

You are a genius. (But you knew that!)

There were duplicate settings for the domain - one valid, one unset. I deleted the null versions and everything now looks as right as rain.

Note to self: Don't forget to set the Multi Site settings right away!

Thanks, Eileen - you're the best... woo hoo!

[Eileen]

are you working on 4.2? I have repackaged multisite as an extension for 4.3 but am making some changes

http://wiki.civicrm.org/confluence/display/CRMDOC43/Proposed+changes+to+multisite

[bcobin]

Yes - I'm still on 4.2. I believe I remember seeing some issues with multisite on 4.3, so I haven't made the jump yet.

I only recently discovered Extensions when I saw it on the admin menu - for some reason, it only appeared to me as an option recently. After setting the extensions directory for all domains, I activated Multisite 1.0 as I was doing "fit and finish" on user workflow last week - I think the only thing it will do is segregate Contacts per domain - is that right?

Thanks for all the work you've been doing here - marvelous...

[Eileen]

The published multisite is an exact port of the multisite module (well almost). The changes I'm looking at are only on our fuzion repo so far