WP Database Errors: [Duplicate column name 'product_id']

[Deep]

Hello Tyler,

First of all - a great addon. Really looking forward to using this. However, I am getting the following errors continuously when your plugin is activated. The parent SLM plugin is active and so is WooCommerce

WordPress database error: [Duplicate column name 'product_id']
ALTER TABLE wp_lic_key_tbl ADD COLUMN product_id varchar(64) NOT NULL after txn_id

WordPress database error: [Duplicate column name 'variation_id']
ALTER TABLE wp_lic_key_tbl ADD COLUMN variation_id varchar(64) NOT NULL after product_id

WordPress database error: [Duplicate column name 'product_name']
ALTER TABLE wp_lic_key_tbl ADD COLUMN product_name varchar(64) NOT NULL after variation_id

WordPress database error: [Duplicate column name 'variation_attribute']
ALTER TABLE wp_lic_key_tbl ADD COLUMN variation_attribute varchar(64) NOT NULL after product_name

[Denny]

I have the same problem.

[Leopoldo Armesto]

I have the same problem. Any solution?

[Dominic McNamara]

Using v2.0 of slm_woocommerce. Same problem; any solution?

[El Stupid]

Same over here. This seems a 2.0 only issue. Apache log says:

*AH01071: Got error 'PHP message: WordPress databaseerror Duplicate column name 'product_id' at query ALTER TABLE wpe3_lic_key_tbl ADD COLUMN product_id varchar(64) NOT NULL after txn_id caused by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, slm_woocommerce_addon_setup_database_fields, require_once('/plugins/fluiditystudio-slm-woocommerce-addon/slm-woocommerce-installer.php')\nPHP message: WordPress databasefout Duplicate column name 'variation_id' bij query ALTER TABLE wpe3_lic_key_tbl ADD COLUMN variation_id varchar(64) NOT NULL after product_id caused by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, slm_woocommerce_addon_setup_database_fields, require_once('/plugins/fluiditystudio-slm-woocommerce-addon/slm-woocommerce-installer.php')\nPHP message: WordPress databasefout Duplicate column name 'product_name' bij query ALTER TABLE wpe3_lic_key_tbl ADD COLUMN product_name varchar(64) NOT NULL after variation_id caused by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, slm_woocommerce_addon_setup_database_fields, require_once('/plugins/fluiditystudio-slm-woocommerce-addon/slm-woocommerce-installer.php')\nPHP message: WordPress databasefout Duplicate column name 'variation_attribute' bij query ALTER TABLE wpe3_lic_key_tbl ADD COLUMN'

AH01071: Got error ' variation_attribute varchar(64) NOT NULL after product_name caused by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, slm_woocommerce_addon_setup_database_fields, require_once('/plugins/fluiditystudio-slm-woocommerce-addon/slm-woocommerce-installer.php')\n'*

[Tyler Robinson]

I have just committed a fix for this issue!