Invalid interaction URL:s crash some lists

[voxpelli]

trafficstars

This is the error I'm getting in the backend:

Error: Invalid URL, should be an absolute one (tag:indieweb.social:112331285963196700/,2013)
  at normalizeUrlRaw (/app/lib/utils/url-tools.js:28:11)
  at normalizeUrl (/app/lib/utils/url-tools.js:53:58)
  at /app/lib/classes/entries.js:88:36
  at Array.map (<anonymous>)
  at Entries._resolveDerivedData (/app/lib/classes/entries.js:88:25)
  at Entries._distillMention (/app/lib/classes/entries.js:117:15)
  at /app/lib/classes/entries.js:301:26
  at Array.map (<anonymous>)
  at /app/lib/classes/entries.js:301:10

Temporary solution is to run one of the queries (https://github.com/voxpelli/webpage-webmentions/issues/208#issuecomment-2429253424 or https://github.com/voxpelli/webpage-webmentions/issues/208#issuecomment-2165109424) and edit out the interactions from entries.data manually.

If there's a \u0000 error, then do this and edit them manually:

SELECT entries.id
FROM entries
INNER JOIN mentions ON mentions.eid = entries.id
WHERE
  entries::TEXT LIKE '%\u0000%'; 
ORDER BY fetched DESC
LIMIT 100

Originally posted by @voxpelli in https://github.com/voxpelli/webpage-webmentions/issues/205#issuecomment-2098158868

[voxpelli]

Still happening: https://github.com/voxpelli/webpage-webmentions/issues/208#issuecomment-2429253424