/messages fails and returns invalid error

[t3chguy]

Background information

• Dendrite version or git SHA: docker main
• SQLite3 or Postgres?: sqlite3
• Running in Docker?: yes
• go version: docker main
• Client used (if applicable): element-web

Description

• What is the problem: /messages API fails and with an invalid error
• Who is affected: Element Web users
• How is this bug manifesting: Loading thread
• When did this first appear: Unclear

Steps to reproduce

• open a thread such that pagination is triggered
• GET http://localhost:32780/_matrix/client/v3/rooms/!p1fMlcUbat0NHzFF%3Alocalhost/messages?limit=9007199254740991&dir=b&filter=%7B%22lazy_load_members%22%3Atrue%2C%22types%22%3Anull%2C%22not_types%22%3A%5B%5D%2C%22rooms%22%3Anull%2C%22not_rooms%22%3A%5B%5D%2C%22senders%22%3Anull%2C%22not_senders%22%3A%5B%5D%2C%22contains_url%22%3Anull%2C%22io.element.relation_senders%22%3A%5B%5D%2C%22io.element.relation_types%22%3A%5B%22io.element.thread%22%5D%7D
• Observe return of

{
  "Err": ""
}

• Observe error

time="2025-01-07T17:26:43.546857655Z" level=error msg="mreq.retrieveEvents failed" error="GetEventsInRange: s.db.Prepare: near \"=\": syntax error" req.id=OcJIXsvGklfe req.method=GET req.path="/_matrix/client/v3/rooms/!p1fMlcUbat0NHzFF:localhost/messages" user_id="@user:localhost"

[t3chguy]

trace (1).zip