Error on startup

[hendisantika]

After running db:seed, I have this Error on startup:

Any suggestions?
Thanks

[gieart87]

Hi Mas @hendisantika ,
I believe it's related to the sqlmode on your MySQL server. Could you please show me the sqlmode on your dbserver so that I can reproduce the issue?
I've tested this code on mysql version 5.7 and 8.x with the following sqlmode (demo url: http://108.61.222.138/course-larashop7/ )

Some people face that issue but I haven't reproduced it yet in my local. Thanks.

[hendisantika]

Here's the result:

Is there something need to change?

[gieart87]

It can be fixed by either updating the sql query or updating the sqlmode. But, I prefer to fix it by updating the query. Your sql_mode is a bit different from the default https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html . Adding the ONLY_FULL_GROUP_BY on the sqlmode may fix the issue if I'm not mistaken. Let me reproduce it first on my local.

[gieart87]

still could not replicate the issue :))

[hendisantika]

Could You tell me How to add ONLY_FULL_GROUP_BY?

[gieart87]

Find your my.cnf file then add the sqlmode you want, e.g:

https://stackoverflow.com/questions/23921117/disable-only-full-group-by