• Resolved user9876789

    (@user9876789)


    I’ve updated my dev site today from 4.4.1 to 4.6.0. The extra boxes weren’t showing after the upgrade, I downgraded to 4.4.1 and still not showing. (I didn’t check they were showing as I was doing all my updates so may not have shown on 4.4.1 either but I’d be surprised if they weren’t).

    I ran Query Monitor and it says:

    Table ‘xxxx_yith_wapo_blocks_assoc’ doesn’t exist

    I’ve checked and it doesn’t. I’ve tried resaving the product options but they still don’t show.

    The caller is YITH_WAPO_DB->yith_wapo_get_blocks_by_product()

    and the query is

    SELECT?blocks.id
    FROM?hgbpWZ6_yith_wapo_blocks as blocks
    WHERE?( visibility?IN?(‘1’) )
    AND?( id?IN?(
    SELECT?id
    FROM?hgbpWZ6_yith_wapo_blocks
    WHERE?vendor_id?IN?(‘0’) ) )
    AND?( ( id?IN?(
    SELECT?id
    FROM?hgbpWZ6_yith_wapo_blocks
    WHERE?product_association = ‘all’ )
    OR?id?IN?(
    SELECT?DISTINCT(id)
    FROM?hgbpWZ6_yith_wapo_blocks as i1?JOIN?hgbpWZ6_yith_wapo_blocks_assoc as a1 on a1.rule_id = i1.id
    WHERE?product_association = ‘products’
    AND?( type = ‘product’
    AND?object = ‘11628’ )
    OR?( type = ‘category’
    AND?object?IN?(‘1705’, ‘1707’, ‘1714’, ‘1716’, ’23’) ) ) )
    AND?( id?IN?(
    SELECT?id
    FROM?hgbpWZ6_yith_wapo_blocks
    WHERE?user_association?IN?( ‘all’, ‘logged_users’ ) )
    OR?id?IN?(
    SELECT?DISTINCT(id)
    FROM?hgbpWZ6_yith_wapo_blocks as i2?JOIN?hgbpWZ6_yith_wapo_blocks_assoc as a2 on a2.rule_id = i2.id
    WHERE?user_association = ‘user_roles’
    AND?( type = ‘user_role’
    AND?object?IN?(‘administrator’) ) )
    OR?id?IN?(
    SELECT?DISTINCT(id)
    FROM?hgbpWZ6_yith_wapo_blocks as i3?JOIN?hgbpWZ6_yith_wapo_blocks_assoc as a3 on a3.rule_id = i3.id
    WHERE?user_association = ‘membership’
    AND?( type = ‘membership’
    AND?object?IN?(‘0’) ) ) ) )
    AND?( id?NOT?IN?(
    SELECT?DISTINCT(rule_id)
    FROM?hgbpWZ6_yith_wapo_blocks as i4?JOIN?hgbpWZ6_yith_wapo_blocks_assoc as a4 on a4.rule_id = i4.id
    WHERE?exclude_products = 1
    AND?type = ‘excluded_product’
    AND?object = ‘11628’ )
    AND?id?NOT?IN?(
    SELECT?DISTINCT(rule_id)
    FROM?hgbpWZ6_yith_wapo_blocks as i5?JOIN?hgbpWZ6_yith_wapo_blocks_assoc as a5 on a5.rule_id = i5.id
    WHERE?exclude_products = 1
    AND?type = ‘excluded_category’
    AND?object?IN?(‘1705’, ‘1707’, ‘1714’, ‘1716’, ’23’) )
    AND?id?NOT?IN?(
    SELECT?DISTINCT(rule_id)
    FROM?hgbpWZ6_yith_wapo_blocks as i6?JOIN?hgbpWZ6_yith_wapo_blocks_assoc as a6 on a6.rule_id = i6.id
    WHERE?exclude_users = 1
    AND?type = ‘excluded_user_role’
    AND?object?IN?(‘administrator’) ) )
    ORDER?BY?priority

    Please can I advise how I get this table?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support crodriguez1991

    (@crodriguez1991)

    Hi there,

    I hope you’re doing well :D.

    Could you follow the steps described in this topic, please?

    In this way, the plugin will check about the db tables and try to restore it if it’s necessary.

    Note: Please try to do it on a staging site before to apply this code on a production site.

    Let us know the results.

    Thread Starter user9876789

    (@user9876789)

    Hello, I added the code to functions.php and went to https://yoursite.com/wp-admin/admin.php?page=yith_wapo_panel&yith_addon=1 (where yoursite.com was replaced with my site).

    I haven’t seen any change I’m afraid – I loaded the list of tables by going to https://xxx/wp-admin/admin.php?page=wc-status and scrolled down to the database section then refreshed after and there was no new entry for yith_wapo_blocks_assoc

    Plugin Support Alessio Torrisi

    (@alessio91)

    Hi there,

    please enable the debug mode in your site, execute again the code and let us know if you find any error in the log file.

    Thread Starter user9876789

    (@user9876789)

    Hello, I turned on debug but there were no errors and the table still does not exist – I’ve just looked again in the log and there hasnt been a mention of the issue since the 5th February – perhaps the issue has magically solved itself ??

    Plugin Support Alessio Torrisi

    (@alessio91)

    Hi there,

    what do you mean with “perhaps the issue has magically solved itself?” ?

    Can you use add-ons without problems?

    Thread Starter user9876789

    (@user9876789)

    What I mean is, the error was showing repeatedly in the error log without me triggering it (i.e I wasn’t clicking on anything in the admin of the YITH area). Now the error is no longer showing. I haven’t changed anything plugin wise and the table isn’t showing so I can’t explain why its no longer happening.

    This error was occurring on the development site, I tried to create a new block to see if that started the error and it didn’t, it gave me a different error instead. So I gave up and tried it on the live site, I didn’t want to show it on all products so I tried selecting show on a specific product and searching but it eventually hung and gave up.

    So I don’t know what’s happening. But for now I will close this as I don’t have a specific issue.

    Thread Starter user9876789

    (@user9876789)

    The error has come back. I will do some more troubleshooting

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Table ‘xxx_yith_wapo_blocks_assoc’ doesn’t exist’ is closed to new replies.