• Resolved magdamunro

    (@magdamunro)


    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.

  • The topic ‘wp_wc_product_attributes_lookup exists’ is closed to new replies.