"XML data could not be loaded" Exception error moving to different server SOLVED

[Sean Madsen]

I copy my whole site from my live server to my local machine and after visiting /civicrm I get the following error message with virtually no other page content:

Exception: XML data could not be loaded. Make sure you specified the correct path. in IDS_Filter_Storage->getFilterFromXML()

I have already tried the following (hopefully you get the idea with each of these, sorry to be somewhat vague):

• drush civicrm-cache-clear
• drush civicrm-update-cfg
• update civicrm_domain set config_backend = null;
• rm -rf sites/all/files/civicrm/templates_c/
• /index.php?q=civicrm/admin/setting/updateConfigBackend&reset=1 (and updated/saved settings)
• sudo chown -R www-data:www-data .
• sudo chmod -R a+rw .

As you can see, I have taken increasingly desperate steps to try solving this problem. I've tried the site copy many times over but I've really been beating my head against a wall here. I need to have this copy process run in a script so that I can do it easily. I'm using rsync to replicate the filesystem. Copying my live site to my local machine was a snap with 3.x, but now that I've upgraded to 4.x, I keep running in to this error each time I try. The Drupal side of my site works fine, just not Civi. I'm running CiviCRM 4.1.0 with Drupal 7.

Would love any advice! Really stuck here...

[Donald Lobo]

can u do:

rm -rf sites/all/files/civicrm/ConfigAndLog/

i suspect that will fix it

lobo

[Sean Madsen]

PRESTO!!!

rm -rf sites/all/files/civicrm/ConfigAndLog/

...did the trick!

I'd love to be able to issue one drush command after moving a server and have all this cached data/settings cleared out. Not a big deal right now, but just sayin'.

Thanks Lobo!

[Donald Lobo]

sean:

i think we are really really close to this We have all the pieces and we just need to stich them together and make it work!

wanna work on a drush command that collects all commands and does the right thing? get on IRC and we can get you started.

lobo

[secularaugust]

This helped me fix this problem on 4.0.5, but not only did I have to delete /files/civicrm/ConfigAndLog/ but also /files/civicrm/templates_c/en_US/ConfigAndLog.

(Now upgraded to 4.1.2 and very happy.)

[texvet_webmaster]

I had this problem and this was one of the first search results in Google. This half-fixed my problem, but it persisted in weird intermittent ways. After much searching, testing, and gashing of teeth, I found a full fix. I'm posting it here to help future searchers who come across this thread. (If you're a forum manager and you feel it's inappropriate for me to "resurrect" this thread in this way, I apologize. I sincerely believe that adding my notes here is the best step I can take to help the community. Feel free to delete or move this as you see fit.)

Renaming/removing "ConfigAndLog" took the issue from constant to intermittent. Additional research led me to:

http://opensourceecology.org/wiki/CiviCRM/tech_notes

...which says the following:

XML data could not be loaded
After moving CiviCRM from another host and updating some paths, I got this error [1]:
Fatal error: Uncaught exception 'Exception' with message 'XML data could not be loaded. Make sure you specified the correct path.' in [...] civicrm_invoke() #6 /home/a_user/site in /home/a_user/site/community/sites/all/modules/civicrm/packages/IDS/Filter/Storage.php on line 220
The solution is to delete or update the contents of the file {DRUPAL_HOME}/sites/default/files/civicrm/templates_c/en_US/ConfigAndLog/Config.IDS.ini to reflect the new paths.

Menus retaining old URLs
In order to rebuild menu URLs after changing the base URL [2], visit:
index.php?q=civicrm/menu/rebuild&reset=1
OR
civicrm/menu/rebuild?reset=1

Out of memory errors
You might need to update the civicrm_domain table like this:
update civicrm_domain set config_backend = null WHERE id = 1
-- OR --
TRUNCATE civicrm_domain;

Executing "update civicrm_domain set config_backend = null WHERE id = 1" on my database is what ultimately resolved the situation.

I hope this helps,

Jonathan L.