search

go-shiori / shiori

Simple bookmark manager built with Go
MIT License
9.56k stars 556 forks source link

Running with a mariadb-galera database gives error "Error 1055 (42000): 'shiori.t.name' isn't in GROUP BY (500)" #976

Open beyondwatts opened 3 months ago

beyondwatts commented 3 months ago

Data

Describe the bug / actual behavior

Running with a mariadb-galera database error "Error 1055 (42000): 'shiori.t.name' isn't in GROUP BY (500)"

Expected behavior

Page loads without error

To Reproduce

Steps to reproduce the behavior:

  1. Run with mariadb-galera backend
  2. Add one or more bookmarks
  3. Load or refresh the bookmarks page
beyondwatts commented 3 months ago

Created pull request #975 to resolve