I upgraded WooCommerce to 2.1.0 as well, and while I am having the same problems as others. I have been locked out of the back end dashboard as well with the following error msg: (actual domain name edited)
WordPress database error Incorrect table definition; there can be only one auto column and it must be defined as a key for query ALTER TABLE wp_woocommerce_downloadable_product_permissions ADD COLUMN permission_id bigint(20) NOT NULL auto_increment made by require_once(‘D:\inetpub\vhosts\xxxmydomainxxx.com\httpdocs\wp-admin\admin.php’), do_action(‘admin_init’), call_user_func_array, WC_Install->check_version, WC_Install->install, WC_Install->create_tables, dbDelta
WordPress database error Key column ‘permission_id’ doesn’t exist in table for query ALTER TABLE wp_woocommerce_downloadable_product_permissions ADD PRIMARY KEY (permission_id) made by require_once(‘D:\inetpub\vhosts\xxxmydomainxxx.com\httpdocs\wp-admin\admin.php’), do_action(‘admin_init’), call_user_func_array, WC_Install->check_version, WC_Install->install, WC_Install->create_tables, dbDelta
How do I get out of this mess when I haven’t got access to the dashboard? I am guessing I need to downgrade via ftp, but what Woo files do I need to replace?
cheers.