Answers.Body: <p>Fixed by upgrading to Civi 5.23</p>
  
  <p>However this may also be relevant: <a href="https://civicrm.stackexchange.com/questions/34907/solved-civimobile-db-error-in-adding-a-participant-to-an-event">SOLVED CiviMobile: DB Error in adding a Participant to an Event</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-06T16:31:44.443Z
Answers.Text: Any action that causes the advanced logging schema to be checked - upgrading CiviCRM, installing or enabling an extension, etc. will fix this problem.  Arguably it should be happening on extension upgrade to avoid this issue - I don't have time to write that patch but it would be fairly simple.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-06T04:22:50.560Z
Answers.LastActivityDate: 2020-03-06T04:22:50.560Z
Answers.UserDisplayName: josh
Body: <p>Using CiviCRM 5.20.2 on Drupal 7.69.</p>
  
  <p>Having a new error whenever someone tries to register for an event through CiviEvent on our website. This happens for all events: private or public; those with custom fields and those with no custom fields; with confirmation screens turned on or off; with thank you emails turned on or off. The event is free/no payment processing.</p>
  
  <p>The user sees this screen:</p>
  
  <p><a href="https://i.sstatic.net/ayEGc.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ayEGc.png" alt="DB Error: no such field"></a></p>
  
  <p>The registration does not pull through on the back-end either.</p>
  
  <p>This is the error message in the error log:</p>
  
  <pre><code>$Fatal Error Details = Array ( [callback] =&gt; Array ( [0] =&gt; CRM_Core_Error [1] =&gt; handle ) [code] =&gt; -19 [message] =&gt; DB Error: no
  such field [mode] =&gt; 16 [debug_info] =&gt; INSERT INTO
  civicrm_contact_push_notification_messages (contact_id , data ,
  message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
  '%display_name has created participant.' , 'Participant' , 2699 )
  [nativecode=1054 ** Unknown column 'data' in 'field list'] [type] =&gt;
  DB_Error [user_info] =&gt; INSERT INTO
  civicrm_contact_push_notification_messages (contact_id , data ,
  message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
  '%display_name has created participant.' , 'Participant' , 2699 )
  [nativecode=1054 ** Unknown column 'data' in 'field list'] [to_string]
  =&gt; [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO
  civicrm_contact_push_notification_messages (contact_id , data ,
  message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
  '%display_name has created participant.' , 'Participant' , 2699 )
  [nativecode=1054 ** Unknown column 'data' in 'field list']"] )
  </code></pre>
  
  <p>Any clue how to fix this? </p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-03-06T00:09:01.983Z
Comments.Text: Does this answer your question? [SOLVED CiviMobile: DB Error in adding a Participant to an Event](https://civicrm.stackexchange.com/questions/34907/solved-civimobile-db-error-in-adding-a-participant-to-an-event)
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-03-06T00:32:47.827Z
Comments.Text: @JonG-MegaphoneTech I fixed it by upgrading to Civi 5.23, but that thread seems relevant as well. Should I accept the edit in this case?
Comments.UserDisplayName: josh
Tags: <civievent><error>
Title: 'DB Error: no such field' for all (free) event registrations
ThreadText: # 'DB Error: no such field' for all (free) event registrations
  
  (Asked by: username_0 on 2020-03-05)
  
  Using CiviCRM 5.20.2 on Drupal 7.69.
  
  Having a new error whenever someone tries to register for an event through CiviEvent on our website. This happens for all events: private or public; those with custom fields and those with no custom fields; with confirmation screens turned on or off; with thank you emails turned on or off. The event is free/no payment processing.
  
  The user sees this screen:
  
  [![DB Error: no such field](https://i.sstatic.net/ayEGc.png)](https://i.sstatic.net/ayEGc.png)
  
  The registration does not pull through on the back-end either.
  
  This is the error message in the error log:
  
  ```
  $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -19 [message] => DB Error: no
  such field [mode] => 16 [debug_info] => INSERT INTO
  civicrm_contact_push_notification_messages (contact_id , data ,
  message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
  '%display_name has created participant.' , 'Participant' , 2699 )
  [nativecode=1054 ** Unknown column 'data' in 'field list'] [type] =>
  DB_Error [user_info] => INSERT INTO
  civicrm_contact_push_notification_messages (contact_id , data ,
  message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
  '%display_name has created participant.' , 'Participant' , 2699 )
  [nativecode=1054 ** Unknown column 'data' in 'field list'] [to_string]
  => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO
  civicrm_contact_push_notification_messages (contact_id , data ,
  message , entity_table , entity_id ) VALUES ( 6820 , 'Array' ,
  '%display_name has created participant.' , 'Participant' , 2699 )
  [nativecode=1054 ** Unknown column 'data' in 'field list']"] )
  
  ```
  
  Any clue how to fix this?
  
  **Tags:** civievent, error
  
  > **Comments:**
  > **username_1**: Does this answer your question? [SOLVED CiviMobile: DB Error in adding a Participant to an Event](https://civicrm.stackexchange.com/questions/34907/solved-civimobile-db-error-in-adding-a-participant-to-an-event)  
  > **username_0**: @username_1 I fixed it by upgrading to Civi 5.23, but that thread seems relevant as well. Should I accept the edit in this case?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-03-06. Score: 2 | Accepted answer
  
  Fixed by upgrading to Civi 5.23
  
  However this may also be relevant: [SOLVED CiviMobile: DB Error in adding a Participant to an Event](https://civicrm.stackexchange.com/questions/34907/solved-civimobile-db-error-in-adding-a-participant-to-an-event)
  
  > **Comments:**
  > **username_1**: Any action that causes the advanced logging schema to be checked - upgrading CiviCRM, installing or enabling an extension, etc. will fix this problem.  Arguably it should be happening on extension upgrade to avoid this issue - I don't have time to write that patch but it would be fairly simple.  
  
  ---
  
  