search

ckolderup / postmarks

a single-user bookmarking website designed to live on the Fediverse
https://postmarks.glitch.me
MIT License
464 stars 38 forks source link

Comments causing SQLite error #184

Open andypiper opened 8 months ago

andypiper commented 8 months ago

I create a new bookmark, and then comment on it from a Mastodon account.

In the log, I'm seeing this

Actor https://social.lol/users/andypiper matches an allowlist item, marking comment visible
[Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: comments.url] {
  errno: 19,
  code: 'SQLITE_CONSTRAINT'
}

The comment still shows up on the web page. I'm not sure how to further debug the SQLite error here.

TomCasavant commented 4 months ago

I'm getting that same error as well