Annual SAL Syntax error #192

New issue

Closed

opened 2026-03-30 10:04:16 +00:00 by niddelicious · 0 comments

niddelicious commented

2026-03-30 10:04:16 +00:00

(Migrated from github.com)

Illuminate\Database\QueryException - Internal Server Error

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parentool.STRFTIME does not exist (Connection: mysql, SQL: select * from annual_events where annual_events.user_id = 1 and annual_events.user_id is not null order by STRFTIME("%m-%d", date))

PHP 8.3.7
Laravel 12.42.0
parentool.nidde.nu

Stack Trace

0 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:826
1 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:780
2 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:397
3 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3188
4 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3173
5 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3763
6 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3172
7 - vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:902
8 - vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:884
9 - vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php:212
10 - app/Services/Calendar/AnnualEventService.php:21
11 - app/Http/Controllers/Calendar/AnnualEventPageController.php:24
12 - vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
13 - vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
14 - vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
15 - vendor/laravel/framework/src/Illuminate/Routing/Route.php:211
16 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:822
17 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
18 - vendor/laravel/framework/src/Illuminate/Auth/Middleware/EnsureEmailIsVerified.php:41
19 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
20 - vendor/laravel/framework/src/Illuminate/Http/Middleware/AddLinkHeadersForPreloadedAssets.php:32
21 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
22 - vendor/inertiajs/inertia-laravel/src/Middleware.php:122
23 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
24 - vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
25 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
26 - vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php:63
27 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
28 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:87
29 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
30 - vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:48
31 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
32 - vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:120
33 - vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
34 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
35 - vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:36
36 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
37 - vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:74
38 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
39 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
40 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:821
41 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:800
42 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:764
43 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:753
44 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200
45 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
46 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
47 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31
48 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
49 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
50 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:51
51 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
52 - vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php:27
53 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
54 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:109
55 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
56 - vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php:48
57 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
58 - vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:58
59 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
60 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php:22
61 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
62 - vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php:26
63 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
64 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
65 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175
66 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144
67 - vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220
68 - public/index.php:20

Request

GET /calendar/annual-events

Headers

cookie: ; ;
priority: u=1, i
accept-encoding: gzip, deflate, br, zstd
referer: https://parentool.nidde.nu/dashboard
sec-fetch-dest: empty
sec-fetch-mode: cors
sec-fetch-site: same-origin
accept-language: en-GB,en;q=0.9
sec-gpc: 1
accept: text/html, application/xhtml+xml
user-agent: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36
x-requested-with: XMLHttpRequest
sec-ch-ua-mobile: ?1
x-inertia: true
sec-ch-ua: "Chromium";v="146", "Not-A.Brand";v="24", "Brave";v="146"
x-inertia-version: 10085e258d74f3ac13c5c0ed9d4c0fa5
x-xsrf-token:
x-csrf-token:
sec-ch-ua-platform: "Android"
host: parentool.nidde.nu

Route Context

controller: App\Http\Controllers\Calendar\AnnualEventPageController
route name: annual-events.index
middleware: web, auth, verified

Route Parameters

No route parameter data available.

Database Queries

mysql - select * from sessions where id = 'wJpq7RPlTeRFhBYHkpTPn4H88V6ce0VMYGdnFDmS' limit 1 (3.86 ms)
mysql - select * from users where id = 1 limit 1 (1.52 ms)
mysql - select * from user_settings where user_settings.user_id in (1) (1.41 ms)
mysql - select id, name, icon from purchase_categories where purchase_categories.user_id = 1 and purchase_categories.user_id is not null (2.07 ms)
mysql - select * from quick_purchases where quick_purchases.user_id = 1 and quick_purchases.user_id is not null (1.22 ms)
mysql - select id, name, icon from purchase_categories where purchase_categories.id in (9) (0.92 ms)
mysql - select id, name, type, sort_order from transaction_categories where transaction_categories.user_id = 1 and transaction_categories.user_id is not null order by type asc, sort_order asc (1.29 ms)
mysql - select * from icons where icons.iconable_id in (1, 2, 3, 4, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) and icons.iconable_type = 'App\Models\Finance\TransactionCategory' (1.42 ms)
mysql - select id, name, color from task_categories where task_categories.user_id = 1 and task_categories.user_id is not null (1.18 ms)

