jgramp

Yes, it’s the same issue, as described by the original ticket. I spent all day working on a fix. I have had to manually restore the attributes and variations that were deleted from a backup copy of my website database, that I had not modified and thankfully all of the other order data, including the links to my Ticket integration (Tickera) have now been restored. I’ll post further details tomorrow, but for now I wanted to share that I managed to restore the data in the following 4 tables.

First, I changed?the product back to a variable product and saved it, but the attributes and variations were still missing.

So I then had to retrieve and restore the relevant rows from the following tables:

– wp_posts

– wp_postmeta

– wp_wc_product_meta_lookup

– wp_wc_product_attributes_lookup

I’ll post further details tomorrow and hopefully this will help others who have experienced this same issue.

What a relief anyway! I thought I had lost the information for 711 ticket sales with the change of one (seemingly innocent) change of setting in WooCommerce. But luckily I could recover all this data!

Hopefully something is changed to avoid others making the same mistake!

Cheers.

Jess

I also changed the product type from a variable product to a simple product, assuming that WordPress wouldn’t actually delete the data in the database (since it doesn’t do this for plugins that are uninstalled either) and now all of my orders of these variable products have problems displaying the data. Please can you explain which database tables now need to be restored to recover this data?

I have identified these so far:

• wp_wc_product_meta_lookup
• wp_wc_product_attributes_lookup

My Tickera integration is now also no longer working.

I still can’t believe that data would be deleted with zero warning!!!

This is a big issue that I hope will be resolved with a warning, so other people don’t do the same as me and end up losing important order data for a production Woocommerce site ??

I’m quite nervous now that other setting changes could potentially cause big issues like this with absolutely no warning.

Hello again.

I see the latest version was released a few months ago. Does this now support custom post types? I didn’t see it mentioned on the info page, but thought I’d check.

Thank you.

yes, that fixed it. Thank you. It wasn’t clear from the error message that we needed to buy and install a plugin to get this to work. But now we have done this it works fine.

Thanks.

That’s good to know, thank you.

I am hoping to add it to a calendar event plugin with over 100 entries (custom posts), so I will need to be able to automate this, via a bulk upload into this field. Manually adding blocks isn’t an option at this scale.

Do you have any idea when this may be available?

Thanks in advance.

Hello.

How can I get around this fatal error please? When I try to network activate I get a HTTP ERROR 500. Should I download an older version of this plugin to avoid this problem?

Will you be downgrading to the previous version of Freemium SDK?

Thanks for your help.

Good idea, Thanks jordesign ?? I will look at this. I think I have used this in the past actually and had forgotten about it. Ta.

ok. So I did the following to get this working. Thanks for the hints about how to do this @missveronicatv .

UM Settings -> General -> Account :

Allow users to hide their profiles from directory (checked, which then showed)

Hide profiles from directory by default?> No

For some reason setting the above settings suddenly meant the page loaded all the profiles that weren’t visible previously. It’s not clear why these settings affect the visibility of the profiles that show in the member directory, but I suggest that a note should be added to the member directory page warning site admins to set these settings, in order to make this work.

I don’t believe that setting the ‘Can make their profile private??‘ on the role settings made a difference to this working or not.

Hello. This issue is not resolved. The last reply was only 4 days ago and it’s a long weekend here. I will need to see if I can find this setting tomorrow and let you know.

Thanks but there is no such setting.

Thanks Yordan.

It’s an issue with another plugin, not this one. So you can mark this as closed. Once the fee is in the database again it appears fine on the invoices.

thank you.

So when an order is changed from ‘on hold’ to ‘completed’ the fee no longer displays anywhere, but it is still calculated in the total somehow.

This means it is also not displaying on any invoices.

I see that we get a bunch of errors in the Order notes after changing the order from On hold to completed:

• Error saving order ID 2849. Invalid order item.9 August 2023 at 01:41 am
• Order status changed from On hold to Completed.

Thank you. Do you know which table in the DB I look in to see if the fees are there? To me it seems that the fees are no longer displayed after the order is marked as completed.

ok. I resolved this by disabling revisions completely in Clearfy. Saving. Then enabling them again and saving the settings again. My old revisions are gone, but at least it is keeping track of new revisions. I guess I will need to recover from backup if we need to restore an old revision.