AeroCargo/Blog

On a new site when attempting to view /blog the following error is returned…

SQLSTATE[42000]: Syntax error or access violation: 1055 'database.tags.tag_group_id' isn't in GROUP BY (Connection: mysql, SQL: select tags.*, COUNT(*) as blogs_count from tags inner join blog_post_tag on blog_post_tag.`tag_id` = tags.`id` inner join blog_posts on blog_posts.`id` = blog_post_tag.`blog_post_id` where blog_posts.`published_at` <= 2026-02-24 17:12:21 and blog_posts.`deleted_at` is null group by tags.`id`)

The problem can be fixed temporarily by updating config/database.php line

        'mysql' => [
            ...
            'strict' => true,
            ...
        ],

From true to false.

Issue appears to be with the group by found here

Aerocargo\Blog\Http\Responses\Steps\AttachTags.php(27)

Please authenticate to join the conversation.

Upvoters
Status

Completed

Board

🐛 Bug Reports

Date

About 1 month ago

Author

Stephen@Teclan

Subscribe to post

Get notified by email when there are changes.