Answers.Body: <p>Ok, again solved my own problem after doing more research.  This apparently is a known issue with mySql and MariaDB where strict mode seems to be default.  Adding sql_mode=""
  to your /etc/my.cnf file will resolve the issue.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-07T16:07:47.573Z
Answers.Text: Thanks for this! This helped us out this morning.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-26T01:55:06.530Z
Answers.LastActivityDate: 2018-11-26T01:55:06.530Z
Answers.UserDisplayName: Norm Dressler
Answers.Body: <p>For anyone happening upon this - the proposed solution is not correct. CiviCRM should function with STRICT mode enabled, which is enabled to ensure data integrity - turning it off is just ignoring the unlaying problem. If you come across an error like this one it should be reported so it can be fixed.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-08T19:26:12.217Z
Answers.LastActivityDate: 2020-06-08T19:26:12.217Z
Answers.UserDisplayName: freeform.steph
Body: <p>I've generated a new report in my extension, but when I try to register it with CiviReport, I'm getting the following DB error:
  Database Error Code: Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value, 1423
  Additional Details:
  Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )</p>
  
  <pre><code>[code] =&gt; -1
  [message] =&gt; DB Error: unknown error
  [mode] =&gt; 16
  [debug_info] =&gt; INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]
  [type] =&gt; DB_Error
  [user_info] =&gt; INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]
  [to_string] =&gt; [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]"]
  </code></pre>
  
  <p>)</p>
  
  <p>I know it is likely related wp_globus plugin?  I do have two languages on my site - english and french.  </p>
  
Tags: <civireport><developer>
Title: CiviReport - Error when registering new Report
ThreadText: # CiviReport - Error when registering new Report
  
  (Asked by: username_0 on 2018-11-25)
  
  I've generated a new report in my extension, but when I try to register it with CiviReport, I'm getting the following DB error:
  Database Error Code: Field of view 'sporti62\_wp4.civicrm\_option\_value\_en\_CA' underlying table doesn't have a default value, 1423
  Additional Details:
  Array
  (
  [callback] => Array
  (
  [0] => CRM\_Core\_Error
  [1] => handle
  )
  
  ```
  [code] => -1
  [message] => DB Error: unknown error
  [mode] => 16
  [debug_info] => INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]
  [type] => DB_Error
  [user_info] => INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]
  [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , name , filter , is_default , weight , description , is_optgroup , is_active , component_id ) VALUES ( 41 , 'Dog Registry with Contacts' , 'dogregistry/contacts' , 'CRM_Dogregistry_Form_Report_Dog_Contact_Summary' ,  0 ,  0 ,  90 , 'Dog Registry with Contacts' ,  0 ,  1 ,  NULL )  [nativecode=1423 ** Field of view 'sporti62_wp4.civicrm_option_value_en_CA' underlying table doesn't have a default value]"]
  
  ```
  
  )
  
  I know it is likely related wp\_globus plugin? I do have two languages on my site - english and french.
  
  **Tags:** civireport, developer
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2018-11-26. Score: 2 | Accepted answer
  
  Ok, again solved my own problem after doing more research. This apparently is a known issue with mySql and MariaDB where strict mode seems to be default. Adding sql\_mode=""
  to your /etc/my.cnf file will resolve the issue.
  
  > **Comments:**
  > **username_1**: Thanks for this! This helped us out this morning.  
  
  ---
  
  ### Answer by username_2 on 2020-06-08. Score: 1
  
  For anyone happening upon this - the proposed solution is not correct. CiviCRM should function with STRICT mode enabled, which is enabled to ensure data integrity - turning it off is just ignoring the unlaying problem. If you come across an error like this one it should be reported so it can be fixed.
  
  
  ---
  
  