Error

We're sorry, but an unhandled error occurred. Please see the details below.

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ihousedatabase.radiantweb_generated_dates.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select * from `radiantweb_generated_dates` where event_date >= 2024-03-27 group by `grouped_id`, `event_id` order by `event_date` asc, `sttime` asc limit 5 offset 0)

/home/ihouse/htdocs/ihouse.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php line 664

        }
 
        // If an exception occurs when attempting to run a query, we'll format the error
        // message to include the bindings with SQL, which will make this exception a
        // lot more helpful to the developer instead of just the database's errors.
        catch (Exception $e) {
            throw new QueryException(
                $query, $this->prepareBindings($bindings), $e
            );
        }
 
        return $result;
    }

Stack trace

# Called Code Document Line
57 Illuminate\Database\Connection->runQueryCallback() ~/vendor/laravel/framework/src/Illuminate/Database/Connection.php 624
56 Illuminate\Database\Connection->run() ~/vendor/laravel/framework/src/Illuminate/Database/Connection.php 333
55 Illuminate\Database\Connection->select() ~/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php 1719
54 Illuminate\Database\Query\Builder->runSelect() ~/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php 1704
53 Illuminate\Database\Query\Builder->get() ~/vendor/october/rain/src/Database/QueryBuilder.php 122
52 October\Rain\Database\QueryBuilder->getDuplicateCached() ~/vendor/october/rain/src/Database/QueryBuilder.php 92
51 October\Rain\Database\QueryBuilder->get() ~/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php 481
50 Illuminate\Database\Eloquent\Builder->getModels() ~/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php 465
49 Illuminate\Database\Eloquent\Builder->get() ~/vendor/october/rain/src/Database/Builder.php 141
48 October\Rain\Database\Builder->paginate() ~/plugins/radiantweb/proevents/models/GeneratedDate.php 188
47 Radiantweb\Proevents\Models\GeneratedDate->getEventsList() ~/plugins/radiantweb/proevents/components/EventList.php 203
46 Radiantweb\Proevents\Components\EventList->listEvents() ~/plugins/radiantweb/proevents/components/EventList.php 94
45 Radiantweb\Proevents\Components\EventList->onRun() ~/modules/cms/classes/CmsCompoundObject.php 168
44 Cms\Classes\CmsCompoundObject->runComponents() ~/modules/cms/classes/Controller.php 501
43 Cms\Classes\Controller->execPageCycle() ~/modules/cms/classes/Controller.php 394
42 Cms\Classes\Controller->runPage() ~/modules/cms/classes/Controller.php 225
41 Cms\Classes\Controller->run() ~/modules/cms/classes/CmsController.php 50
40 Cms\Classes\CmsController->run()
39 call_user_func_array() ~/vendor/laravel/framework/src/Illuminate/Routing/Controller.php 54
38 Illuminate\Routing\Controller->callAction() ~/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php 45
37 Illuminate\Routing\ControllerDispatcher->dispatch() ~/vendor/laravel/framework/src/Illuminate/Routing/Route.php 212
36 Illuminate\Routing\Route->runController() ~/vendor/laravel/framework/src/Illuminate/Routing/Route.php 169
35 Illuminate\Routing\Route->run() ~/vendor/laravel/framework/src/Illuminate/Routing/Router.php 658
34 Illuminate\Routing\Router->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 30
33 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php 41
32 Illuminate\Routing\Middleware\SubstituteBindings->handle() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 149
31 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 53
30 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php 49
29 Illuminate\View\Middleware\ShareErrorsFromSession->handle() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 149
28 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 53
27 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php 63
26 Illuminate\Session\Middleware\StartSession->handle() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 149
25 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 53
24 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php 37
23 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 149
22 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 53
21 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php 68
20 Illuminate\Cookie\Middleware\EncryptCookies->handle() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 149
19 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 53
18 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 102
17 Illuminate\Pipeline\Pipeline->then() ~/vendor/laravel/framework/src/Illuminate/Routing/Router.php 660
16 Illuminate\Routing\Router->runRouteWithinStack() ~/vendor/laravel/framework/src/Illuminate/Routing/Router.php 635
15 Illuminate\Routing\Router->runRoute() ~/vendor/laravel/framework/src/Illuminate/Routing/Router.php 601
14 Illuminate\Routing\Router->dispatchToRoute() ~/vendor/october/rain/src/Router/CoreRouter.php 20
13 October\Rain\Router\CoreRouter->dispatch() ~/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php 176
12 Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 30
11 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php 46
10 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle() ~/vendor/october/rain/src/Foundation/Http/Middleware/CheckForMaintenanceMode.php 25
9 October\Rain\Foundation\Http\Middleware\CheckForMaintenanceMode->handle() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 149
8 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 53
7 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/october/rain/src/Http/Middleware/TrustHosts.php 46
6 October\Rain\Http\Middleware\TrustHosts->handle() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 149
5 Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() ~/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php 53
4 Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}() ~/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php 102
3 Illuminate\Pipeline\Pipeline->then() ~/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php 151
2 Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() ~/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php 116
1 Illuminate\Foundation\Http\Kernel->handle() ~/index.php 43