Answers.Body: <p>Instead of editing the database why not just override the value in the civicrm.settings.php file? </p>
  
  <p>Check you have </p>
  
  <pre><code>global $civicrm_setting;
  </code></pre>
  
  <p>Then add
      $civicrm_setting['URL Preferences']['userFrameworkResourceURL'] = '<a href="http://example.com/example-resource-url/" rel="nofollow noreferrer">http://example.com/example-resource-url/</a>';</p>
  
  <p>More information here on this
  <a href="https://docs.civicrm.org/sysadmin/en/latest/customize/settings/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/customize/settings/</a></p>
  
  <p>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.</p>
  
  <p>Best to make a back up of the database - or at the very least the table before changing it.</p>
  
  <p>Alternatively you might also be able to set this via the api: </p>
  
  <pre><code>cv api Setting.create userFrameworkResourceURL="resource url here" 
  </code></pre>
  
  <p>or </p>
  
  <pre><code>drush cvapi Setting.create userFrameworkResourceURL="resource url here"
  </code></pre>
  
  <p>depending on how broken your install is. Perhaps use Setting.get on dmaster via the api explorer to confirm what the appropriate format is: </p>
  
  <p><a href="https://dmaster.demo.civicrm.org/civicrm/api3#explorer" rel="nofollow noreferrer">https://dmaster.demo.civicrm.org/civicrm/api3#explorer</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-12T21:18:26.130Z
Answers.Text: 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.
Answers.UserDisplayName: Lesley Evensen
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-12T21:23:41.780Z
Answers.Text: It is set to civicrm_root in the  civicrm_setting table, just as it is shown in Resource_urls.
Answers.UserDisplayName: Lesley Evensen
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-12T00:37:16.447Z
Answers.LastActivityDate: 2020-01-12T00:37:16.447Z
Answers.UserDisplayName: Luke Stewart
Body: <p>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.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-14T04:32:44.893Z
Comments.Text: 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.
Comments.UserDisplayName: Luke Stewart
Tags: <civicrm-home>
Title: Is resource_url from civicrm_settings.php saved in the civicrm_setting table, under what name?
ThreadText: # Is resource_url from civicrm_settings.php saved in the civicrm_setting table, under what name?
  
  (Asked by: username_0 on 2020-01-11)
  
  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.
  
  **Tags:** civicrm-home
  
  > **Comments:**
  > **username_1**: 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.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-01-12. Score: 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
  
  > **Comments:**
  > **username_0**: 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.  
  > **username_0**: It is set to civicrm_root in the  civicrm_setting table, just as it is shown in Resource_urls.  
  
  ---
  
  