Created
January 30, 2026 15:15
-
-
Save shleeable/2064914eb4ec1b91cff3e615d0eeb3b7 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ``` | |
| [2026-01-30 15:12:24] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1055 'loops_server.profiles.local' isn't in GROUP BY (Connection: mysql, Host: 192.168.125.251, Port: 3306, Database: loops_server, SQL: select `profiles`.`id`, `profiles`.`local`, `profiles`.`name`, `profiles`.`avatar`, `profiles`.`username`, `profiles`.`following`, `profiles`.`followers`, `profiles`.`video_count`, `profiles`.`domain`, `profiles`.`status`, `profiles`.`created_at`, MAX(CASE WHEN followers.following_id IS NOT NULL THEN 1 ELSE 0 END) as is_followed from `profiles` left join `followers` on `followers`.`following_id` = `profiles`.`id` and `followers`.`profile_id` = 243939654684254235 where `profiles`.`id` != 243939654684254235 and not exists (select `id` from `user_filters` where `user_filters`.`account_id` = `profiles`.`id` and `user_filters`.`profile_id` = 243939654684254235) and `profiles`.`username` like https://loops.video/@dansup% and `profiles`.`status` = 1 group by `profiles`.`id`, `profiles`.`username`, `profiles`.`followers` order by `is_followed` desc, `profiles`.`followers` desc limit 11) {"userId":5,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'loops_server.profiles.local' isn't in GROUP BY (Connection: mysql, Host: 192.168.125.251, Port: 3306, Database: loops_server, SQL: select `profiles`.`id`, `profiles`.`local`, `profiles`.`name`, `profiles`.`avatar`, `profiles`.`username`, `profiles`.`following`, `profiles`.`followers`, `profiles`.`video_count`, `profiles`.`domain`, `profiles`.`status`, `profiles`.`created_at`, MAX(CASE WHEN followers.following_id IS NOT NULL THEN 1 ELSE 0 END) as is_followed from `profiles` left join `followers` on `followers`.`following_id` = `profiles`.`id` and `followers`.`profile_id` = 243939654684254235 where `profiles`.`id` != 243939654684254235 and not exists (select `id` from `user_filters` where `user_filters`.`account_id` = `profiles`.`id` and `user_filters`.`profile_id` = 243939654684254235) and `profiles`.`username` like https://loops.video/@dansup% and `profiles`.`status` = 1 group by `profiles`.`id`, `profiles`.`username`, `profiles`.`followers` order by `is_followed` desc, `profiles`.`followers` desc limit 11) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:838) | |
| [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'loops_server.profiles.local' isn't in GROUP BY at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:420) | |
| ``` |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment