Body: <p>We recently upgraded our CiviCRM instance from 5.51.3 to 5.54.0 to resolve some of the bugs that 5.54.0 resolves.</p>
  <p>Since then, <em>non administrator</em> users are not able to run any reports, and they get a generic DB Error. I see this error in the logs:</p>
  <pre><code>PEAR_Exception: DB Error: no such field in /public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 944
  
  DB_Error: DB Error: no such field in unknown on line unknown
  </code></pre>
  <p>When I look at the last line in the debug info, I see this:</p>
  <pre><code>** Unknown column 'cgroup_civireport.id' in 'where clause']
  </code></pre>
  <p>Since anyone who is an admin can run this report, I'm assuming that this error relates to something permissions based. Does anyone have any ideas?</p>
  <p>EDIT: As requested by Demerit, I turned on Debugging and Backtrace and added the full error/backtrace here: <a href="https://gist.github.com/benrfairless/924dd3b88f4e829a5038e00fea1fe82c" rel="nofollow noreferrer">https://gist.github.com/benrfairless/924dd3b88f4e829a5038e00fea1fe82c</a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-10-28T18:19:56.247Z
Comments.Text: cgroup is an alias for civicrm_group in reports, so something to do with groups. Do you have the full stack trace in the log?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-11-03T06:43:25.747Z
Comments.Text: I've added this here: https://gist.github.com/benrfairless/924dd3b88f4e829a5038e00fea1fe82c
Comments.UserDisplayName: ben_fairless
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-11-05T02:37:32.733Z
Comments.Text: Ok thanks. So /public_html/wp-content/uploads/civicrm/ext/au.org.australian-democrats.austdem is obviously a custom extension - I think you need to look at the code in that extension.
Comments.UserDisplayName: Demerit
Tags: <civimember><upgrade><civireport><database><permissions>
Title: 5.51.3 to 5.54.0 - "DB_Error: DB Error: no such field in unknown on line unknown" for non-admins when running reports
ThreadText: # 5.51.3 to 5.54.0 - "DB_Error: DB Error: no such field in unknown on line unknown" for non-admins when running reports
  
  (Asked by: username_0 on 2022-10-28)
  
  We recently upgraded our CiviCRM instance from 5.51.3 to 5.54.0 to resolve some of the bugs that 5.54.0 resolves.
  Since then, non administrator users are not able to run any reports, and they get a generic DB Error. I see this error in the logs:
  PEAR_Exception: DB Error: no such field in /public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 944
  
  DB_Error: DB Error: no such field in unknown on line unknown
  
  When I look at the last line in the debug info, I see this:
  ** Unknown column 'cgroup_civireport.id' in 'where clause']
  
  Since anyone who is an admin can run this report, I'm assuming that this error relates to something permissions based. Does anyone have any ideas?
  EDIT: As requested by username_1, I turned on Debugging and Backtrace and added the full error/backtrace here: https://gist.github.com/benrfairless/924dd3b88f4e829a5038e00fea1fe82c
  
  **Tags:** civimember, upgrade, civireport, database, permissions
  
  > **Comments:**
  > **username_1**: cgroup is an alias for civicrm_group in reports, so something to do with groups. Do you have the full stack trace in the log?  
  > **username_0**: I've added this here: https://gist.github.com/benrfairless/924dd3b88f4e829a5038e00fea1fe82c  
  > **username_1**: Ok thanks. So /public_html/wp-content/uploads/civicrm/ext/au.org.australian-democrats.austdem is obviously a custom extension - I think you need to look at the code in that extension.  
  
  ---
  
  ## 0 answers
  
  