CiviCRM Community Forums (archive)

I have three CiviCRM sites that I look after (and have admin access to all of them) and when I try the URL.. /civicrm/admin/menu?reset=1 on any of them the page does not load properly.  Instead I get a screen per the attached screenshot.  The "Loading" box animates indefinitely, and it makes no difference which browser I use (I have Firefox 4.0.1 and IE 9.0).

All three sites are on the same server.
I am pretty sure that this feature used to work, so I wonder if this could be some weird configuration issue with the server that it is hosted on?  Is that possible?

Thanks
Mark

I am just about to upgrade to Drupal 6.22 and CiviCRM 3.4.2 and I will see if that fixes it.   
I want to upgrade CiviCRM for another reason, anyway.

I'll post here with the results that I get.

Mark   

If you do have this issue, or it returns, use Firebug for Firefox and look at the Net tab and often you can see what is failing to load that way.

I used your suggestion and used Firebug to investigate the cause of the error:

The only error detected by Firebug is on line 500 of the generated HTML page when the tree control is applying navigation settings loaded from the database.

Although I am sure that I followed the guides during my migration of CiviCRM from a subdomain to a sub-directory on https, I may have missed the impact of this change on the civicrm_preferences table; particularly the navigation field.

Due to every path and url setting being changed, the contents of the navigation field for each record contains invalid URLs. (There are other dependencies elsewhere but these are easier to fix)

Although this would probably be corrected by doing a 'clean re-install', and database migration, there is presently too much risk.

Can I safely 'edit' / 'export/import' the preferences table? (with backup of course)

Sorry about the late reply.

This did not work.

I also just noticed that when visiting the home page as an anonymous user, dashlets are visible but contain access denied pages rendered in each...!

Odd!

Solved! (still in maintenance mode though)

The errors in the previous posts' attachment was related to ACL records and permissions (and another problem running out of quota'd file system space)

I completely reconfigured the web server, checking Plesk's FastCGI/suExec configuration and wrote a script to ensure permissions are always correct. Also allowing .htaccess files to be read. A few changes for include paths.

Since the system was already broken, with backups in a safe place, I had nothing to lose (except 18hrs - and hair!)

• Emptied the Drupal database of all modules and caches ensuring NO references to CiviCRM!!!
• Deleted every customisation in Drupal, deleting the remaining directories for modules.
• Stripped the CiviCRM database of custom navigation entries and caches
• Emptied the ACL tables, and all references (groups, etc.)
• Cleared the cache_date for groups
• Emptied civicrm_uf_match
• Deleted non-default entries from the preferences tables
• Set the config_backend to NULL!
• Removed custom entries from option_values, including all custom reports (this is easily restored)
• Checked paths for custom files and directories
• Changed all links to images originally in the subdomain to the respective new path.
• Cleared the filesystem caches
• Restored ACL related data from the sql directory (I will have to redo all ACL again... :shrug:)
• Done a final check on related data, just in case I make it worse
• Enabled CiviCRM module in Drupal

I fixed a few Error 500's that were directly related to permissions, got CiviCRM displayed 
I turned on debugging and full mysql database logging (massive file!)

Still testing, adding, editing, deleting throughout CiviCRM.

I fixed the navigation menu that was still broken by referring to the Smarty cached php file:
<?php require_once(SMARTY_CORE_DIR . 'core.load_plugins.php');
smarty_core_load_plugins(array('plugins' => array(array('block', 'htxt', 'CRM/Admin/Page/Navigation.hlp', 26, false),array('block', 'ts', 'CRM/Admin/Page/Navigation.hlp', 28, false),)), $this); ?>and referencing the code in CRM/Admin/Page/Navigation.hlp:
    /**
     * Browse all menus
     */
     function browse(  ) {
         // assign home id to the template
         $homeMenuId = CRM_Core_DAO::getFieldValue( 'CRM_Core_DAO_Navigation', 'Home', 'id', 'name' );
         $this->assign( 'homeMenuId', $homeMenuId );
     }Noticed that I did not have the Home entry in the navigation table, added it by executing the following on the database:
INSERT INTO civicrm_navigation
 ( domain_id, label, name, url, permission, permission_operator, parent_id, is_active, has_separator, weight )
VALUES
 ( 1, 'Home', 'Home', 'civicrm/dashboard&reset=1', NULL, '', NULL, 1, NULL, 0);Viola! Navigation customisation now working.

In an earlier version of CiviCRM (3.1.3 =, I think), I removed the 'Home' item using the customise CiviCRM navigation page because I was using the CiviCRM index page as the home page for Drupal. Since then, this page has been broken.

Is this a bug? I have reproduced this by deleting the Home menu item again, fixed by reinserting the SQL. (using 3.3.5). I don't want to break your testing area by testing if it still exists...

----- Update:

Testing in CiviCRM checks out with no errors on any create, edit, delete.
A few problems re-enabling the CiviCRM Roles Sync module where, first the table already exists, then when it doesn't. Turns out that I 'forgot' to update mysql privileges after re-configuring MySQL

Getting a few errors in the file system - permissions and options directives! Better keep an eye on it.

----- Update:

On track to migrate this very strange install into a clean CiviCRM, this should get rid of all errors... (1am here; be 5am before I finish)

Closing this post...

repostor, do you see any errors? Look with Firebug in Firefox for JS errors.