wp_wc_product_attributes_lookup exists | WordPress.org

[ad_1]

I got this at the end of otherwise successful unpack and install using a pre-existing local database “dbName” in a site with Woocommerce:

DATABASE ERROR: ‘Tablespace ‘dbName.wp_wc_product_attributes_lookup‘ exists.’
[SQL=CREATE TABLE wp_wc_product_attributes_lookup (
product_id bigint(20) NOT NULL,
product_or_parent_id bigint(20) NOT NULL,
taxonomy varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`…]

DATABASE ERROR: ‘Table ‘dbName.wp_wc_product_attributes_lookup’ doesn’t exist’
[SQL=LOCK TABLES wp_wc_product_attributes_lookup WRITE;…]

DATABASE ERROR: ‘Table ‘dbName.wp_wc_product_attributes_lookup’ doesn’t exist’
[SQL=/*!40000 ALTER TABLE wp_wc_product_attributes_lookup DISABLE KEYS */;…]

DATABASE ERROR: ‘Table ‘dbName.wp_wc_product_attributes_lookup’ doesn’t exist’
[SQL=/*!40000 ALTER TABLE wp_wc_product_attributes_lookup ENABLE KEYS */;…]

I interpret this as first the table wp_wc_product_attributes_lookup exists. This wasn’t so before installation as I had deleted all tables and had verified this, so Duplicator install must have created this table along with all the other ones in my backup. Apparently it’s then deleted, which appears to be a problem.
There is indeed something odd with this database as if I try to create this table anew, it’s not possible as it exists. Yet I cannot list it.

So created a new database and this time the above did not occur, so I’m posting this in case someone else encounters the same thing. I’m not sure what’s the state of the older database that was involved in causing this.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer