@unateam @Michael Newton @Clubhouse @LeonidS

I've made it much more easier for any of our experts to respond. Time is against us and force us to look at alternative storage solutions. Things look good so to speak but we need to clean our house first and who knows...

We're ready to move forward with this cleanup script and just need a YES confirmation from UNA experts before deploying to production.

Purpose of this test:

I want to temporarily modify the script to validate two fundamental coding principles:

The delete function - We're using the same deleteEvent() method that UNA's core uses for timeline deletions

The event type identification - We've confirmed timeline_common_post and timeline_common_repost are the correct types

Test plan:

Temporarily delete the newest 10 posts (easy to visually confirm on the timeline), verify:

php$dryRun = false; // Actually delete

// Get NEWEST 10 posts for easy visual confirmation

$eventIds = $db->getColumn("

   SELECT `id`

   FROM `bx_timeline_events`

   WHERE `type` IN ($typeList)

   ORDER BY `date` DESC

   LIMIT 10

");

Change: ASC → DESC (descending = newest first)

Posts disappear from timeline ✓

Media files removed from storage ✓

No database errors ✓

Confidence level:

I'm highly confident we're on the right track because:

Using UNA's native deletion method (not custom SQL)

Verified correct event types from database schema

Successfully tested on dev server (165 deletions, zero failures)

Just need expert confirmation that our approach is sound before production implementation.

Thanks Guys!

Chris