go-shiori/shiori

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

beyondwatts opened this issue · 1 comments

beyondwatts commented

Data

  • Shiori version: v1.7.0
  • Database Engine: mariadb-galera

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

Created pull request #975 to resolve