# Illuminate\Database\QueryException - Internal Server Error SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parentool.STRFTIME does not exist (Connection: mysql, SQL: select * from `annual_events` where `annual_events`.`user_id` = 1 and `annual_events`.`user_id` is not null order by STRFTIME("%m-%d", date)) PHP 8.3.7 Laravel 12.42.0 parentool.nidde.nu ## Stack Trace 0 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:826 1 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:780 2 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:397 3 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3188 4 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3173 5 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3763 6 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3172 7 - vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:902 8 - vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:884 9 - vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php:212 10 - app/Services/Calendar/AnnualEventService.php:21 11 - app/Http/Controllers/Calendar/AnnualEventPageController.php:24 12 - vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 13 - vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 14 - vendor/laravel/framework/src/Illuminate/Routing/Route.php:265 15 - vendor/laravel/framework/src/Illuminate/Routing/Route.php:211 16 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:822 17 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 18 - vendor/laravel/framework/src/Illuminate/Auth/Middleware/EnsureEmailIsVerified.php:41 19 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 20 - vendor/laravel/framework/src/Illuminate/Http/Middleware/AddLinkHeadersForPreloadedAssets.php:32 21 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 22 - vendor/inertiajs/inertia-laravel/src/Middleware.php:122 23 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 24 - vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50 25 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 26 - vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php:63 27 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 28 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:87 29 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 30 - vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:48 31 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 32 - vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:120 33 - vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 34 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 35 - vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:36 36 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 37 - vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:74 38 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 39 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137 40 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:821 41 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:800 42 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:764 43 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:753 44 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200 45 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 46 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 47 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31 48 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 49 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 50 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:51 51 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 52 - vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php:27 53 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 54 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:109 55 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 56 - vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php:48 57 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 58 - vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:58 59 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 60 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php:22 61 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 62 - vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php:26 63 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219 64 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137 65 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175 66 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144 67 - vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220 68 - public/index.php:20 ## Request GET /calendar/annual-events ## Headers * **cookie**: ; ; * **priority**: u=1, i * **accept-encoding**: gzip, deflate, br, zstd * **referer**: https://parentool.nidde.nu/dashboard * **sec-fetch-dest**: empty * **sec-fetch-mode**: cors * **sec-fetch-site**: same-origin * **accept-language**: en-GB,en;q=0.9 * **sec-gpc**: 1 * **accept**: text/html, application/xhtml+xml * **user-agent**: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36 * **x-requested-with**: XMLHttpRequest * **sec-ch-ua-mobile**: ?1 * **x-inertia**: true * **sec-ch-ua**: "Chromium";v="146", "Not-A.Brand";v="24", "Brave";v="146" * **x-inertia-version**: 10085e258d74f3ac13c5c0ed9d4c0fa5 * **x-xsrf-token**: * **x-csrf-token**: * **sec-ch-ua-platform**: "Android" * **host**: parentool.nidde.nu ## Route Context controller: App\Http\Controllers\Calendar\AnnualEventPageController route name: annual-events.index middleware: web, auth, verified ## Route Parameters No route parameter data available. ## Database Queries * mysql - select * from `sessions` where `id` = 'wJpq7RPlTeRFhBYHkpTPn4H88V6ce0VMYGdnFDmS' limit 1 (3.86 ms) * mysql - select * from `users` where `id` = 1 limit 1 (1.52 ms) * mysql - select * from `user_settings` where `user_settings`.`user_id` in (1) (1.41 ms) * mysql - select `id`, `name`, `icon` from `purchase_categories` where `purchase_categories`.`user_id` = 1 and `purchase_categories`.`user_id` is not null (2.07 ms) * mysql - select * from `quick_purchases` where `quick_purchases`.`user_id` = 1 and `quick_purchases`.`user_id` is not null (1.22 ms) * mysql - select `id`, `name`, `icon` from `purchase_categories` where `purchase_categories`.`id` in (9) (0.92 ms) * mysql - select `id`, `name`, `type`, `sort_order` from `transaction_categories` where `transaction_categories`.`user_id` = 1 and `transaction_categories`.`user_id` is not null order by `type` asc, `sort_order` asc (1.29 ms) * mysql - select * from `icons` where `icons`.`iconable_id` in (1, 2, 3, 4, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) and `icons`.`iconable_type` = 'App\Models\Finance\TransactionCategory' (1.42 ms) * mysql - select `id`, `name`, `color` from `task_categories` where `task_categories`.`user_id` = 1 and `task_categories`.`user_id` is not null (1.18 ms)

👀 1