Answers.Body: <p>I finally resolved it by upgrading to 5.6.0, although it was a bit of a journey.
  First I tried the solution in #6, but I found there were even more fields missing, having done a fresh installation of 5.5.3 and compared the columns in the civicrm_uf_group table: title, frontend_title, help_pre, help_post, cancel_button_text, submit_button_text</p>
  
  <p>I was still getting the error, and the log table was showing that the error was on a view of this table <code>civicrm_uf_group_en_US</code>
  So I assumed that now CiviCRM creates views of tables, which are not affected by changing table structure alone. Not sure if this is a new thing or if only for languages.  The site had been configured for only English US, but was selected as if it was a language.  Tried to change it to be language neutral. Not sure it made a difference.</p>
  
  <p>Regardless, it seems that upgrading rebuilt the views, and problem solved.
  Perhaps with hindsight I could have found a way just to modify the view without needing to upgrade.</p>
  
  <p>Hope this helps someone.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-09T21:54:23.470Z
Answers.LastActivityDate: 2018-10-09T21:54:23.470Z
Answers.UserDisplayName: MickC
Answers.Body: <p>Is the site configured for multi-lingual? If so then it might be an error with schema rebuild. Can you try rebuilding the schema using api explorer or drush?</p>
  
  <p>Ref: <a href="https://civicrm.stackexchange.com/a/25890/155">https://civicrm.stackexchange.com/a/25890/155</a></p>
  
  <p>Or You will need to manually add the 'frontend_title' field to the table by running below sql query.</p>
  
  <pre><code>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.';
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-13T17:16:02.043Z
Answers.Text: No, it isn't configured as multi-lingual. I tried doing the solutions on that page just in case, but I see no changes.
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-13T17:53:10.847Z
Answers.Text: Ok did some research. Strangely, a lot of the symptoms associated with the multi-lingual issues are similar here (blank page, no such field, undefined packages url).  The API explorer won't let me choose "System.rebuildmultilingualschema" because the wheel continues to spin. I also don't have access to use drush.
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-13T18:06:25.943Z
Answers.Text: Try using rest api url to run the schema rebuild
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T08:49:45.970Z
Answers.Text: What does your webserver log say? And what about the civicrm log file? Any indication of an error message? If nothing shows up you could possibly enable debug mode at: http://yoursite/civicrm/admin/settings/debug?reset=1
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T15:58:20.427Z
Answers.Text: I updated the original post with all my errors, including my civicrm log file.
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T16:06:14.667Z
Answers.Text: Kristine you will need to the rebuildschema as this a known bug as I mentioned in my answer. (Proof: https://github.com/civicrm/civicrm-core/pull/12636)
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T16:11:18.277Z
Answers.Text: Or you will need to manually add this column through mysql
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T16:14:48.707Z
Answers.Text: I have updated my answer.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T16:37:54.943Z
Answers.Text: I did the sql query. Uploaded the file, SchemaStructure_5_4_alpha1.php just in case. Flushed the cache, no changes. I see that the console is not able to load the 'jquery.crmAjaxTable.js' still.
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T16:39:32.713Z
Answers.Text: Can you check more errors in CiviCRM logs
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T16:53:10.700Z
Answers.Text: I updated the log again from above, but it seems like the same log. It keeps looking for the JS files under undefinedpackages/jquery/. I don't think its the Resource URL issue though. I even copied the database to another server and the paths are correct.
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-14T16:53:34.917Z
Answers.Text: Let us [continue this discussion in chat](https://chat.stackexchange.com/rooms/81650/discussion-between-kristine-and-pradeep-nayak).
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-13T09:36:19.300Z
Answers.LastActivityDate: 2018-08-14T18:01:51.930Z
Answers.LastEditDate: 2018-08-14T18:01:51.930Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I'm on Drupal 7 CiviCRM 5.2.0. I've updated to 5.4.0 and received no errors. However, I started seeing that icons on the civimenu are not showing. When I lookup a contact, everything seems fine, but then my custom fields in each tabs are not showing (even though the count number is still there, e.g., Relationships 5). Very strange.</p>
  
  <p>I also checked the Resource URLs, cleared caches and update paths, cleared Drupal cache, and nothing is working. Is there something I'm missing? </p>
  
  <p>Tracking of All Errors</p>
  
  <pre><code>Uncaught SyntaxError: Unexpected token &lt;
  view?reset=1&amp;cid=963:1 Refused to execute script from '[domain]/civicrm/contact/undefinedbower_components/jstree/dist/jstree.min.js' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
  view?reset=1&amp;cid=963:1 Refused to execute script from '[domain]/civicrm/contact/undefinedjs/jquery/jquery.crmAjaxTable.js' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
  
  $Fatal Error Details = array(3) { ["message"]=&gt; string(23) "DB Error: no such field" ["code"]=&gt; NULL ["exception"]=&gt; object(CiviCRM_API3_Exception)#231 (8) { ["extraParams":"CiviCRM_API3_Exception":private]=&gt; array(6) { ["error_code"]=&gt; string(13) "no such field" ["sql"]=&gt; string(1093) "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`, a.title as `title`, a.frontend_title as `frontend_title`, a.description as `description`, a.help_pre as `help_pre`, a.help_post as `help_post`, a.limit_listings_group_id as `limit_listings_group_id`, a.post_URL as `post_URL`, a.add_to_group_id as `add_to_group_id`, a.add_captcha as `add_captcha`, a.is_map as `is_map`, a.is_edit_link as `is_edit_link`, a.is_uf_link as `is_uf_link`, a.is_update_dupe as `is_update_dupe`, a.cancel_URL as `cancel_URL`, a.is_cms_user as `is_cms_user`, a.notify as `notify`, a.is_reserved as `is_reserved`, a.name as `name`, a.created_id as `created_id`, a.created_date as `created_date`, a.is_proximity_search as `is_proximity_search`, a.cancel_button_text as `cancel_button_text`, a.submit_button_text as `submit_button_text`, a.add_cancel_button as `add_cancel_button` FROM civicrm_uf_group a WHERE (a.name IN ("new_individual", "new_organization", "new_household")) AND (a.is_active = "1") LIMIT 25 OFFSET 0 [nativecode=1054 ** Unknown column 'a.frontend_title' in 'field list']" ["tip"]=&gt; string(62) "add debug=1 to your API call to have more info about the error" ["is_error"]=&gt; int(1) ["error_message"]=&gt; string(23) "DB Error: no such field" ["debug_information"]=&gt; string(1093) "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`, a.title as `title`, a.frontend_title as `frontend_title`, a.description as `description`, a.help_pre as `help_pre`, a.help_post as `help_post`, a.limit_listings_group_id as `limit_listings_group_id`, a.post_URL as `post_URL`, a.add_to_group_id as `add_to_group_id`, a.add_captcha as `add_captcha`, a.is_map as `is_map`, a.is_edit_link as `is_edit_link`, a.is_uf_link as `is_uf_link`, a.is_update_dupe as `is_update_dupe`, a.cancel_URL as `cancel_URL`, a.is_cms_user as `is_cms_user`, a.notify as `notify`, a.is_reserved as `is_reserved`, a.name as `name`, a.created_id as `created_id`, a.created_date as `created_date`, a.is_proximity_search as `is_proximity_search`, a.cancel_button_text as `cancel_button_text`, a.submit_button_text as `submit_button_text`, a.add_cancel_button as `add_cancel_button` FROM civicrm_uf_group a WHERE (a.name IN ("new_individual", "new_organization", "new_household")) AND (a.is_active = "1") LIMIT 25 OFFSET 0 [nativecode=1054 ** Unknown column 'a.frontend_title' in 'field list']" } ["message":protected]=&gt; string(23) "DB Error: no such field" ["string":"Exception":private]=&gt; string(0) "" ["code":protected]=&gt; int(0) ["file":protected]=&gt; string(64) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/api/api.php" ["line":protected]=&gt; int(45) ["trace":"Exception":private]=&gt; array(10) { [0]=&gt; array(4) { ["file"]=&gt; string(77) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php" ["line"]=&gt; int(3340) ["function"]=&gt; string(12) "civicrm_api3" ["args"]=&gt; array(3) { [0]=&gt; &amp;string(8) "uf_group" [1]=&gt; &amp;string(3) "get" [2]=&gt; &amp;array(2) { ["name"]=&gt; array(1) { ["IN"]=&gt; array(3) { [0]=&gt; string(14) "new_individual" [1]=&gt; string(16) "new_organization" [2]=&gt; string(13) "new_household" } } ["is_active"]=&gt; int(1) } } } [1]=&gt; array(6) { ["file"]=&gt; string(75) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Resources.php" ["line"]=&gt; int(689) ["function"]=&gt; string(14) "getCreateLinks" ["class"]=&gt; string(20) "CRM_Core_BAO_UFGroup" ["type"]=&gt; string(2) "::" ["args"]=&gt; array(0) { } } [2]=&gt; array(4) { ["function"]=&gt; string(20) "outputLocalizationJS" ["class"]=&gt; string(18) "CRM_Core_Resources" ["type"]=&gt; string(2) "::" ["args"]=&gt; array(0) { } } [3]=&gt; array(4) { ["file"]=&gt; string(72) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=&gt; int(275) ["function"]=&gt; string(14) "call_user_func" ["args"]=&gt; array(1) { [0]=&gt; &amp;array(2) { [0]=&gt; string(18) "CRM_Core_Resources" [1]=&gt; string(20) "outputLocalizationJS" } } } [4]=&gt; array(6) { ["file"]=&gt; string(72) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=&gt; int(84) ["function"]=&gt; string(7) "runItem" ["class"]=&gt; string(15) "CRM_Core_Invoke" ["type"]=&gt; string(2) "::" ["args"]=&gt; array(1) { [0]=&gt; &amp;array(12) { ["id"]=&gt; string(3) "112" ["domain_id"]=&gt; string(1) "1" ["path"]=&gt; string(20) "civicrm/ajax/l10n-js" ["access_callback"]=&gt; string(1) "1" ["access_arguments"]=&gt; array(2) { [0]=&gt; array(1) { [0]=&gt; string(14) "access CiviCRM" } [1]=&gt; string(3) "and" } ["page_callback"]=&gt; array(2) { [0]=&gt; string(18) "CRM_Core_Resources" [1]=&gt; string(20) "outputLocalizationJS" } ["breadcrumb"]=&gt; array(1) { [0]=&gt; array(2) { ["title"]=&gt; string(7) "CiviCRM" ["url"]=&gt; string(22) "/z/dev/civicrm?reset=1" } } ["is_ssl"]=&gt; string(1) "0" ["weight"]=&gt; string(1) "1" ["type"]=&gt; string(1) "1" ["page_type"]=&gt; string(1) "0" ["page_arguments"]=&gt; bool(false) } } } [5]=&gt; array(6) { ["file"]=&gt; string(72) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=&gt; int(52) ["function"]=&gt; string(7) "_invoke" ["class"]=&gt; string(15) "CRM_Core_Invoke" ["type"]=&gt; string(2) "::" ["args"]=&gt; array(1) { [0]=&gt; &amp;array(4) { [0]=&gt; string(7) "civicrm" [1]=&gt; string(4) "ajax" [2]=&gt; string(7) "l10n-js" [3]=&gt; string(5) "en_US" } } } [6]=&gt; array(6) { ["file"]=&gt; string(74) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/drupal/civicrm.module" ["line"]=&gt; int(445) ["function"]=&gt; string(6) "invoke" ["class"]=&gt; string(15) "CRM_Core_Invoke" ["type"]=&gt; string(2) "::" ["args"]=&gt; array(1) { [0]=&gt; &amp;array(4) { [0]=&gt; string(7) "civicrm" [1]=&gt; string(4) "ajax" [2]=&gt; string(7) "l10n-js" [3]=&gt; string(5) "en_US" } } } [7]=&gt; array(2) { ["function"]=&gt; string(14) "civicrm_invoke" ["args"]=&gt; array(3) { [0]=&gt; &amp;string(4) "ajax" [1]=&gt; &amp;string(7) "l10n-js" [2]=&gt; &amp;string(5) "en_US" } } [8]=&gt; array(4) { ["file"]=&gt; string(44) "/home/jj/public_html/z/dev/includes/menu.inc" ["line"]=&gt; int(527) ["function"]=&gt; string(20) "call_user_func_array" ["args"]=&gt; array(2) { [0]=&gt; &amp;string(14) "civicrm_invoke" [1]=&gt; &amp;array(3) { [0]=&gt; string(4) "ajax" [1]=&gt; string(7) "l10n-js" [2]=&gt; string(5) "en_US" } } } [9]=&gt; array(4) { ["file"]=&gt; string(36) "/home/jj/public_html/z/dev/index.php" ["line"]=&gt; int(21) ["function"]=&gt; string(27) "menu_execute_active_handler" ["args"]=&gt; array(0) { } } } ["previous":"Exception":private]=&gt; NULL } }
  
  $backTrace = #0 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Error.php(948): CRM_Core_Error::backtrace("backTrace", TRUE) #1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error)) #2 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error)) #3 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error-&gt;__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #4 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error-&gt;__construct(-19, 16, (Array:2), "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #5 [internal function](): PEAR-&gt;_raiseError(Object(DB_mysqli), NULL, -19, NULL, NULL, "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...", "DB_Error", TRUE) #6 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8)) #7 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR-&gt;__call("raiseError", (Array:7)) #8 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR-&gt;raiseError(NULL, -19, NULL, NULL, "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...", "DB_Error", TRUE) #9 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common-&gt;raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'a.frontend_title' in 'field list'") #10 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli-&gt;mysqliRaiseError() #11 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli-&gt;simpleQuery("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #12 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common-&gt;query("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #13 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject-&gt;_query("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #14 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/DAO.php(438): DB_DataObject-&gt;query("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #15 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/DAO.php(1394): CRM_Core_DAO-&gt;query("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...", TRUE) #16 /home/jj/public_html/z/dev/sites/all/modules/civicrm/Civi/API/SelectQuery.php(143): CRM_Core_DAO::executeQuery("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #17 /home/jj/public_html/z/dev/sites/all/modules/civicrm/api/v3/utils.php(1254): Civi\API\SelectQuery-&gt;run() #18 /home/jj/public_html/z/dev/sites/all/modules/civicrm/api/v3/UFGroup.php(75): _civicrm_api3_basic_get("CRM_Core_BAO_UFGroup", (Array:3)) #19 /home/jj/public_html/z/dev/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_uf_group_get((Array:3)) #20 /home/jj/public_html/z/dev/sites/all/modules/civicrm/Civi/API/Kernel.php(169): Civi\API\Provider\MagicFunctionProvider-&gt;invoke((Array:9)) #21 /home/jj/public_html/z/dev/sites/all/modules/civicrm/Civi/API/Kernel.php(100): Civi\API\Kernel-&gt;runRequest((Array:7)) #22 /home/jj/public_html/z/dev/sites/all/modules/civicrm/api/api.php(43): Civi\API\Kernel-&gt;runSafe("uf_group", "get", (Array:3)) #23 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php(3340): civicrm_api3("uf_group", "get", (Array:2)) #24 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Resources.php(689): CRM_Core_BAO_UFGroup::getCreateLinks() #25 [internal function](): CRM_Core_Resources::outputLocalizationJS() #26 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php(275): call_user_func((Array:2)) #27 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:12)) #28 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4)) #29 /home/jj/public_html/z/dev/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:4)) #30 [internal function](): civicrm_invoke("ajax", "l10n-js", "en_US") #31 /home/jj/public_html/z/dev/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:3)) #32 /home/jj/public_html/z/dev/index.php(21): menu_execute_active_handler() #33 {main
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-13T09:27:36.837Z
Comments.Text: Strange. Did you clear the templates_c directory? And what about entering the url `http://yoursite/civicrm/clearcache?reset=1`?
Comments.UserDisplayName: Jaap Jansma - CiviCooP
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-13T16:56:48.000Z
Comments.Text: Yes, I did both. Fields still not showing.
Comments.UserDisplayName: Kristine
Tags: <drupal><upgrade>
Title: Upgrade to 5.4.0 Fields Not Loading
ThreadText: # Upgrade to 5.4.0 Fields Not Loading
  
  (Asked by: username_0 on 2018-08-13)
  
  I'm on Drupal 7 CiviCRM 5.2.0. I've updated to 5.4.0 and received no errors. However, I started seeing that icons on the civimenu are not showing. When I lookup a contact, everything seems fine, but then my custom fields in each tabs are not showing (even though the count number is still there, e.g., Relationships 5). Very strange.
  
  I also checked the Resource URLs, cleared caches and update paths, cleared Drupal cache, and nothing is working. Is there something I'm missing?
  
  Tracking of All Errors
  
  ```
  Uncaught SyntaxError: Unexpected token <
  view?reset=1&cid=963:1 Refused to execute script from '[domain]/civicrm/contact/undefinedbower_components/jstree/dist/jstree.min.js' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
  view?reset=1&cid=963:1 Refused to execute script from '[domain]/civicrm/contact/undefinedjs/jquery/jquery.crmAjaxTable.js' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
  
  $Fatal Error Details = array(3) { ["message"]=> string(23) "DB Error: no such field" ["code"]=> NULL ["exception"]=> object(CiviCRM_API3_Exception)#231 (8) { ["extraParams":"CiviCRM_API3_Exception":private]=> array(6) { ["error_code"]=> string(13) "no such field" ["sql"]=> string(1093) "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`, a.title as `title`, a.frontend_title as `frontend_title`, a.description as `description`, a.help_pre as `help_pre`, a.help_post as `help_post`, a.limit_listings_group_id as `limit_listings_group_id`, a.post_URL as `post_URL`, a.add_to_group_id as `add_to_group_id`, a.add_captcha as `add_captcha`, a.is_map as `is_map`, a.is_edit_link as `is_edit_link`, a.is_uf_link as `is_uf_link`, a.is_update_dupe as `is_update_dupe`, a.cancel_URL as `cancel_URL`, a.is_cms_user as `is_cms_user`, a.notify as `notify`, a.is_reserved as `is_reserved`, a.name as `name`, a.created_id as `created_id`, a.created_date as `created_date`, a.is_proximity_search as `is_proximity_search`, a.cancel_button_text as `cancel_button_text`, a.submit_button_text as `submit_button_text`, a.add_cancel_button as `add_cancel_button` FROM civicrm_uf_group a WHERE (a.name IN ("new_individual", "new_organization", "new_household")) AND (a.is_active = "1") LIMIT 25 OFFSET 0 [nativecode=1054 ** Unknown column 'a.frontend_title' in 'field list']" ["tip"]=> string(62) "add debug=1 to your API call to have more info about the error" ["is_error"]=> int(1) ["error_message"]=> string(23) "DB Error: no such field" ["debug_information"]=> string(1093) "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`, a.title as `title`, a.frontend_title as `frontend_title`, a.description as `description`, a.help_pre as `help_pre`, a.help_post as `help_post`, a.limit_listings_group_id as `limit_listings_group_id`, a.post_URL as `post_URL`, a.add_to_group_id as `add_to_group_id`, a.add_captcha as `add_captcha`, a.is_map as `is_map`, a.is_edit_link as `is_edit_link`, a.is_uf_link as `is_uf_link`, a.is_update_dupe as `is_update_dupe`, a.cancel_URL as `cancel_URL`, a.is_cms_user as `is_cms_user`, a.notify as `notify`, a.is_reserved as `is_reserved`, a.name as `name`, a.created_id as `created_id`, a.created_date as `created_date`, a.is_proximity_search as `is_proximity_search`, a.cancel_button_text as `cancel_button_text`, a.submit_button_text as `submit_button_text`, a.add_cancel_button as `add_cancel_button` FROM civicrm_uf_group a WHERE (a.name IN ("new_individual", "new_organization", "new_household")) AND (a.is_active = "1") LIMIT 25 OFFSET 0 [nativecode=1054 ** Unknown column 'a.frontend_title' in 'field list']" } ["message":protected]=> string(23) "DB Error: no such field" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(64) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/api/api.php" ["line":protected]=> int(45) ["trace":"Exception":private]=> array(10) { [0]=> array(4) { ["file"]=> string(77) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php" ["line"]=> int(3340) ["function"]=> string(12) "civicrm_api3" ["args"]=> array(3) { [0]=> &string(8) "uf_group" [1]=> &string(3) "get" [2]=> &array(2) { ["name"]=> array(1) { ["IN"]=> array(3) { [0]=> string(14) "new_individual" [1]=> string(16) "new_organization" [2]=> string(13) "new_household" } } ["is_active"]=> int(1) } } } [1]=> array(6) { ["file"]=> string(75) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Resources.php" ["line"]=> int(689) ["function"]=> string(14) "getCreateLinks" ["class"]=> string(20) "CRM_Core_BAO_UFGroup" ["type"]=> string(2) "::" ["args"]=> array(0) { } } [2]=> array(4) { ["function"]=> string(20) "outputLocalizationJS" ["class"]=> string(18) "CRM_Core_Resources" ["type"]=> string(2) "::" ["args"]=> array(0) { } } [3]=> array(4) { ["file"]=> string(72) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=> int(275) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) { [0]=> &array(2) { [0]=> string(18) "CRM_Core_Resources" [1]=> string(20) "outputLocalizationJS" } } } [4]=> array(6) { ["file"]=> string(72) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=> int(84) ["function"]=> string(7) "runItem" ["class"]=> string(15) "CRM_Core_Invoke" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &array(12) { ["id"]=> string(3) "112" ["domain_id"]=> string(1) "1" ["path"]=> string(20) "civicrm/ajax/l10n-js" ["access_callback"]=> string(1) "1" ["access_arguments"]=> array(2) { [0]=> array(1) { [0]=> string(14) "access CiviCRM" } [1]=> string(3) "and" } ["page_callback"]=> array(2) { [0]=> string(18) "CRM_Core_Resources" [1]=> string(20) "outputLocalizationJS" } ["breadcrumb"]=> array(1) { [0]=> array(2) { ["title"]=> string(7) "CiviCRM" ["url"]=> string(22) "/z/dev/civicrm?reset=1" } } ["is_ssl"]=> string(1) "0" ["weight"]=> string(1) "1" ["type"]=> string(1) "1" ["page_type"]=> string(1) "0" ["page_arguments"]=> bool(false) } } } [5]=> array(6) { ["file"]=> string(72) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=> int(52) ["function"]=> string(7) "_invoke" ["class"]=> string(15) "CRM_Core_Invoke" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &array(4) { [0]=> string(7) "civicrm" [1]=> string(4) "ajax" [2]=> string(7) "l10n-js" [3]=> string(5) "en_US" } } } [6]=> array(6) { ["file"]=> string(74) "/home/jj/public_html/z/dev/sites/all/modules/civicrm/drupal/civicrm.module" ["line"]=> int(445) ["function"]=> string(6) "invoke" ["class"]=> string(15) "CRM_Core_Invoke" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &array(4) { [0]=> string(7) "civicrm" [1]=> string(4) "ajax" [2]=> string(7) "l10n-js" [3]=> string(5) "en_US" } } } [7]=> array(2) { ["function"]=> string(14) "civicrm_invoke" ["args"]=> array(3) { [0]=> &string(4) "ajax" [1]=> &string(7) "l10n-js" [2]=> &string(5) "en_US" } } [8]=> array(4) { ["file"]=> string(44) "/home/jj/public_html/z/dev/includes/menu.inc" ["line"]=> int(527) ["function"]=> string(20) "call_user_func_array" ["args"]=> array(2) { [0]=> &string(14) "civicrm_invoke" [1]=> &array(3) { [0]=> string(4) "ajax" [1]=> string(7) "l10n-js" [2]=> string(5) "en_US" } } } [9]=> array(4) { ["file"]=> string(36) "/home/jj/public_html/z/dev/index.php" ["line"]=> int(21) ["function"]=> string(27) "menu_execute_active_handler" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL } }
  
  $backTrace = #0 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Error.php(948): CRM_Core_Error::backtrace("backTrace", TRUE) #1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error)) #2 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error)) #3 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #4 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #5 [internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, NULL, NULL, "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...", "DB_Error", TRUE) #6 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8)) #7 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7)) #8 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...", "DB_Error", TRUE) #9 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'a.frontend_title' in 'field list'") #10 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError() #11 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #12 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #13 /home/jj/public_html/z/dev/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #14 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/DAO.php(438): DB_DataObject->query("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #15 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/DAO.php(1394): CRM_Core_DAO->query("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...", TRUE) #16 /home/jj/public_html/z/dev/sites/all/modules/civicrm/Civi/API/SelectQuery.php(143): CRM_Core_DAO::executeQuery("SELECT a.id as `id`, a.is_active as `is_active`, a.group_type as `group_type`...") #17 /home/jj/public_html/z/dev/sites/all/modules/civicrm/api/v3/utils.php(1254): Civi\API\SelectQuery->run() #18 /home/jj/public_html/z/dev/sites/all/modules/civicrm/api/v3/UFGroup.php(75): _civicrm_api3_basic_get("CRM_Core_BAO_UFGroup", (Array:3)) #19 /home/jj/public_html/z/dev/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_uf_group_get((Array:3)) #20 /home/jj/public_html/z/dev/sites/all/modules/civicrm/Civi/API/Kernel.php(169): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9)) #21 /home/jj/public_html/z/dev/sites/all/modules/civicrm/Civi/API/Kernel.php(100): Civi\API\Kernel->runRequest((Array:7)) #22 /home/jj/public_html/z/dev/sites/all/modules/civicrm/api/api.php(43): Civi\API\Kernel->runSafe("uf_group", "get", (Array:3)) #23 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/BAO/UFGroup.php(3340): civicrm_api3("uf_group", "get", (Array:2)) #24 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Resources.php(689): CRM_Core_BAO_UFGroup::getCreateLinks() #25 [internal function](): CRM_Core_Resources::outputLocalizationJS() #26 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php(275): call_user_func((Array:2)) #27 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:12)) #28 /home/jj/public_html/z/dev/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4)) #29 /home/jj/public_html/z/dev/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:4)) #30 [internal function](): civicrm_invoke("ajax", "l10n-js", "en_US") #31 /home/jj/public_html/z/dev/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:3)) #32 /home/jj/public_html/z/dev/index.php(21): menu_execute_active_handler() #33 {main
  
  ```
  
  **Tags:** drupal, upgrade
  
  > **Comments:**
  > **username_1**: Strange. Did you clear the templates_c directory? And what about entering the url `http://yoursite/civicrm/clearcache?reset=1`?  
  > **username_0**: Yes, I did both. Fields still not showing.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2018-10-09. Score: 1 | Accepted answer
  
  I finally resolved it by upgrading to 5.6.0, although it was a bit of a journey.
  First I tried the solution in #6, but I found there were even more fields missing, having done a fresh installation of 5.5.3 and compared the columns in the civicrm\_uf\_group table: title, frontend\_title, help\_pre, help\_post, cancel\_button\_text, submit\_button\_text
  
  I was still getting the error, and the log table was showing that the error was on a view of this table `civicrm_uf_group_en_US`
  So I assumed that now CiviCRM creates views of tables, which are not affected by changing table structure alone. Not sure if this is a new thing or if only for languages. The site had been configured for only English US, but was selected as if it was a language. Tried to change it to be language neutral. Not sure it made a difference.
  
  Regardless, it seems that upgrading rebuilt the views, and problem solved.
  Perhaps with hindsight I could have found a way just to modify the view without needing to upgrade.
  
  Hope this helps someone.
  
  
  ---
  
  ### Answer by username_3 on 2018-08-13. Score: 5
  
  Is the site configured for multi-lingual? If so then it might be an error with schema rebuild. Can you try rebuilding the schema using api explorer or drush?
  
  Ref: <https://civicrm.stackexchange.com/a/25890/155>
  
  Or You will need to manually add the 'frontend\_title' field to the table by running below sql query.
  
  ```
  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.';
  
  ```
  
  > **Comments:**
  > **username_0**: No, it isn't configured as multi-lingual. I tried doing the solutions on that page just in case, but I see no changes.  
  > **username_0**: Ok did some research. Strangely, a lot of the symptoms associated with the multi-lingual issues are similar here (blank page, no such field, undefined packages url).  The API explorer won't let me choose "System.rebuildmultilingualschema" because the wheel continues to spin. I also don't have access to use drush.  
  > **username_3**: Try using rest api url to run the schema rebuild  
  > **username_1**: What does your webserver log say? And what about the civicrm log file? Any indication of an error message? If nothing shows up you could possibly enable debug mode at: http://yoursite/civicrm/admin/settings/debug?reset=1  
  > **username_0**: I updated the original post with all my errors, including my civicrm log file.  
  > **username_3**: username_0 you will need to the rebuildschema as this a known bug as I mentioned in my answer. (Proof: https://github.com/civicrm/civicrm-core/pull/12636)  
  > **username_3**: Or you will need to manually add this column through mysql  
  > **username_3**: I have updated my answer.  
  > **username_0**: I did the sql query. Uploaded the file, SchemaStructure_5_4_alpha1.php just in case. Flushed the cache, no changes. I see that the console is not able to load the 'jquery.crmAjaxTable.js' still.  
  > **username_3**: Can you check more errors in CiviCRM logs  
  > **username_0**: I updated the log again from above, but it seems like the same log. It keeps looking for the JS files under undefinedpackages/jquery/. I don't think its the Resource URL issue though. I even copied the database to another server and the paths are correct.  
  > **username_0**: Let us [continue this discussion in chat](https://chat.stackexchange.com/rooms/81650/discussion-between-username_0-and-username_3).  
  
  ---
  
  