Answers.Body: <p>Is it mysql 8? Grouping is a reserved word in mysql 8 and civicrm doesn't officially support it yet.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-09T18:00:54.190Z
Answers.Text: This was the problem for me.
Answers.UserDisplayName: Tyler Shuster
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-03T05:25:37.713Z
Answers.LastActivityDate: 2019-03-03T05:25:37.713Z
Answers.UserDisplayName: Demerit
Body: <p>I was testing out CiviCRM as part of a project I am working on and decided to host it in AWS on a WordPress site.  After downloading the newest version (5.10.4), I then uploaded the Zip file to my site.  I activated the plugin and proceeded to install CiviCRM accordingly.  </p>
  
  <p>To make my life easier, I created a new user with admin permissions and created a separate database for CiviCRM.  So far, so good.  I kick off the installation and everything shows up as good and the message you get post install pops up letting you know about settings, etc.  Shortly after this message appears, I get the dreaded db error message due to a syntax issue.  </p>
  
  <p>I looked at the logs and noticed that there is a fatal error that is one part syntax and another part where the actual tables don't seem to be within the database that CiviCRM created during installation.  I have tried a few different variants, such as older versions of CiviCRM, some cases where I did not create the separate database and user which spun off different errors, but there seems to be a theme of some type of syntax error <strong>(Mind you, I am not writing this SQL, the application is generating it)</strong>.  Also, the tables this is referencing, don't seem to be anywhere in the MySQL database, which is confusing to me.  See below for a snip of the log file with what I am receiving.  Any assistance or advice you all can give as to why this is occurring and how I can possibly remedy it?  </p>
  
  <p>Thank you in advance!  </p>
  
  <pre><code>Mar 02 23 : 46 : 59 [info] Creating canary TABLE Mar 02 23 : 47 : 05 [info] $FATAL Error Details = Array([callback] = &gt; Array([0] = &gt; CRM_Core_Error [1] = &gt; handle) [code] = &gt; - 2 [message] = &gt; DB Error: syntax error [mode] = &gt; 16 [debug_info] = &gt; SELECT v.label AS label, v.name AS value, v.grouping AS grouping FROM civicrm_option_value v
      ,civicrm_option_group g WHERE v.option_group_id = g.id
      AND g.name = 'languages'
      AND g.is_active = 1
      AND v.is_active = 1
      AND (
          v.component_id IS NULL
          OR v.component_id IN (
              SELECT id
              FROM civicrm_component
              WHERE name IN (
                      "CiviEvent"
                      ,"CiviContribute"
                      ,"CiviMember"
                      ,"CiviMail"
                      ,"CiviReport"
                      ,"CiviPledge"
                      )
              )
          ) ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value v, civicrm_option_group g WHERE  v.o' at line 1] [type] = &gt; DB_Error [user_info] = &gt; SELECT v.label AS label, v.name AS value, v.grouping AS grouping FROM civicrm_option_value v
      ,civicrm_option_group g WHERE v.option_group_id = g.id
      AND g.name = 'languages'
      AND g.is_active = 1
      AND v.is_active = 1
      AND (
          v.component_id IS NULL
          OR v.component_id IN (
              SELECT id
              FROM civicrm_component
              WHERE name IN (
                      "CiviEvent"
                      ,"CiviContribute"
                      ,"CiviMember"
                      ,"CiviMail"
                      ,"CiviReport"
                      ,"CiviPledge"
                      )
              )
          ) ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value v, civicrm_option_group g
  </code></pre>
  
Tags: <wordpress><aws>
Title: CiviCRM - Installing on Wordpress Hosted in AWS DB Error
ThreadText: # CiviCRM - Installing on Wordpress Hosted in AWS DB Error
  
  (Asked by: username_0 on 2019-03-03)
  
  I was testing out CiviCRM as part of a project I am working on and decided to host it in AWS on a WordPress site. After downloading the newest version (5.10.4), I then uploaded the Zip file to my site. I activated the plugin and proceeded to install CiviCRM accordingly.
  
  To make my life easier, I created a new user with admin permissions and created a separate database for CiviCRM. So far, so good. I kick off the installation and everything shows up as good and the message you get post install pops up letting you know about settings, etc. Shortly after this message appears, I get the dreaded db error message due to a syntax issue.
  
  I looked at the logs and noticed that there is a fatal error that is one part syntax and another part where the actual tables don't seem to be within the database that CiviCRM created during installation. I have tried a few different variants, such as older versions of CiviCRM, some cases where I did not create the separate database and user which spun off different errors, but there seems to be a theme of some type of syntax error **(Mind you, I am not writing this SQL, the application is generating it)**. Also, the tables this is referencing, don't seem to be anywhere in the MySQL database, which is confusing to me. See below for a snip of the log file with what I am receiving. Any assistance or advice you all can give as to why this is occurring and how I can possibly remedy it?
  
  Thank you in advance!
  
  ```
  Mar 02 23 : 46 : 59 [info] Creating canary TABLE Mar 02 23 : 47 : 05 [info] $FATAL Error Details = Array([callback] = > Array([0] = > CRM_Core_Error [1] = > handle) [code] = > - 2 [message] = > DB Error: syntax error [mode] = > 16 [debug_info] = > SELECT v.label AS label, v.name AS value, v.grouping AS grouping FROM civicrm_option_value v
      ,civicrm_option_group g WHERE v.option_group_id = g.id
      AND g.name = 'languages'
      AND g.is_active = 1
      AND v.is_active = 1
      AND (
          v.component_id IS NULL
          OR v.component_id IN (
              SELECT id
              FROM civicrm_component
              WHERE name IN (
                      "CiviEvent"
                      ,"CiviContribute"
                      ,"CiviMember"
                      ,"CiviMail"
                      ,"CiviReport"
                      ,"CiviPledge"
                      )
              )
          ) ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value v, civicrm_option_group g WHERE  v.o' at line 1] [type] = > DB_Error [user_info] = > SELECT v.label AS label, v.name AS value, v.grouping AS grouping FROM civicrm_option_value v
      ,civicrm_option_group g WHERE v.option_group_id = g.id
      AND g.name = 'languages'
      AND g.is_active = 1
      AND v.is_active = 1
      AND (
          v.component_id IS NULL
          OR v.component_id IN (
              SELECT id
              FROM civicrm_component
              WHERE name IN (
                      "CiviEvent"
                      ,"CiviContribute"
                      ,"CiviMember"
                      ,"CiviMail"
                      ,"CiviReport"
                      ,"CiviPledge"
                      )
              )
          ) ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouping FROM   civicrm_option_value v, civicrm_option_group g
  
  ```
  
  **Tags:** wordpress, aws
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-03-03. Score: 2
  
  Is it mysql 8? Grouping is a reserved word in mysql 8 and civicrm doesn't officially support it yet.
  
  > **Comments:**
  > **username_2**: This was the problem for me.  
  
  ---
  
  