[Unknown column ‘product_association’ in ‘where clause’

Hi there,

I hope you’re doing well. I checked the page you mentioned and could see the issue you mentioned, and it’s possible there was an issue when migrating from the previous version to the new one.

In this case, I suggest you add the following PHP code in the functions.php file of your current theme:

if ( ! function_exists( 'yith_wapo_check_db_400' ) ) {
    function yith_wapo_check_db_400() {

        // Add ?yith_addons=1 to the URL inside the admin panel will execute all the code.
        if ( isset( $_GET['yith_addons'] ) ) {

            global $wpdb;
            require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

            $blocks_table = $wpdb->prefix . 'yith_wapo_blocks';
            $assoc_table = $wpdb->prefix . 'yith_wapo_blocks_assoc';

            $charset_collate = $wpdb->get_charset_collate();

            // 1. BLOCKS TABLE - START
            $sql_blocks = "CREATE TABLE {$wpdb->prefix}yith_wapo_blocks (
                        id                  INT(3) NOT NULL AUTO_INCREMENT,
                        user_id             BIGINT(20),
                        vendor_id           BIGINT(20),
                        settings            LONGTEXT,
                        priority            DECIMAL(9,5),
                        visibility          INT(1),
                        creation_date       TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
                        last_update         TIMESTAMP,
                        name                varchar(255) NOT NULL,
                        product_association varchar(255),
                        exclude_products    tinyint(1) NOT NULL,
                        user_association    varchar(255),
                        exclude_users       tinyint(1) NOT NULL,
                        PRIMARY KEY (id)
                    ) $charset_collate;";

            if ( function_exists( 'maybe_create_table' ) ) {
                maybe_create_table( $blocks_table, $sql_blocks );
            }

            // CREATE COLUMNS FOR BLOCKS TABLE.
            $blocks_columns = array(
                'name'                => 'ALTER TABLE ' . $blocks_table . ' ADD name varchar(255) NOT NULL;',
                'product_association' => 'ALTER TABLE ' . $blocks_table . ' ADD product_association varchar(255);',
                'exclude_products'    => 'ALTER TABLE ' . $blocks_table . ' ADD exclude_products tinyint(1) NOT NULL;',
                'user_association'    => 'ALTER TABLE ' . $blocks_table . ' ADD user_association varchar(255);',
                'exclude_users'       => 'ALTER TABLE ' . $blocks_table . ' ADD exclude_users tinyint(1) NOT NULL;',
            );

            foreach ( $blocks_columns as $block_column => $block_statement ){
                if ( function_exists( 'maybe_add_column' ) ) {
                    maybe_add_column($blocks_table, $block_column, $block_statement);
                }
            }

            // BLOCKS TABLE - END

            // 2. BLOCKS ASSOC TABLE - START

            $sql_associations = "CREATE TABLE {$wpdb->prefix}yith_wapo_blocks_assoc (
                        rule_id bigint(20) NOT NULL,
                        object varchar(255) NOT NULL,
                        type varchar(50) NOT NULL,
                        KEY type (type),
                        KEY object (object)
                    ) $charset_collate;";

            if ( function_exists( 'maybe_create_table' ) ) {
                maybe_create_table($assoc_table, $sql_associations);
            }

            // CREATE COLUMNS FOR ASSOCIATION TABLE.
            $assoc_columns = array(
                'rule_id' => 'ALTER TABLE ' . $assoc_table . ' ADD rule_id varchar(255) NOT NULL;',
                'object'  => 'ALTER TABLE ' . $assoc_table . ' ADD object varchar(255) NOT NULL;',
                'type'    => 'ALTER TABLE ' . $assoc_table . ' ADD type varchar(50) NOT NULL;',
            );

            foreach ( $assoc_columns as $assoc_column => $assoc_statement ){
                if ( function_exists( 'maybe_add_column' ) ) {
                    maybe_add_column($assoc_table, $assoc_column, $assoc_statement);
                }
            }

            // BLOCKS ASSOC TABLE - END

            // 3. UPDATE OPTION - START
            update_option( 'yith_wapo_db_update_scheduled_for', '2.0.0' );
            update_option( 'yith_wapo_db_version_option', '2.0.0' );
            //UPDATE OPTION - END

        }
    }
    add_action( 'admin_init', 'yith_wapo_check_db_400' );
}

Then go to the following link (replace yoursite.com with the URL of the site):

https://yoursite.com/wp-admin/admin.php?page=yith_wapo_panel&yith_addon=1

This should create the database tables that are missing and solve the issue. Once you’re sure it’s working, you can remove the code.

We’ll remain at your disposal.