Answers.Body: <p>It sounds like the 5.32 upgrade didn't complete properly. See <a href="https://github.com/civicrm/civicrm-core/blob/0cc012c6d478a2602db3720117b39fff3799b7f7/CRM/Upgrade/Incremental/php/FiveThirtyTwo.php#L89" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/blob/0cc012c6d478a2602db3720117b39fff3799b7f7/CRM/Upgrade/Incremental/php/FiveThirtyTwo.php#L89</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-12T04:02:37.227Z
Answers.LastActivityDate: 2021-03-12T04:02:37.227Z
Answers.UserDisplayName: Demerit
Answers.Body: <p>It might be that the column that you are trying to get in your saved search no longer exists? It is trying to find a record in the table civicrm_saved_search with and id of 71. Can you check if that record exists and what it looks like?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-11T13:29:23.250Z
Answers.LastActivityDate: 2021-03-11T13:29:23.250Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>CiviCRM 5.35.0 on Joomla 3.9.25</p>
  <p>Search (basic, advanced or search builder) when I select a Group returns:</p>
  <pre><code> &quot;Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: no such field&quot;
  </code></pre>
  <p>I'm not sure when this started happening. We update regularly and haven't had any issues installing updates or running the db update function.</p>
  <p>Error log has this:</p>
  <pre><code>    Mar 11 05:12:10  [error] $Fatal Error Details = Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; exceptionHandler
          )
  
      [code] =&gt; -19
      [message] =&gt; DB Error: no such field
      [mode] =&gt; 16
      [debug_info] =&gt; SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
  FROM civicrm_saved_search a
  WHERE (`a`.`id` = &quot;71&quot;)
   [nativecode=1054 ** Unknown column 'a.name' in 'field list']
      [type] =&gt; DB_Error
      [user_info] =&gt; SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
  FROM civicrm_saved_search a
  WHERE (`a`.`id` = &quot;71&quot;)
   [nativecode=1054 ** Unknown column 'a.name' in 'field list']
      [to_string] =&gt; [db_error: message=&quot;DB Error: no such field&quot; code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix=&quot;&quot; info=&quot;SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
  FROM civicrm_saved_search a
  WHERE (`a`.`id` = &quot;71&quot;)
   [nativecode=1054 ** Unknown column 'a.name' in 'field list']&quot;]
  )
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-11T20:55:05.913Z
Comments.Text: If you have access to the MySQL database, could you copy-paste the output of `show create table civicrm_saved_search` ? It seems like a field is missing on that table, which is rather odd. The 'name' column was added in CiviCRM 2.1 and not changed since.
  Also, do you have detailed logging enabled?
Comments.UserDisplayName: bgm
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-12T14:33:28.680Z
Comments.Text: @bgm [link](https://www.evernote.com/l/AClE-4eox6JHCb5gX7NMTgSIw7upmzovP-U) Is that what you wanted to see?
Comments.UserDisplayName: Matt
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-12T14:38:13.907Z
Comments.Text: Oops, hit enter by accident. Yes, detailed logging is enabled. Here is the full log (too large to fit here) [link](https://pastebin.com/puxsC4x0)
Comments.UserDisplayName: Matt
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-12T19:09:55.187Z
Comments.Text: It might be the 5.32 upgrade like Demerit mentioned, but if not, you may want to check that the log table also has the new column. In the above I don't see the "show create table" output? You might want to compare with `show create table log_civicrm_saved_search`.
Comments.UserDisplayName: bgm
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-12T19:15:56.063Z
Comments.Text: Edit: actually, it's unlikely to be a log table issue, since it's a SELECT query, not an UPDATE/INSERT. So more likely to be the 5.32 update issue that Demerit mentioned. Can you also report the output of `select version from civicrm_domain`?
Comments.UserDisplayName: bgm
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-15T16:39:08.027Z
Comments.Text: Output from show create table log_civicrm_saved_search: [link](https://pastebin.com/sSWpDkij)
  
  Output from select version from civicrm_domain: 5.35.0
  
  Looking into what Dermerit mentioned now.
Comments.UserDisplayName: Matt
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-15T16:49:01.887Z
Comments.Text: @Demerit was right **happy dance**
Comments.UserDisplayName: Matt
Tags: <error>
Title: Unknown column 'a.name' in 'field list
ThreadText: # Unknown column 'a.name' in 'field list
  
  (Asked by: username_0 on 2021-03-11)
  
  CiviCRM 5.35.0 on Joomla 3.9.25
  
  Search (basic, advanced or search builder) when I select a Group returns:
  
  ```
   "Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: no such field"
  
  ```
  
  I'm not sure when this started happening. We update regularly and haven't had any issues installing updates or running the db update function.
  
  Error log has this:
  
  ```
      Mar 11 05:12:10  [error] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => exceptionHandler
          )
  
      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
  FROM civicrm_saved_search a
  WHERE (`a`.`id` = "71")
   [nativecode=1054 ** Unknown column 'a.name' in 'field list']
      [type] => DB_Error
      [user_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
  FROM civicrm_saved_search a
  WHERE (`a`.`id` = "71")
   [nativecode=1054 ** Unknown column 'a.name' in 'field list']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
  FROM civicrm_saved_search a
  WHERE (`a`.`id` = "71")
   [nativecode=1054 ** Unknown column 'a.name' in 'field list']"]
  )
  
  ```
  
  **Tags:** error
  
  > **Comments:**
  > **username_1**: If you have access to the MySQL database, could you copy-paste the output of `show create table civicrm_saved_search` ? It seems like a field is missing on that table, which is rather odd. The 'name' column was added in CiviCRM 2.1 and not changed since. Also, do you have detailed logging enabled?  
  > **username_0**: @username_1 [link](https://www.evernote.com/l/AClE-4eox6JHCb5gX7NMTgSIw7upmzovP-U) Is that what you wanted to see?  
  > **username_0**: Oops, hit enter by accident. Yes, detailed logging is enabled. Here is the full log (too large to fit here) [link](https://pastebin.com/puxsC4x0)  
  > **username_1**: It might be the 5.32 upgrade like username_2 mentioned, but if not, you may want to check that the log table also has the new column. In the above I don't see the "show create table" output? You might want to compare with `show create table log_civicrm_saved_search`.  
  > **username_1**: Edit: actually, it's unlikely to be a log table issue, since it's a SELECT query, not an UPDATE/INSERT. So more likely to be the 5.32 update issue that username_2 mentioned. Can you also report the output of `select version from civicrm_domain`?  
  > **username_0**: Output from show create table log_civicrm_saved_search: [link](https://pastebin.com/sSWpDkij)  Output from select version from civicrm_domain: 5.35.0  Looking into what Dermerit mentioned now.  
  > **username_0**: @username_2 was right **happy dance**  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2021-03-12. Score: 0 | Accepted answer
  
  It sounds like the 5.32 upgrade didn't complete properly. See <https://github.com/civicrm/civicrm-core/blob/0cc012c6d478a2602db3720117b39fff3799b7f7/CRM/Upgrade/Incremental/php/FiveThirtyTwo.php#L89>
  
  
  ---
  
  ### Answer by username_3 on 2021-03-11. Score: 0
  
  It might be that the column that you are trying to get in your saved search no longer exists? It is trying to find a record in the table civicrm\_saved\_search with and id of 71. Can you check if that record exists and what it looks like?
  
  
  ---
  
  