Sites back, communities that previously had their community page not vieweable are now viewable
An example of this is https://programming.dev/c/a11y
Basically what I did was before the maintenance exported every single post in the post table and use a js script to check for duplicate ap_ids (checking using sql itself didnt work due to broken indices so it was always missing some). Then I generated sql statements to remove duplicate posts that had higher ids than the other posts theyre a duplicate of. Ran all those during maintenance and since all duplicate ap_ids were removed I could now reindex the table to fix the broken indices
Did the same for communities after the posts (but also did some statements to move posts from one version of the community to the other)
Site might be slow for a tiny bit as it processes the 2 hour of activities that were generated while it was down

Group Name: D2Jam
Game jam that happens twice a year (eventually having a connection to activitypub through sending posts in the forum as microblogs to be visible on things like mastodon and getting posts from things like mastodon that use the d2jam hashtag). Site is still under construction atm though since its very new
The template has the d2jam logo as well as characters from games that were submitted to the first jam event that we ran! Anyones free to help out with construction if you want
https://canvas.fediverse.events/#x=363&y=353&zoom=1&tu=https%3A%2F%2Fbytes.programming.dev%2Ffiles%2F3a81bf17-cd77-445d-8186-59f4160f5ddd&tw=96&tx=290&ty=451&ts=DOTTED_SMALL
Bottom of the canvas near the right
fun fact: theres 29 games on the site you could play right now : )