A quick bug fix for top mention sites

I found an edge case problem for my Top Sites feature of Open Mentions. If a site uses www. as part of their address, my custom SQL didn’t take that into account and filtered it as not the same site. This was because subdomains count as a different site, but the top sites drops the www. bit for clarity of listing.

The result is that the site page for such listings reported there were no entries. Opps.

I fixed that by adding a clause for such sites. After some rudimentary testing, my oversight seems to have been fixed.

#bugFix #homebrewError #SQL #topSitesMentioningUs
Top Sites

These are the sites with the most WebMentions. I'm still figuring out how to also do ActivityPub, which is just different enough to be tricky.

Open Mentions