benwrigley

That’s really helpful thanks. Wouldn’t you agree that the red diamond next to post_id in wp_postmeta means that this is the foreign key but meta_id is the primary key?

In my mind I want to find all the ID from wp_post where post_type = ‘topic’. Then look for any wp_postmeta records that have a post_id matching the ID list?
Have I got this backwards?

Thank you again. Sorry to double-check again but can I ask what post_id is for in the wpva_postmeta table? I would have thought that was the foreign key for the posts table?

select count(*) from wpva_postmeta = 2571685

select count(*) from wpva_posts = 191570

select count(*) from wpva_posts where post_type='topic' = 188719

select count(*) from wpva_postmeta where wpva_postmeta.meta_id in (select wpva_posts.id from wpva_posts where wpva_posts.post_type like 'topic')= 133698

select count(*) from wpva_postmeta where wpva_postmeta.post_id in (select wpva_posts.id from wpva_posts where wpva_posts.post_type like 'topic')= 2550930

• This reply was modified 7 months ago by benwrigley.

And can I just check your thoughts? I don’t wish to correct you, but I wondered if that should be post_id instead of meta_id? And if it should be wpva_posts.id instead of wpva_posts.post_id? My wpva_posts doesn’t have a post_id field.

DELETE FROM wpva_postmeta where wpva_postmeta.post_id in (select wpva_posts.id from wpva_posts where wpva_posts.post_type like 'topic");

• This reply was modified 7 months ago by benwrigley.

That’s great, thank you so much!

Before I go ahead with that, can I just check what happens with any attached media? Will they just appear as unattached when I delete the posts?

@sterndata thanks again for your reply.

No, there is no forum plug-in, but there might have been in the past.

Is there some kind of cascading delete that will remove the meta rows when I remove the posts?

And yes, thank you, I’ve done a db backup with updraft ??

Am I safe to simply delete these rows or will that impact relationships with wpva_post_meta?

• This reply was modified 7 months ago by benwrigley.

Hi @sterndata, thanks so much for getting back to me.

There is a post_type of ‘topic’ (which I’m not familiar with) that has 189k rows

Any idea what that is?

I also lost a few WP sites in the update and have disabled Burst for now.

Are you saying it’s safe to reactivate and update manually?

Should we be turning off auto-updates for Burst?

Thanks for your help.

Hi John,

So sorry to waste your time my apologies. It was lurking in my .htaccess file!

Thanks for helping out!

Ben

Hi Kevin,

Thank you that’s brilliant.

Best

Ben

Hi Kevin,

I’ve added this to my global CSS, no impact i’m afraid ??

Any other suggestions?

Thanks

Ben

Great thanks. I think I muse have had a different plugin at some point that did store them.

no sorry, I meant ‘us’ as in my business. We collect very sensitive data and we have been told we cannot store emails. Thanks again!.

hello both,

Actually one last question, is it possible to resize the recaptcha box and set width to 100% too?

Thanks

Ben

Hi Tracy!

Oh God how embarrassing! I did mean guy in the generic person sense I promise.

<sneaks away in shame>

:((((

ah yes I think I do!

I have to specifically say that for each input type. Makes sense!

Thanks CSS expert guy!

Ben