Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
beyondwatts opened this issue Sep 2, 2024 · 1 comment
Open

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

beyondwatts opened this issue Sep 2, 2024 · 1 comment
Labels
type:bug Something isn't working

Comments

@beyondwatts
Copy link

beyondwatts commented Sep 2, 2024 •
edited
Loading

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 beyondwatts added the type:bug Something isn't working label Sep 2, 2024
@beyondwatts
Copy link
Author

Created pull request #975 to resolve

@beyondwatts beyondwatts changed the title Running with a mariadb-galera database gives "Error 1054 (42S22): Unknown column 'modified' in 'field list' (500)" Running with a mariadb-galera database gives error "Field name is not in group by field" Sep 2, 2024
@beyondwatts beyondwatts changed the title Running with a mariadb-galera database gives error "Field name is not in group by field" Running with a mariadb-galera database gives error "Error 1055 (42000): 'shiori.t.name' isn't in GROUP BY (500)" Sep 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type:bug Something isn't working
Projects
Roadmap
Status: To do
Milestone
No milestone
Development

No branches or pull requests
1 participant
@beyondwatts