search

cviebrock / eloquent-taggable

Easily add the ability to tag your Eloquent models in Laravel.
MIT License
537 stars 72 forks source link

Incompatible w/ MariaDB 10.5.8 #125

Closed HomeMatic-INSIDE closed 3 years ago

HomeMatic-INSIDE commented 3 years ago

Good morning,

my hoster has changed the database from MySQL to MariaDB (10.5.8) and now, all requests w/ tags are throwing the following error:

production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1055 'd02937f7.articles.user_id' isn't in GROUP BY (SQL: selectarticles.* fromarticlesinner jointaggable_taggablesonarticles.id=taggable_taggables.taggable_idandtaggable_taggables.taggable_type= App\Article wheretaggable_taggables.tag_idin (61) ...

This seems to happen due of a missing "group-by". I'm still using version 3.3 - so don't know, if this happens in further versions, too.

Regards,...

cviebrock commented 3 years ago

This might be an issue with strict mode. See issue #60 for some of the history on this.

Version 3.3 is a bit old now, so you might want to try updating that first.