• Hello,

    My site is updated to WordPress 5.4.2 and Woocommerce 4.3.1.

    Then I got this notification: “Seems you have some issue with Product lookup tables. Please try to remove all data from table wp_wc_product_meta_lookup and regenerate it in WooCommerce -> Status -> Tools”.

    Followed the instructions. However it seems the regeneration got stuck.
    I could find the following error:

    [query] => CREATE TABLE wp_braapf_term_taxonomy_hierarchical (
    term_taxonomy_id bigint(20) NOT NULL,
    term_id bigint(20) NOT NULL,
    term_taxonomy_child_id bigint(20) NOT NULL,
    term_child_id bigint(20) NOT NULL,
    taxonomy varchar(32) NOT NULL,
    INDEX term_taxonomy_id (term_taxonomy_id),
    INDEX term_taxonomy_child_id (term_taxonomy_child_id),
    INDEX child_parent_id (term_taxonomy_id, term_taxonomy_child_id),
    UNIQUE uniqueid (term_taxonomy_id, term_id, term_taxonomy_child_id, term_child_id)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    [error] => Array
    (
    [wp_braapf_term_taxonomy_hierarchical] => Created table wp_braapf_term_taxonomy_hierarchical
    )

    [cron] => ENABLED”

    However, it seems I am out of ideas how to overcome this issue.
    Any guidance would be highly appreciated. Thank you for your time in advance.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author RazyRx

    (@razyrx)

    Hello @steve7,

    You can try to restart regeneration, in plugin settings -> Add-ons tab disable “Additional Tables” add-on and save settings, then enable “Additional Tables” add-on and save settings.

    Regards,
    Oleg

Viewing 1 replies (of 1 total)
  • The topic ‘Additional tables are generating’ is closed to new replies.