Encoutering database error

  • Resolved merkmeester

    (@merkmeester)


    3 years, 4 months ago

    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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter merkmeester

    (@merkmeester)

    3 years, 4 months ago

    In addition, this is what I am trying to do:
    https://snipboard.io/mdcORq.jpg

    Plugin Author Dmytro Holovnia

    (@dholovnia)

    3 years, 4 months ago

    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

    (@merkmeester)

    3 years, 4 months ago

    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

    (@merkmeester)

    3 years, 4 months ago

    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.