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_idbigint(20) NOT NULL,product_or_parent_idbigint(20) NOT NULL,taxonomyvarchar(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_lookupWRITE;…]DATABASE ERROR: ‘Table ‘dbName.wp_wc_product_attributes_lookup’ doesn’t exist’
[SQL=/*!40000 ALTER TABLEwp_wc_product_attributes_lookupDISABLE KEYS */;…]DATABASE ERROR: ‘Table ‘dbName.wp_wc_product_attributes_lookup’ doesn’t exist’
[SQL=/*!40000 ALTER TABLEwp_wc_product_attributes_lookupENABLE 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.
