wp_wc_product_attributes_lookup exists
-
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 TABLEwp_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 TABLESwp_wc_product_attributes_lookup
WRITE;…]DATABASE ERROR: ‘Table ‘dbName.wp_wc_product_attributes_lookup’ doesn’t exist’
[SQL=/*!40000 ALTER TABLEwp_wc_product_attributes_lookup
DISABLE KEYS */;…]DATABASE ERROR: ‘Table ‘dbName.wp_wc_product_attributes_lookup’ doesn’t exist’
[SQL=/*!40000 ALTER TABLEwp_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.
- The topic ‘wp_wc_product_attributes_lookup exists’ is closed to new replies.