Body: <p>I updated my side from 5.58.1 to 5.63.2. Now as soon I save an existing searchkit search, I got an error: <code>&quot;message&quot; =&gt; &quot;Invalid field ''&quot;</code>. Before saving, the searches runs. New searches also working. Any ideas what I can do?</p>
  <p>Thanks
  David</p>
  <p>This is the full error message:</p>
  <pre><code>Fatal Error Details = array:3 [
    &quot;message&quot; =&gt; &quot;Invalid field ''&quot;
    &quot;code&quot; =&gt; null
    &quot;exception&quot; =&gt; CRM_Core_Exception {#2426
      -errorData: array:1 [
        &quot;error_code&quot; =&gt; 0
      ]
      #cause: null
      -_trace: null
      #message: &quot;Invalid field ''&quot;
      #code: 0
      #file: &quot;/var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php&quot;
      #line: 727
      trace: {
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:727 {
          Civi\Api4\Query\Api4SelectQuery-&gt;getField($expr, $strict = false)
          › if ($strict &amp;&amp; $field === NULL) {
          ›   throw new \CRM_Core_Exception(&quot;Invalid field '$fieldName'&quot;);
          › }
        }
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:672 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:547 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:459 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:823 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:127 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/ext/search_kit/Civi/Search/Meta.php:34 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/ext/search_kit/Civi/Search/AfformSearchMetadataInjector.php:74 { …}
        Civi\Search\AfformSearchMetadataInjector::Civi\Search\{closure}() {}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Angular/ChangeSet.php:59 { …}
  </code></pre>
  <p>in browser consol the following errer is shown:
  &quot;TypeError: CRM.angular.templates is undefined&quot;</p>
  <p>This is my system infromation:</p>
  <ul>
  <li>CiviCRM: 5.63.2</li>
  <li>CMS: Drupal 7.98</li>
  <li>PHP: 7.4</li>
  <li>Database: 10.3.38 MariaDB</li>
  </ul>
  <p>addional info:
  The first time I updated, I got an error message because the title on the civicrm_contribution_page was null. I added a title to the database, then the update runs. (started again from the original database)</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-30T21:37:45.287Z
Comments.Text: Welcome to CiviStackExchange! I added backticks around your code blocks to make them readable - please remember to do that in the future.
  The backtrace offers a clue but still not entirely clear. Can you verify that you followed the upgrade procedure and your database is at the correct version?
Comments.UserDisplayName: Coleman
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-31T18:03:58.377Z
Comments.Text: thanks will do code blocks in future.
Comments.UserDisplayName: David
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-31T18:05:30.977Z
Comments.Text: I add some more informations. civicrm system status complains only about " MySQL Timezone Problem". Extenstions and core shoud be updated
Comments.UserDisplayName: David
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-31T19:22:17.677Z
Comments.Text: I did incremental update now. Until 5.62.1 the site is working.
Comments.UserDisplayName: David
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-31T20:20:48.223Z
Comments.Text: @coleman. I think I got it and all information I wrote are not relevant. Only participant searches are affected (most of my searches are for participants). Several operators are no longer available for participant role 5.63. So role_id:name IN Volunteer get changed to role_id:name CONTAINS "". I think this is a bug?
Comments.UserDisplayName: David
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-31T20:23:06.887Z
Comments.Text: but the error "error_message "DB Error: no such field"" is still in browser console, but search results are shown at least.
Comments.UserDisplayName: David
Tags: <upgrade><error><searchkit>
Title: Searchkit - error after saving searches in 5.63.2
ThreadText: # Searchkit - error after saving searches in 5.63.2
  
  (Asked by: username_0 on 2023-07-30)
  
  I updated my side from 5.58.1 to 5.63.2. Now as soon I save an existing searchkit search, I got an error: "message" => "Invalid field ''". Before saving, the searches runs. New searches also working. Any ideas what I can do?
  Thanks
  username_0
  This is the full error message:
  Fatal Error Details = array:3 [
    "message" => "Invalid field ''"
    "code" => null
    "exception" => CRM_Core_Exception {#2426
      -errorData: array:1 [
        "error_code" => 0
      ]
      #cause: null
      -_trace: null
      #message: "Invalid field ''"
      #code: 0
      #file: "/var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php"
      #line: 727
      trace: {
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:727 {
          Civi\Api4\Query\Api4SelectQuery->getField($expr, $strict = false)
          › if ($strict && $field === NULL) {
          ›   throw new \CRM_Core_Exception("Invalid field '$fieldName'");
          › }
        }
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:672 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:547 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:459 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:823 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:127 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/ext/search_kit/Civi/Search/Meta.php:34 { …}
        /var/www/html/civicrm/sites/all/modules/civicrm/ext/search_kit/Civi/Search/AfformSearchMetadataInjector.php:74 { …}
        Civi\Search\AfformSearchMetadataInjector::Civi\Search\{closure}() {}
        /var/www/html/civicrm/sites/all/modules/civicrm/Civi/Angular/ChangeSet.php:59 { …}
  
  in browser consol the following errer is shown:
  "TypeError: CRM.angular.templates is undefined"
  This is my system infromation:
  
  CiviCRM: 5.63.2
  CMS: Drupal 7.98
  PHP: 7.4
  Database: 10.3.38 MariaDB
  
  addional info:
  The first time I updated, I got an error message because the title on the civicrm_contribution_page was null. I added a title to the database, then the update runs. (started again from the original database)
  
  **Tags:** upgrade, error, searchkit
  
  > **Comments:**
  > **username_1**: Welcome to CiviStackExchange! I added backticks around your code blocks to make them readable - please remember to do that in the future. The backtrace offers a clue but still not entirely clear. Can you verify that you followed the upgrade procedure and your database is at the correct version?  
  > **username_0**: thanks will do code blocks in future.  
  > **username_0**: I add some more informations. civicrm system status complains only about " MySQL Timezone Problem". Extenstions and core shoud be updated  
  > **username_0**: I did incremental update now. Until 5.62.1 the site is working.  
  > **username_0**: @coleman. I think I got it and all information I wrote are not relevant. Only participant searches are affected (most of my searches are for participants). Several operators are no longer available for participant role 5.63. So role_id:name IN Volunteer get changed to role_id:name CONTAINS "". I think this is a bug?  
  > **username_0**: but the error "error_message "DB Error: no such field"" is still in browser console, but search results are shown at least.  
  
  ---
  
  ## 0 answers
  
  