Cant add new options blocks or modify titles of existing ones

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.

Hi, thank you for your reply. I tried this on a staging site, and it didn’t make any difference. Still having the same issue.

Same issue here since a couple of days. All my blocks had names and now suddenly they are all called [name] . While editing a block, you can enter a name in the field ‘Name’ but after saving, it turns back to this page and the field is empty. By clicking the ‘back button’ in your browser in red letters underneath the field is written ‘Name required’

I ended up deleting all my blocks with the idea to create them new from scratch, but the plugin doesn’t save anything at all anymore… No names, no options, nothing

Another strange things I now see is by ‘show in categories’ , it adds a weird category called #czowOiliOw== which isn’t a category at my site.

• This reply was modified 1 year, 5 months ago by kapmi.

Hi there,

can you check if these tables exist in your database?

• yith_wapo_blocks
• yith_wapo_blocks_assoc

If possible, please send us a screenshot where is possible see all columns contained in these 2 tables.

Hi Alessio, thanks for your reply. You mentioned two tables. Only yith_wapo_blocks exists in the database. yith_wapo_blocks_assoc isn’t there at all.

Column Type Comment

id int(3) Auto Increment

user_id bigint(20) NULL

vendor_id bigint(20) NULL

settings longtext NULL

priority decimal(9,5) NULL

visibility int(1) NULL

creation_date timestamp [current_timestamp()]

last_update timestamp [0000-00-00 00:00:00]

When the plugin is activated I get this error message on my front-end for each product that has extra product associations.

WordPress database error: [Unknown column ‘product_association’ in ‘where clause’]

SELECT blocks.id FROM wpdh_yith_wapo_blocks as blocks WHERE ( visibility = 1 ) AND ( id IN ( SELECT id FROM wpdh_yith_wapo_blocks WHERE vendor_id IN (‘0’) ) ) AND ( ( id IN ( SELECT id FROM wpdh_yith_wapo_blocks WHERE product_association = ‘all’ ) OR id IN ( SELECT DISTINCT(id) FROM wpdh_yith_wapo_blocks as i1 JOIN wpdh_yith_wapo_blocks_assoc as a1 on a1.rule_id = i1.id WHERE product_association = ‘products’ AND ( type = ‘product’ AND object = ‘3191’ ) OR ( type = ‘category’ AND object IN (’18’, ’62’, ’24’) ) ) ) AND ( id IN ( SELECT id FROM wpdh_yith_wapo_blocks WHERE user_association IN ( ‘all’, ‘logged_users’ ) ) OR id IN ( SELECT DISTINCT(id) FROM wpdh_yith_wapo_blocks as i2 JOIN wpdh_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 wpdh_yith_wapo_blocks as i3 JOIN wpdh_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 wpdh_yith_wapo_blocks as i4 JOIN wpdh_yith_wapo_blocks_assoc as a4 on a4.rule_id = i4.id WHERE exclude_products = 1 AND type = ‘excluded_product’ AND object = ‘3191’ ) AND id NOT IN ( SELECT DISTINCT(rule_id) FROM wpdh_yith_wapo_blocks as i5 JOIN wpdh_yith_wapo_blocks_assoc as a5 on a5.rule_id = i5.id WHERE exclude_products = 1 AND type = ‘excluded_category’ AND object IN (’18’, ’62’, ’24’) ) AND id NOT IN ( SELECT DISTINCT(rule_id) FROM wpdh_yith_wapo_blocks as i6 JOIN wpdh_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

I deleted the plugin and found an alternative one.

Still no solution here too… strange. Looks like a corrupt thing or so because after deleting and reinstalling, I still cab’t save anyting anymore. It keeps getting back to the same start page ‘Create your first block’ …

I liked the idea with the blocks so much easier then doing everything for every article over and over. What alternative plugin do you use now @elainewpq . So much plugins but can’t find one which works the same. Have to do roughly 500 articles over again.

Hi @kapmi. The plugin I am using now, is PPOM – Product Addon & Fields for Woocommerce. Its free, works in a very similar way, and can be added to categories.

Hope it helps you.

Thank you. Unfortunately for more then 2 productfields an expensive plugin. I’ll have to dig further in the plugins…

I managed to delete the (probably corrupt) tables of the database. However as I already mentioned, after installing the plugin from scratch, it doesn’t save anything at all anymore. Not so suprising because after reinstalling the plugin, the tables are not showing up in the database.

The last tables in the database are:

72P72lrsf7_woocommerce_shipping_zone_locations 73P72lrsf7_woocommerce_shipping_zone_methods 74P72lrsf7_woocommerce_shipping_zones 75P72lrsf7_woocommerce_tax_rate_locations 76P72lrsf7_woocommerce_tax_rates
77P72lrsf7_wpforms_tasks_meta

And after the last one were the

• yith_wapo_blocks
• yith_wapo_blocks_assoc

tables. But they won’t come in to the database anymore after a fresh installation of the plugin