Title: Encoutering database error
Last modified: November 28, 2022

---

# Encoutering database error

 *  Resolved [merkmeester](https://wordpress.org/support/users/merkmeester/)
 * (@merkmeester)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/encoutering-database-error/)
 * Hi guys, I am encountering a database error when editing/saving attributes in
   the backend (see screenshot).
 *     ```
       SELECT wp_braapf_variable_attributes.post_id as post_id, wp_braapf_variable_attributes.post_id as parent_id, wp_braapf_variable_attributes.attribute as meta_key, wp_term_taxonomy.term_id as meta_value_id, 0 as stock_status FROM wp_braapf_variable_attributes JOIN wp_term_relationships ON wp_braapf_variable_attributes.post_id = wp_term_relationships.object_id JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id AND wp_term_taxonomy.taxonomy = wp_braapf_variable_attributes.attribute LEFT JOIN wp_braapf_product_variation_attributes ON wp_braapf_product_variation_attributes.parent_id = wp_braapf_variable_attributes.post_id AND wp_braapf_product_variation_attributes.meta_value_id = wp_term_taxonomy.term_id WHERE wp_braapf_product_variation_attributes.meta_value_id IS NULL AND wp_braapf_variable_attributes.post_id = 1140
       ```
   
 * [https://snipboard.io/SVHYNr.jpg](https://snipboard.io/SVHYNr.jpg)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [merkmeester](https://wordpress.org/support/users/merkmeester/)
 * (@merkmeester)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/encoutering-database-error/#post-16240976)
 * In addition, this is what I am trying to do:
    [https://snipboard.io/mdcORq.jpg](https://snipboard.io/mdcORq.jpg)
 *  Plugin Author [Dmytro Holovnia](https://wordpress.org/support/users/dholovnia/)
 * (@dholovnia)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/encoutering-database-error/#post-16241041)
 * Hi,
 * We will add a validation for this in the next version. This will prevent issue
   but not fix it for you.
 * You need to set tables to the same collation through the phpmyadmin or hosting
   support. What collation to choose is up to you. I’d recommend default for your
   database configuration.
 * Regards,
    Dmytro
 *  Thread Starter [merkmeester](https://wordpress.org/support/users/merkmeester/)
 * (@merkmeester)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/encoutering-database-error/#post-16241055)
 * Hi Dmytro,
 * Thanks for your quick response.
    Could you share a query to change all tables
   to the same collation in phpmyadmin?
 * Regards,
    Christiaan
 *  Thread Starter [merkmeester](https://wordpress.org/support/users/merkmeester/)
 * (@merkmeester)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/encoutering-database-error/#post-16241066)
 * Nevermind, it’s an option in phpmyadmin ;-).
    My issue is now resolved!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Encoutering database error’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce-ajax-filters/assets/icon-256x256.gif?rev=2770304)
 * [Advanced AJAX Product Filters](https://wordpress.org/plugins/woocommerce-ajax-filters/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-ajax-filters/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-ajax-filters/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-ajax-filters/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-ajax-filters/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-ajax-filters/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [merkmeester](https://wordpress.org/support/users/merkmeester/)
 * Last activity: [3 years, 4 months ago](https://wordpress.org/support/topic/encoutering-database-error/#post-16241066)
 * Status: resolved