Answers.Body: <p>The issue was due to the missing field "frontend_title" in "civicrm_uf_group" (mentioned in the DB error message"). To fix the issue I did drop the table and recreated it. No more JS error after that.
  Special thanks to @Jon G. for his follow-up, however : I could not access the APIv3 from civicrm (it uses JS and wasn't showing up due to the error), I don't know how to use CommandLine. By the way, the APIv3 is now accessible but once "system" is selected for "entity", the choice "rebuildmultilingualschema" for "action" is not proposed; maybe due to the fact that multilingual civicrm is not used on our domain.
  Thanks again, best regards</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-29T14:54:36.343Z
Answers.Text: Seems that this was related to this issue https://github.com/civicrm/civicrm-core/pull/11508  / but in civicrm files package wp-content\plugins\civicrm\civicrm\CRM\Upgrade\Incremental\sql I can't see any "alter table" request to add the "frontend_title" field in civicrm_uf_group table in the 4.7.31.mysql.tpl nor 4.7.32.mysql.tpl files ... managed somewhere else maybe, or forgotten...
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-31T11:50:23.500Z
Answers.Text: Fix the issues of icons not loading and ajax search not working / ALTER TABLE `civicrm_uf_group` ADD  `frontend_title` VARCHAR(64) NULL DEFAULT NULL COMMENT 'Profile Form Public title';
  
  ALTER TABLE `civicrm_uf_group` ADD  `add_cancel_button` TINYINT(4) NULL DEFAULT '1' COMMENT 'Should a Cancel button be included in this Profile form.';
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-29T14:44:50.130Z
Answers.LastActivityDate: 2018-04-29T14:44:50.130Z
Answers.UserDisplayName: ITSupport ERELOS
Answers.Body: <p>I can see the problem (I saw this myself recently), but I don't have a 100% answer.  <strong>However, the solution is usually to rebuild your multilingual schema.</strong></p>
  
  <p>This problem is characterized by:</p>
  
  <ul>
  <li>Multilingual mode is activated on your CiviCRM site.</li>
  <li>Error in the browser console show files not found at a path with the word "undefined" in it.</li>
  <li>Also, "DB Error: no such field" errors (though this can also be caused by missing extensions or failing to upgrade the database after upgrading the CiviCRM files).</li>
  </ul>
  
  <p>Based on <a href="https://gist.github.com/mlutfy/647e6325a09079e4f08f273af64900d9" rel="nofollow noreferrer">these instructions</a>, here's how you rebuild the multilingual schema:</p>
  
  <h3>From within CiviCRM (CiviCRM 5.1+ only):</h3>
  
  <ul>
  <li>Go to <strong>Support menu » Developer » API Explorer</strong>.</li>
  <li>Set <em>Entity</em> to <strong>System</strong> and <em>Action</em> to <strong>rebuildmultilingualschema</strong>.</li>
  <li>Press the <strong>Execute</strong> button.</li>
  </ul>
  
  <h3>From the command line (Civi 5.0.1 and earlier):</h3>
  
  <p><strong>Drupal 7</strong></p>
  
  <p><code>drush php-eval 'civicrm_initialize(); CRM_Core_I18n_Schema::rebuildMultilingualSchema(["en_US","fr_CA"], NULL);'</code></p>
  
  <p><strong>Drupal 8</strong></p>
  
  <p><code>drush php-eval '\Drupal::service('civicrm')-&gt;initialize(); CRM_Core_I18n_Schema::rebuildMultilingualSchema(["en_US","fr_CA"], NULL);'</code></p>
  
  <p><strong>WordPress</strong> </p>
  
  <p><code>wp eval 'civicrm_initialize(); CRM_Core_I18n_Schema::rebuildMultilingualSchema(["en_US","fr_CA"], NULL);'</code></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-15T08:04:22.863Z
Answers.Text: Hello, thanks for yr reply. I've checked the page linked to admin.php?page=Civic and here are the details : https://we.tl/Qhz1gPvzXv - I don't know where to check in this page. I've disabled all WP plugin one by one, and change the template, the error is still there. Any help would be very appreciated.
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-16T04:04:11.763Z
Answers.Text: Is this a multilingual site? There have been some issues on chat about needing to rebuild the schema after upgrade - those DB errors look suspicious
  
  https://github.com/civicrm/civicrm-core/pull/11967
Answers.UserDisplayName: user4278
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-16T06:08:28.723Z
Answers.Text: Thanks for the feedback. We use civicrm in French only, I've kept the en-GB and fr-fr language from the l10n package. Any other idea ?
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-16T12:38:05.250Z
Answers.Text: I've seen something similar.  Can you load the "System Status" page or does it never load the dynamic (Angular) portion?  Do your Administration menu items have broken link pictures?  I had to disable logging, disable Multilingual, enable logging, disable logging, re-enable Multilingual, re-enable logging.  I'm not sure what information you will loose when you disable Multilingual, but there is a warning.
Answers.UserDisplayName: G H
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-17T04:42:28.757Z
Answers.Text: Hello Jon, yes system status is broken, broken links pictures in menu. I cannot open the 2nd page of the configuration checklist 'Address and localization of the contact" -> "CiviCRM_API3_Exception: "DB Error: no such field" (see details here: https://we.tl/TANn6ZbCYk") Logging was not enable, neither multilanguage (only use French) / do you think a further update of civicrm will fix the issue ? this is very impacting : cannot create user, event... all pages with ajax are fully or partialy broken. Thanks
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-17T04:46:29.860Z
Answers.Text: This "undefinedpackages" seems strange : as if a path variable wasn't properly defined causing the GET to fail : GET https://mysite.org/wp-admin/undefinedpackages/jquery/css/images/arrow.png 404 (Not Found)
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-18T11:35:40.937Z
Answers.Text: The DB error is a strong indicator, but you need to find the full error message. It should be in the log files found under the "ConfigAndLog" directory.
Answers.UserDisplayName: bgm
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-21T17:42:58.297Z
Answers.Text: Hello @bgm - I've updated to 5.0.1 run SQL update, everything went well but still have same issues. Therefore I collected the log from "ConfigAndLog" and here are the latest record : https://we.tl/bCoR0FGqJs - an error is coming back since I've the issue : [nativecode=1054 ** Unknown column 'a.frontend_title' in 'field list']. I've checked the civicrm_uf_group table and indeed didn't find it, is there a way to correct that ? Any help will appreciated, we really stuck here. Thanks
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-25T04:57:58.520Z
Answers.Text: Hello anyone could help. We've been blocked for 2 weeks now, this really impacting. Thanks
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-25T15:05:22.707Z
Answers.Text: @ITSupportERELOS Did you rebuild multilingual schema as was suggested?  I'll edit my answer to include that.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-26T17:47:46.283Z
Answers.Text: Hello. Unfortunately my technical level is not sufficient to do it using apis. Any SQL request that I could use to rebuild the table ? Thanks
Answers.UserDisplayName: ITSupport ERELOS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-26T23:04:50.457Z
Answers.Text: @ITSupportERELOS The SQL would be far too complicated.  Are you able to use the command line option above?
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-14T22:59:53.630Z
Answers.LastActivityDate: 2018-04-25T15:14:42.357Z
Answers.LastEditDate: 2018-04-25T15:14:42.357Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I've updated from 4.7.29 to 5.0.0
  The SQL update went well, but I've issues with JS/Pictures not loading.
  This is really blocking as for example, the &quot;Create new contact&quot; is not loading
  See screenshots below.
  Could you please advise ?
  Thanks</p>
  <p><a href="https://i.sstatic.net/JLBjK.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/JLBjK.png" alt="enter image description here" /></a>
  <a href="https://i.sstatic.net/MjV4x.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/MjV4x.png" alt="enter image description here" /></a>
  <a href="https://i.sstatic.net/rKlJy.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/rKlJy.png" alt="enter image description here" /></a>
  <a href="https://i.sstatic.net/w6H8i.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/w6H8i.png" alt="enter image description here" /></a>
  <a href="https://i.sstatic.net/4iQAH.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/4iQAH.png" alt="enter image description here" /></a></p>
  <blockquote>
  <p>Error at &quot;Create new user page&quot;</p>
  </blockquote>
  <p>CiviCRM_API3_Exception: &quot;DB Error: no such field&quot;</p>
  <h1>0 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/UFGroup.php(3341): civicrm_api3(&quot;uf_group&quot;, &quot;get&quot;, (Array:3))</h1>
  <h1>1 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Edit/Address.php(226): CRM_Core_BAO_UFGroup::getCreateLinks((Array:3), &quot;shared_address&quot;)</h1>
  <h1>2 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Location.php(107): CRM_Contact_Form_Edit_Address::buildQuickForm(Object(CRM_Contact_Form_Contact))</h1>
  <p>...</p>
  
Tags: <wordpress><javascript><ajax>
Title: Wordpress Ajax & pictures not loading after upgrade to 5.0
ThreadText: # Wordpress Ajax & pictures not loading after upgrade to 5.0
  
  (Asked by: username_0 on 2018-04-14)
  
  I've updated from 4.7.29 to 5.0.0
  The SQL update went well, but I've issues with JS/Pictures not loading.
  This is really blocking as for example, the "Create new contact" is not loading
  See screenshots below.
  Could you please advise ?
  Thanks
  
  [![enter image description here](https://i.sstatic.net/JLBjK.png)](https://i.sstatic.net/JLBjK.png)
  [![enter image description here](https://i.sstatic.net/MjV4x.png)](https://i.sstatic.net/MjV4x.png)
  [![enter image description here](https://i.sstatic.net/rKlJy.png)](https://i.sstatic.net/rKlJy.png)
  [![enter image description here](https://i.sstatic.net/w6H8i.png)](https://i.sstatic.net/w6H8i.png)
  [![enter image description here](https://i.sstatic.net/4iQAH.png)](https://i.sstatic.net/4iQAH.png)
  
  > Error at "Create new user page"
  
  CiviCRM\_API3\_Exception: "DB Error: no such field"
  
  # 0 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/UFGroup.php(3341): civicrm\_api3("uf\_group", "get", (Array:3))
  
  # 1 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Edit/Address.php(226): CRM\_Core\_BAO\_UFGroup::getCreateLinks((Array:3), "shared\_address")
  
  # 2 /var/www/html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Location.php(107): CRM\_Contact\_Form\_Edit\_Address::buildQuickForm(Object(CRM\_Contact\_Form\_Contact))
  
  ...
  
  **Tags:** wordpress, javascript, ajax
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2018-04-29. Score: 0 | Accepted answer
  
  The issue was due to the missing field "frontend\_title" in "civicrm\_uf\_group" (mentioned in the DB error message"). To fix the issue I did drop the table and recreated it. No more JS error after that.
  Special thanks to @Jon G. for his follow-up, however : I could not access the APIv3 from civicrm (it uses JS and wasn't showing up due to the error), I don't know how to use CommandLine. By the way, the APIv3 is now accessible but once "system" is selected for "entity", the choice "rebuildmultilingualschema" for "action" is not proposed; maybe due to the fact that multilingual civicrm is not used on our domain.
  Thanks again, best regards
  
  > **Comments:**
  > **username_0**: Seems that this was related to this issue https://github.com/civicrm/civicrm-core/pull/11508  / but in civicrm files package wp-content\plugins\civicrm\civicrm\CRM\Upgrade\Incremental\sql I can't see any "alter table" request to add the "frontend_title" field in civicrm_uf_group table in the 4.7.31.mysql.tpl nor 4.7.32.mysql.tpl files ... managed somewhere else maybe, or forgotten...  
  > **username_0**: Fix the issues of icons not loading and ajax search not working / ALTER TABLE `civicrm_uf_group` ADD  `frontend_title` VARCHAR(64) NULL DEFAULT NULL COMMENT 'Profile Form Public title';  ALTER TABLE `civicrm_uf_group` ADD  `add_cancel_button` TINYINT(4) NULL DEFAULT '1' COMMENT 'Should a Cancel button be included in this Profile form.';  
  
  ---
  
  ### Answer by username_1 on 2018-04-14. Score: 2
  
  I can see the problem (I saw this myself recently), but I don't have a 100% answer. **However, the solution is usually to rebuild your multilingual schema.**
  
  This problem is characterized by:
  
  * Multilingual mode is activated on your CiviCRM site.
  * Error in the browser console show files not found at a path with the word "undefined" in it.
  * Also, "DB Error: no such field" errors (though this can also be caused by missing extensions or failing to upgrade the database after upgrading the CiviCRM files).
  
  Based on [these instructions](https://gist.github.com/mlutfy/647e6325a09079e4f08f273af64900d9), here's how you rebuild the multilingual schema:
  
  ### From within CiviCRM (CiviCRM 5.1+ only):
  
  * Go to **Support menu » Developer » API Explorer**.
  * Set *Entity* to **System** and *Action* to **rebuildmultilingualschema**.
  * Press the **Execute** button.
  
  ### From the command line (Civi 5.0.1 and earlier):
  
  **Drupal 7**
  
  `drush php-eval 'civicrm_initialize(); CRM_Core_I18n_Schema::rebuildMultilingualSchema(["en_US","fr_CA"], NULL);'`
  
  **Drupal 8**
  
  `drush php-eval '\Drupal::service('civicrm')->initialize(); CRM_Core_I18n_Schema::rebuildMultilingualSchema(["en_US","fr_CA"], NULL);'`
  
  **WordPress**
  
  `wp eval 'civicrm_initialize(); CRM_Core_I18n_Schema::rebuildMultilingualSchema(["en_US","fr_CA"], NULL);'`
  
  > **Comments:**
  > **username_0**: Hello, thanks for yr reply. I've checked the page linked to admin.php?page=Civic and here are the details : https://we.tl/Qhz1gPvzXv - I don't know where to check in this page. I've disabled all WP plugin one by one, and change the template, the error is still there. Any help would be very appreciated.  
  > **username_2**: Is this a multilingual site? There have been some issues on chat about needing to rebuild the schema after upgrade - those DB errors look suspicious  https://github.com/civicrm/civicrm-core/pull/11967  
  > **username_0**: Thanks for the feedback. We use civicrm in French only, I've kept the en-GB and fr-fr language from the l10n package. Any other idea ?  
  > **username_3**: I've seen something similar.  Can you load the "System Status" page or does it never load the dynamic (Angular) portion?  Do your Administration menu items have broken link pictures?  I had to disable logging, disable Multilingual, enable logging, disable logging, re-enable Multilingual, re-enable logging.  I'm not sure what information you will loose when you disable Multilingual, but there is a warning.  
  > **username_0**: Hello Jon, yes system status is broken, broken links pictures in menu. I cannot open the 2nd page of the configuration checklist 'Address and localization of the contact" -> "CiviCRM_API3_Exception: "DB Error: no such field" (see details here: https://we.tl/TANn6ZbCYk") Logging was not enable, neither multilanguage (only use French) / do you think a further update of civicrm will fix the issue ? this is very impacting : cannot create user, event... all pages with ajax are fully or partialy broken. Thanks  
  > **username_0**: This "undefinedpackages" seems strange : as if a path variable wasn't properly defined causing the GET to fail : GET https://mysite.org/wp-admin/undefinedpackages/jquery/css/images/arrow.png 404 (Not Found)  
  > **username_4**: The DB error is a strong indicator, but you need to find the full error message. It should be in the log files found under the "ConfigAndLog" directory.  
  > **username_0**: Hello @username_4 - I've updated to 5.0.1 run SQL update, everything went well but still have same issues. Therefore I collected the log from "ConfigAndLog" and here are the latest record : https://we.tl/bCoR0FGqJs - an error is coming back since I've the issue : [nativecode=1054 ** Unknown column 'a.frontend_title' in 'field list']. I've checked the civicrm_uf_group table and indeed didn't find it, is there a way to correct that ? Any help will appreciated, we really stuck here. Thanks  
  > **username_0**: Hello anyone could help. We've been blocked for 2 weeks now, this really impacting. Thanks  
  > **username_1**: @username_0 Did you rebuild multilingual schema as was suggested?  I'll edit my answer to include that.  
  > **username_0**: Hello. Unfortunately my technical level is not sufficient to do it using apis. Any SQL request that I could use to rebuild the table ? Thanks  
  > **username_1**: @username_0 The SQL would be far too complicated.  Are you able to use the command line option above?  
  
  ---
  
  