Answers.Body: <p>Are you actually using civigrant? I guess not if you don't even have that table. So try disabling the civigrant extension then re-enabling. If that doesn't help then uninstall the extension and re-install it.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-03-13T14:41:40.953Z
Answers.Text: I do not use civigrant, so I had uninstalled it. After installing and disabling it, the error has disappeared. Thanks!
Answers.UserDisplayName: Francesco Potortì
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-03-13T00:51:59.050Z
Answers.LastActivityDate: 2023-03-13T00:51:59.050Z
Answers.UserDisplayName: Demerit
Body: <p>The error in the title appears in the Civicrm System Status after upgrade to 5.57.1</p>
  <p>As far as I can get, it does not manage to check for the existence of new civicrm versions, so it should not be anything too serious...</p>
  <p>This is the detail from the log entry:</p>
  <pre><code>Parameters parsed (and passed to API method): 
  a:1:{s:7:&quot;version&quot;;i:3;}
  
  Full message: 
  Finished execution of CiviCRM Update Check with result: Failure, Error message: DB Error: no such table
  </code></pre>
  <p>Looking under Administer &gt; Administration Console &gt; View Log I can understand what is the missing table. I see two entries:</p>
  <pre><code>[debug] $backTrace = #0 /home/usiako1s/domains/figg.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(954): CRM_Core_Error::backtrace(&quot;backTrace&quot;, TRUE) 
  </code></pre>
  <p>and</p>
  <pre><code>[error] $Fatal Error Details = Array
  </code></pre>
  <p>Here is the detail from the first one:</p>
  <pre><code> [debug] $backTrace = #0 /home/usiako1s/domains/figg.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(954): CRM_Core_Error::backtrace(&quot;backTrace&quot;, TRUE)
  #1  administrator/components/com_civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::exceptionHandler(Object(DB_Error))
  #2  administrator/components/com_civicrm/civicrm/packages/DB.php(997): PEAR_Error-&gt;__construct(&quot;DB Error: no such table&quot;, -18, 16, (Array:2), &quot;SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...&quot;)
  #3  administrator/components/com_civicrm/civicrm/packages/PEAR.php(575): DB_Error-&gt;__construct(-18, 16, (Array:2), &quot;SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...&quot;)
  #4  administrator/components/com_civicrm/civicrm/packages/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -18, 16, (Array:2), &quot;SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...&quot;, &quot;DB_Error&quot;, TRUE)
  #5  administrator/components/com_civicrm/civicrm/packages/DB/common.php(1925): PEAR-&gt;__call(&quot;raiseError&quot;, (Array:7))
  #6  administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(936): DB_common-&gt;raiseError(-18, NULL, NULL, &quot;SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...&quot;, &quot;1146 ** Table 'usiako1s_figg.civicrm_grant' doesn't exist&quot;)
  #7  administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(406): DB_mysqli-&gt;mysqliRaiseError()
  #8  administrator/components/com_civicrm/civicrm/packages/DB/common.php(1231): DB_mysqli-&gt;simpleQuery(&quot;SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...&quot;)
  #9  administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2696): DB_common-&gt;query(&quot;SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...&quot;)
  #10 administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1803): DB_DataObject-&gt;_query(&quot;SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...&quot;)
  #11 administrator/components/com_civicrm/civicrm/CRM/Utils/VersionCheck.php(218): DB_DataObject-&gt;count()
  #12 administrator/components/com_civicrm/civicrm/CRM/Utils/VersionCheck.php(153): CRM_Utils_VersionCheck-&gt;getEntityStats()
  #13 administrator/components/com_civicrm/civicrm/CRM/Utils/VersionCheck.php(125): CRM_Utils_VersionCheck-&gt;getSiteStats()
  #14 administrator/components/com_civicrm/civicrm/api/v3/Job.php(751): CRM_Utils_VersionCheck-&gt;fetch()
  #15 administrator/components/com_civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_version_check((Array:1))
  #16 administrator/components/com_civicrm/civicrm/Civi/API/Kernel.php(158): Civi\API\Provider\MagicFunctionProvider-&gt;invoke((Array:8))
  #17 administrator/components/com_civicrm/civicrm/Civi/API/Kernel.php(81): Civi\API\Kernel-&gt;runRequest((Array:8))
  #18 administrator/components/com_civicrm/civicrm/api/api.php(22): Civi\API\Kernel-&gt;runSafe(&quot;Job&quot;, &quot;version_check&quot;, (Array:1))
  #19 administrator/components/com_civicrm/civicrm/CRM/Core/JobManager.php(131): civicrm_api(&quot;Job&quot;, &quot;version_check&quot;, (Array:1))
  #20 administrator/components/com_civicrm/civicrm/CRM/Core/JobManager.php(63): CRM_Core_JobManager-&gt;executeJob(Object(CRM_Core_ScheduledJob))
  #21 administrator/components/com_civicrm/civicrm/bin/cron.php(26): CRM_Core_JobManager-&gt;execute()
  #22 {main}
  </code></pre>
  <p>and here is the detail from the second one:</p>
  <pre><code> [error] $Fatal Error Details = Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; exceptionHandler
          )
  
      [code] =&gt; -18
      [message] =&gt; DB Error: no such table
      [mode] =&gt; 16
      [debug_info] =&gt; SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`
                  FROM `civicrm_grant`   [nativecode=1146 ** Table 'usiako1s_figg.civicrm_grant' doesn't exist]
      [type] =&gt; DB_Error
      [user_info] =&gt; SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`
                  FROM `civicrm_grant`   [nativecode=1146 ** Table 'usiako1s_figg.civicrm_grant' doesn't exist]
      [to_string] =&gt; [db_error: message=&quot;DB Error: no such table&quot; code=-18 mode=callback callback=CRM_Core_Error::exceptionHandler prefix=&quot;&quot; info=&quot;SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`
                  FROM `civicrm_grant`   [nativecode=1146 ** Table 'usiako1s_figg.civicrm_grant' doesn't exist]&quot;]
  )
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-16T03:20:56.450Z
Comments.Text: I'm having the same issue. If you check your log file, it should pinpoint the missing table. The log file for me is visible under Administer > Administration Console > View Log. I'm missing the civicrm_grant table; unsure at this point how to restore it.
Comments.UserDisplayName: LMK Web
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-16T07:43:36.637Z
Comments.Text: Mh, no. I edited the question to show what I see in the logs.
Comments.UserDisplayName: Francesco Potortì
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-17T14:23:26.793Z
Comments.Text: If you click on the number next to the log entry, that gives you more detail about the error.
Comments.UserDisplayName: LMK Web
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-17T23:25:20.323Z
Comments.Text: Thanks. I added this detail
Comments.UserDisplayName: Francesco Potortì
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-19T16:06:31.830Z
Comments.Text: Looks like we're missing the same civicrm_grant table - so hopefully someone chimes in with a fix! I've snoozed the error message for now for the next 30 days, because we've had the issue for a while and the only problem it causes is that you don't get pinged for updates.
Comments.UserDisplayName: LMK Web
Tags: <upgrade>
Title: Finished execution of CiviCRM Update Check with result: Failure, Error message: DB Error: no such table
ThreadText: # Finished execution of CiviCRM Update Check with result: Failure, Error message: DB Error: no such table
  
  (Asked by: username_0 on 2023-01-13)
  
  The error in the title appears in the Civicrm System Status after upgrade to 5.57.1
  As far as I can get, it does not manage to check for the existence of new civicrm versions, so it should not be anything too serious...
  This is the detail from the log entry:
  Parameters parsed (and passed to API method): 
  a:1:{s:7:"version";i:3;}
  
  Full message: 
  Finished execution of CiviCRM Update Check with result: Failure, Error message: DB Error: no such table
  
  Looking under Administer > Administration Console > View Log I can understand what is the missing table. I see two entries:
  [debug] $backTrace = #0 /home/usiako1s/domains/figg.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(954): CRM_Core_Error::backtrace("backTrace", TRUE) 
  
  and
  [error] $Fatal Error Details = Array
  
  Here is the detail from the first one:
   [debug] $backTrace = #0 /home/usiako1s/domains/figg.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(954): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1  administrator/components/com_civicrm/civicrm/packages/PEAR.php(921): CRM_Core_Error::exceptionHandler(Object(DB_Error))
  #2  administrator/components/com_civicrm/civicrm/packages/DB.php(997): PEAR_Error->__construct("DB Error: no such table", -18, 16, (Array:2), "SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...")
  #3  administrator/components/com_civicrm/civicrm/packages/PEAR.php(575): DB_Error->__construct(-18, 16, (Array:2), "SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...")
  #4  administrator/components/com_civicrm/civicrm/packages/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -18, 16, (Array:2), "SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...", "DB_Error", TRUE)
  #5  administrator/components/com_civicrm/civicrm/packages/DB/common.php(1925): PEAR->__call("raiseError", (Array:7))
  #6  administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(936): DB_common->raiseError(-18, NULL, NULL, "SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...", "1146 ** Table 'usiako1s_figg.civicrm_grant' doesn't exist")
  #7  administrator/components/com_civicrm/civicrm/packages/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
  #8  administrator/components/com_civicrm/civicrm/packages/DB/common.php(1231): DB_mysqli->simpleQuery("SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...")
  #9  administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2696): DB_common->query("SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...")
  #10 administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1803): DB_DataObject->_query("SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`\n                FROM ...")
  #11 administrator/components/com_civicrm/civicrm/CRM/Utils/VersionCheck.php(218): DB_DataObject->count()
  #12 administrator/components/com_civicrm/civicrm/CRM/Utils/VersionCheck.php(153): CRM_Utils_VersionCheck->getEntityStats()
  #13 administrator/components/com_civicrm/civicrm/CRM/Utils/VersionCheck.php(125): CRM_Utils_VersionCheck->getSiteStats()
  #14 administrator/components/com_civicrm/civicrm/api/v3/Job.php(751): CRM_Utils_VersionCheck->fetch()
  #15 administrator/components/com_civicrm/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_job_version_check((Array:1))
  #16 administrator/components/com_civicrm/civicrm/Civi/API/Kernel.php(158): Civi\API\Provider\MagicFunctionProvider->invoke((Array:8))
  #17 administrator/components/com_civicrm/civicrm/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest((Array:8))
  #18 administrator/components/com_civicrm/civicrm/api/api.php(22): Civi\API\Kernel->runSafe("Job", "version_check", (Array:1))
  #19 administrator/components/com_civicrm/civicrm/CRM/Core/JobManager.php(131): civicrm_api("Job", "version_check", (Array:1))
  #20 administrator/components/com_civicrm/civicrm/CRM/Core/JobManager.php(63): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob))
  #21 administrator/components/com_civicrm/civicrm/bin/cron.php(26): CRM_Core_JobManager->execute()
  #22 {main}
  
  and here is the detail from the second one:
   [error] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => exceptionHandler
          )
  
      [code] => -18
      [message] => DB Error: no such table
      [mode] => 16
      [debug_info] => SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`
                  FROM `civicrm_grant`   [nativecode=1146 ** Table 'usiako1s_figg.civicrm_grant' doesn't exist]
      [type] => DB_Error
      [user_info] => SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`
                  FROM `civicrm_grant`   [nativecode=1146 ** Table 'usiako1s_figg.civicrm_grant' doesn't exist]
      [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT count(`civicrm_grant`.`id`) as `DATAOBJECT_NUM`
                  FROM `civicrm_grant`   [nativecode=1146 ** Table 'usiako1s_figg.civicrm_grant' doesn't exist]"]
  )
  
  **Tags:** upgrade
  
  > **Comments:**
  > **username_1**: I'm having the same issue. If you check your log file, it should pinpoint the missing table. The log file for me is visible under Administer > Administration Console > View Log. I'm missing the civicrm_grant table; unsure at this point how to restore it.  
  > **username_0**: Mh, no. I edited the question to show what I see in the logs.  
  > **username_1**: If you click on the number next to the log entry, that gives you more detail about the error.  
  > **username_0**: Thanks. I added this detail  
  > **username_1**: Looks like we're missing the same civicrm_grant table - so hopefully someone chimes in with a fix! I've snoozed the error message for now for the next 30 days, because we've had the issue for a while and the only problem it causes is that you don't get pinged for updates.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2023-03-13. Score: 2
  
  Are you actually using civigrant? I guess not if you don't even have that table. So try disabling the civigrant extension then re-enabling. If that doesn't help then uninstall the extension and re-install it.
  
  > **Comments:**
  > **username_0**: I do not use civigrant, so I had uninstalled it. After installing and disabling it, the error has disappeared. Thanks!  
  
  ---
  
  