Answers.Body: <ol>
  <li>In civi go to support - api3 explorer.</li>
  <li>Choose System for the entity and utf8conversion for the action.</li>
  <li>For parameter choose csv list of table patterns. Type in <code>civicrm_booking%</code>.</li>
  <li>Click execute.</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-15T17:40:54.633Z
Answers.Text: Thank you for the solution. This resolved the above errors. However, after creating a booking successfully, upon searching for all bookings to find the booking I jus created, none could be found. It seems like bookings are not being saved. I get this error:
  
  The requested booking record does not exist (possibly the record was deleted).
Answers.UserDisplayName: Sudesh
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-15T17:46:03.427Z
Answers.Text: I'm not familiar with the extension and not many people are going to see the comment here. It's better to post a new question since it sounds like a different issue.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-14T15:34:50.173Z
Answers.LastActivityDate: 2024-07-14T15:34:50.173Z
Answers.UserDisplayName: Demerit
Body: <p>I'm running Wordpress 6.5.5 with CiviCRM 5.74.2. Civibooking installed fine. When I click on the booking menu to go into &quot;Find Bookings&quot; or &quot;New Booking&quot;, I get a &quot;DB Error: unknown error&quot;. Upon enabling debug, I get the following. Any idea on what's going wrong and how to resolve?</p>
  <p>Type    DB_Error
  Code    -1
  Message DB Error: unknown error
  Mode    16
  UserInfo    SELECT v.id, v.label, v.value, v.option_group_id, r.weight FROM civicrm_option_value v INNER JOIN civicrm_booking_resource r ON v.option_group_id = 110 AND r.type_id = v.value AND v.is_active = 1 WHERE 1 AND r.is_unlimited = 0 ORDER BY r.weight [nativecode=1267 ** Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']</p>
  <p>DebugInfo   SELECT v.id, v.label, v.value, v.option_group_id, r.weight FROM civicrm_option_value v INNER JOIN civicrm_booking_resource r ON v.option_group_id = 110 AND r.type_id = v.value AND v.is_active = 1 WHERE 1 AND r.is_unlimited = 0 ORDER BY r.weight [nativecode=1267 ** Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']</p>
  <p>Civi\Core\Exception\DBQueryException: DB Error: unknown error in /mysite/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 945</p>
  <ul>
  <li>DB_Error: DB Error: unknown error in unknown on line unknown</li>
  </ul>
  
Tags: <civibooking>
Title: CiviBooking 1.6 - DB Error
ThreadText: # CiviBooking 1.6 - DB Error
  
  (Asked by: username_0 on 2024-07-13)
  
  I'm running Wordpress 6.5.5 with CiviCRM 5.74.2. Civibooking installed fine. When I click on the booking menu to go into "Find Bookings" or "New Booking", I get a "DB Error: unknown error". Upon enabling debug, I get the following. Any idea on what's going wrong and how to resolve?
  
  Type DB\_Error
  Code -1
  Message DB Error: unknown error
  Mode 16
  UserInfo SELECT v.id, v.label, v.value, v.option\_group\_id, r.weight FROM civicrm\_option\_value v INNER JOIN civicrm\_booking\_resource r ON v.option\_group\_id = 110 AND r.type\_id = v.value AND v.is\_active = 1 WHERE 1 AND r.is\_unlimited = 0 ORDER BY r.weight [nativecode=1267 \*\* Illegal mix of collations (utf8mb4\_general\_ci,IMPLICIT) and (utf8mb4\_unicode\_ci,IMPLICIT) for operation '=']
  
  DebugInfo SELECT v.id, v.label, v.value, v.option\_group\_id, r.weight FROM civicrm\_option\_value v INNER JOIN civicrm\_booking\_resource r ON v.option\_group\_id = 110 AND r.type\_id = v.value AND v.is\_active = 1 WHERE 1 AND r.is\_unlimited = 0 ORDER BY r.weight [nativecode=1267 \*\* Illegal mix of collations (utf8mb4\_general\_ci,IMPLICIT) and (utf8mb4\_unicode\_ci,IMPLICIT) for operation '=']
  
  Civi\Core\Exception\DBQueryException: DB Error: unknown error in /mysite/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 945
  
  * DB\_Error: DB Error: unknown error in unknown on line unknown
  
  **Tags:** civibooking
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-07-14. Score: 1 | Accepted answer
  
  1. In civi go to support - api3 explorer.
  2. Choose System for the entity and utf8conversion for the action.
  3. For parameter choose csv list of table patterns. Type in `civicrm_booking%`.
  4. Click execute.
  
  > **Comments:**
  > **username_0**: Thank you for the solution. This resolved the above errors. However, after creating a booking successfully, upon searching for all bookings to find the booking I jus created, none could be found. It seems like bookings are not being saved. I get this error:  The requested booking record does not exist (possibly the record was deleted).  
  > **username_1**: I'm not familiar with the extension and not many people are going to see the comment here. It's better to post a new question since it sounds like a different issue.  
  
  ---
  
  