Answers.Body: <p>When you made your config changes did you turn on ANSI or ANSI_QUOTES in your sql_mode?</p>
  <p>It prevents using <code>&quot;</code> as a string quoting character which is not a standard string quoting character in sql, and so will break civi since civi does nonstandard things.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-04T14:19:05.023Z
Answers.Text: Thank you but that is not how the database is configured now.  I did turn on ANSI but then I turned it off. Could I have damaged the database? I think I will restore from a clone just to see if that works.
Answers.UserDisplayName: Josh
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-04T14:28:45.100Z
Answers.Text: I don't think it would have damaged it, but it's possible mysql needs a restart to pick up the change. If you do `SELECT @@sql_mode;` you can confirm if ANSI is removed or not.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-07T03:44:16.567Z
Answers.Text: I should not have needed to but I needed to restart the database. Thanks!
Answers.UserDisplayName: Josh
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-04T12:33:47.350Z
Answers.LastActivityDate: 2022-02-04T12:33:47.350Z
Answers.UserDisplayName: Demerit
Body: <p>After making configuration changes to the Parameter Group for both the database and cluster of my Amazon Aurora database I can no longer access CiviCRM. I get the following error:
  Error code 19, &quot;DB Error: no such field&quot;. It has this for debug info:</p>
  <p><code>SELECT path, data, UNIX_TIMESTAMP(expired_date) AS expires FROM civicrm_cache WHERE group_name = &quot;2c60b3a2e8a19ac496e9716cc54d45a8&quot; [nativecode=1054 ** Unknown column '2c60b3a2e8a19ac496e9716cc54d45a8' in 'where clause']</code></p>
  <p>Before I made the changes to my server the entire Drupal site was only loading the install page with issues with the cache.  I believe this was because the max_allowed_packets was not large enough. I have now set the max_allowed_packets to the highest size using <em>Parameter Groups.</em></p>
  <p>Drupal cannot bootstrap and <em>cv flush</em> will not work either because it appears to be attempting to bootstrap Drupal. I have truncated the civicrm_cache table.  Before I did that there was a group_name value of <em>2c60b3a2e8a19ac496e9716cc54d45a8</em> in the table.</p>
  <p>I have Drupal 9.3.3. We have been running 9.3.3 for about a week before we have had problems. We have CiviCRM 5.45.2. We have been running this for about a week as well.</p>
  <p>I am not sure what to do to get CiviCRM to correct this query so that I can bootstrap everything.</p>
  <p>Thanks,</p>
  <p>Josh</p>
  
Tags: <database><core>
Title: Cannot Load Civi - Unknown column in civicrm_cache Select
ThreadText: # Cannot Load Civi - Unknown column in civicrm_cache Select
  
  (Asked by: username_0 on 2022-02-04)
  
  After making configuration changes to the Parameter Group for both the database and cluster of my Amazon Aurora database I can no longer access CiviCRM. I get the following error:
  Error code 19, "DB Error: no such field". It has this for debug info:
  
  `SELECT path, data, UNIX_TIMESTAMP(expired_date) AS expires FROM civicrm_cache WHERE group_name = "2c60b3a2e8a19ac496e9716cc54d45a8" [nativecode=1054 ** Unknown column '2c60b3a2e8a19ac496e9716cc54d45a8' in 'where clause']`
  
  Before I made the changes to my server the entire Drupal site was only loading the install page with issues with the cache. I believe this was because the max\_allowed\_packets was not large enough. I have now set the max\_allowed\_packets to the highest size using *Parameter Groups.*
  
  Drupal cannot bootstrap and *cv flush* will not work either because it appears to be attempting to bootstrap Drupal. I have truncated the civicrm\_cache table. Before I did that there was a group\_name value of *2c60b3a2e8a19ac496e9716cc54d45a8* in the table.
  
  I have Drupal 9.3.3. We have been running 9.3.3 for about a week before we have had problems. We have CiviCRM 5.45.2. We have been running this for about a week as well.
  
  I am not sure what to do to get CiviCRM to correct this query so that I can bootstrap everything.
  
  Thanks,
  
  username_0
  
  **Tags:** database, core
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-02-04. Score: 1 | Accepted answer
  
  When you made your config changes did you turn on ANSI or ANSI\_QUOTES in your sql\_mode?
  
  It prevents using `"` as a string quoting character which is not a standard string quoting character in sql, and so will break civi since civi does nonstandard things.
  
  > **Comments:**
  > **username_0**: Thank you but that is not how the database is configured now.  I did turn on ANSI but then I turned it off. Could I have damaged the database? I think I will restore from a clone just to see if that works.  
  > **username_1**: I don't think it would have damaged it, but it's possible mysql needs a restart to pick up the change. If you do `SELECT @@sql_mode;` you can confirm if ANSI is removed or not.  
  > **username_0**: I should not have needed to but I needed to restart the database. Thanks!  
  
  ---
  
  