techbike

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter techbike

    (@techbike)

    Thanks for all your help! Good to mark as resolved ??

    Thread Starter techbike

    (@techbike)

    @geoffbel Thanks for the all the suggestions! Greatly appreciated. I ended up running these two queries, one after the other. Hopefully I didn’t delete anything that’s needed, but guess that’s what backups are for.

    1:
    DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('tribe_events', 'tribe_venue', 'tribe_organizer') AND post_status='draft' AND post_author=0)

    2:
    DELETE FROM wp_posts WHERE post_type IN ('tribe_events', 'tribe_venue', 'tribe_organizer') AND post_status='draft' AND post_author=0

    • This reply was modified 2 years, 5 months ago by techbike.
Viewing 2 replies - 1 through 2 (of 2 total)