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

Accessing moderation page in admin results in postgres errors #4685

Closed
aneillans opened this issue Oct 7, 2023 · 0 comments
Closed

Accessing moderation page in admin results in postgres errors #4685

aneillans opened this issue Oct 7, 2023 · 0 comments

Comments

@aneillans
Copy link
Contributor

The following errors are logged in the Laverel log when accessing the moderation page on the latest codebase.

[2023-10-07 11:50:29] production.ERROR: SQLSTATE[42803]: Grouping error: 7 ERROR: column "reports.profile_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select * from "reports" where "admin_seen" is null group by ...
^ (Connection: pgsql, SQL: select * from "reports" where "admin_seen" is null group by "id", "object_id", "object_type" order by "id" desc limit 7) {"userId":1,"exception":"[object] (Illuminate\Database\QueryException(code: 42803): SQLSTATE[42803]: Grouping error: 7 ERROR: column "reports.profile_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select * from "reports" where "admin_seen" is null group by ...
^ (Connection: pgsql, SQL: select * from "reports" where "admin_seen" is null group by "id", "object_id", "object_type" order by "id" desc limit 7) at /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php:795)
[stacktrace]
#0 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(755): Illuminate\Database\Connection->runQueryCallback()
#1 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(424): Illuminate\Database\Connection->run()
#2 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2748): Illuminate\Database\Connection->select()
#3 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2736): Illuminate\Database\Query\Builder->runSelect()
#4 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3290): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2737): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(720): Illuminate\Database\Query\Builder->get()
#7 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(704): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(410): Illuminate\Database\Eloquent\Builder->get()
#9 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(960): Illuminate\Database\Eloquent\Builder->paginateUsingCursor()
#10 /home/pixelfed/pixelfed/app/Http/Controllers/Admin/AdminReportController.php(647): Illuminate\Database\Eloquent\Builder->cursorPaginate()
#11 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\AdminController->reportsApiAll()
#12 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction()
#13 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\Routing\ControllerDispatcher->dispatch()
#14 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()
#15 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Routing\Route->run()
#16 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#17 /home/pixelfed/pixelfed/app/Http/Middleware/TwoFactorAuth.php(33): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#18 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\TwoFactorAuth->handle()
#19 /home/pixelfed/pixelfed/app/Http/Middleware/DangerZone.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\DangerZone->handle()
#21 /home/pixelfed/pixelfed/app/Http/Middleware/Admin.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#22 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Admin->handle()
#23 /home/pixelfed/pixelfed/vendor/laravel/passport/src/Http/Middleware/CreateFreshApiToken.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle()
#25 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#26 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#27 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#28 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
#29 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Session/Middleware/AuthenticateSession.php(60): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#30 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\AuthenticateSession->handle()
#31 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#32 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#33 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#34 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
#35 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle()
#36 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#37 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#38 /home/pixelfed/pixelfed/app/Http/Middleware/FrameGuard.php(18): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\FrameGuard->handle()
#40 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle()
#42 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#43 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\Pipeline\Pipeline->then()
#44 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(777): Illuminate\Routing\Router->runRouteWithinStack()
#45 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(741): Illuminate\Routing\Router->runRoute()
#46 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(730): Illuminate\Routing\Router->dispatchToRoute()
#47 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch()
#48 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
#49 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#50 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle()
#51 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#52 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()
#53 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#54 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#55 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#56 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#57 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#58 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#59 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#60 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#61 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#62 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#63 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#64 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then()
#65 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#66 /home/pixelfed/pixelfed/public/index.php(57): Illuminate\Foundation\Http\Kernel->handle()
#67 {main}

[previous exception] [object] (PDOException(code: 42803): SQLSTATE[42803]: Grouping error: 7 ERROR: column "reports.profile_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select * from "reports" where "admin_seen" is null group by ...
^ at /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php:421)
[stacktrace]
#0 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): PDOStatement->execute()
#1 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(788): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(755): Illuminate\Database\Connection->runQueryCallback()
#3 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(424): Illuminate\Database\Connection->run()
#4 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2748): Illuminate\Database\Connection->select()
#5 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2736): Illuminate\Database\Query\Builder->runSelect()
#6 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3290): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2737): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(720): Illuminate\Database\Query\Builder->get()
#9 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(704): Illuminate\Database\Eloquent\Builder->getModels()
#10 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(410): Illuminate\Database\Eloquent\Builder->get()
#11 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(960): Illuminate\Database\Eloquent\Builder->paginateUsingCursor()
#12 /home/pixelfed/pixelfed/app/Http/Controllers/Admin/AdminReportController.php(647): Illuminate\Database\Eloquent\Builder->cursorPaginate()
#13 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\AdminController->reportsApiAll()
#14 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction()
#15 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\Routing\ControllerDispatcher->dispatch()
#16 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()
#17 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Routing\Route->run()
#18 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#19 /home/pixelfed/pixelfed/app/Http/Middleware/TwoFactorAuth.php(33): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\TwoFactorAuth->handle()
#21 /home/pixelfed/pixelfed/app/Http/Middleware/DangerZone.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#22 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\DangerZone->handle()
#23 /home/pixelfed/pixelfed/app/Http/Middleware/Admin.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Admin->handle()
#25 /home/pixelfed/pixelfed/vendor/laravel/passport/src/Http/Middleware/CreateFreshApiToken.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#26 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Laravel\Passport\Http\Middleware\CreateFreshApiToken->handle()
#27 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#28 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#29 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#30 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
#31 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Session/Middleware/AuthenticateSession.php(60): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#32 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\AuthenticateSession->handle()
#33 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#34 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#35 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#36 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
#37 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle()
#38 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#40 /home/pixelfed/pixelfed/app/Http/Middleware/FrameGuard.php(18): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\FrameGuard->handle()
#42 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#43 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle()
#44 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#45 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\Pipeline\Pipeline->then()
#46 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(777): Illuminate\Routing\Router->runRouteWithinStack()
#47 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(741): Illuminate\Routing\Router->runRoute()
#48 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Routing/Router.php(730): Illuminate\Routing\Router->dispatchToRoute()
#49 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch()
#50 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
#51 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#52 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle()
#53 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#54 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()
#55 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#56 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#57 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#58 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#59 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#60 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#61 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#62 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#63 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#64 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#65 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#66 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then()
#67 /home/pixelfed/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#68 /home/pixelfed/pixelfed/public/index.php(57): Illuminate\Foundation\Http\Kernel->handle()
#69 {main}
"}

Looks like the SQL statement is incorrect.
@dansup dansup closed this as completed in e4d3b19 Oct 9, 2023
dansup added a commit that referenced this issue Oct 9, 2023
@dansup
Merge pull request #4688 from pixelfed/staging
f38226c 
Update AdminReportController, add `profile_id` to group by. Fixes #4685
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@aneillans