[Bug]: some communities seem unable to load

[Die4Ever]

Requirements

• Is this a bug report? For questions or discussions use https://lemmy.ml/c/lemmy_support
• Did you check to see if this issue already exists?
• Is this only a single bug? Do not put multiple bugs in one issue.
• Do you agree to follow the rules in our Code of Conduct?
• Is this a backend issue? Use the lemmy-ui repo for UI / frontend issues.

Summary

Some communities with underscores in the ID seem broken.

Steps to Reproduce

1. Go to search page: https://programming.dev/search?q=data+structures&type=Communities&listingType=Local&page=1&sort=TopAll
2. Click on Data Structures and Algorithms
3. The server returned this error: couldnt_find_community

Technical Details

Discussion here https://programming.dev/post/20515601 with additional examples

Version

0.19.5

Lemmy Instance URL

https://programming.dev/c/data_structures

[Nutomic]

Probably also due to broken db indexes on programming.dev, same as #5074 and #5077

[Nothing4You]

broken index on the community table was confirmed: https://programming.dev/post/20515601/12803517