0

Where in civicrm_settings table is resource_url saved? I cannot use the System Settings/Resource URLs to set it, but can access the database.

  • Are you seeing the arrows in the menu? Or is civicrm broken? (I've seen problems with false positives on the warning about resource url being incorrect.) The civicrm_root value should be set in your civicrm.settings.php. – Luke Stewart Jan 14 at 4:32
1

Instead of editing the database why not just override the value in the civicrm.settings.php file?

Check you have

global $civicrm_setting;

Then add $civicrm_setting['URL Preferences']['userFrameworkResourceURL'] = 'http://example.com/example-resource-url/';

More information here on this https://docs.civicrm.org/sysadmin/en/latest/customize/settings/

If you do want to update this directly in the database try the civicrm_setting table you want to search for a name of "userFrameworkResourceURL" and update the value column.

Best to make a back up of the database - or at the very least the table before changing it.

Alternatively you might also be able to set this via the api:

cv api Setting.create userFrameworkResourceURL="resource url here" 

or

drush cvapi Setting.create userFrameworkResourceURL="resource url here"

depending on how broken your install is. Perhaps use Setting.get on dmaster via the api explorer to confirm what the appropriate format is:

https://dmaster.demo.civicrm.org/civicrm/api3#explorer

  • thanks, Luke - the value is set in civicrm_settings, however it isn't reflected in Systems/Resource_urls. Someone make a change to the actual website url and havoc ensured. ..thanks for your suggestions. – Lesley Evensen Jan 12 at 21:18
  • It is set to civicrm_root in the civicrm_setting table, just as it is shown in Resource_urls. – Lesley Evensen Jan 12 at 21:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.