Table ‘xxx_yith_wapo_blocks_assoc’ doesn’t exist
-
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?priorityPlease can I advise how I get this table?
- The topic ‘Table ‘xxx_yith_wapo_blocks_assoc’ doesn’t exist’ is closed to new replies.