Wrong result through API call of updated_at property. #4153

Closed
opened 2026-02-05 08:11:14 +03:00 by OVERLORD · 0 comments
Owner

Originally created by @Phonksy on GitHub (Sep 6, 2023).

Describe the Bug

In .env file I have set the timezone to this value:
APP_TIMEZONE = Europe/Vilnius
Even so, the time of updated_at property is always wrong. Three hours early to be exact, but the same property in MySql database shows the correct time.

Steps to Reproduce

  1. Using any API call containing updated_at property.

Expected Behaviour

I expect to get the correct time of updated_at property.

Screenshots or Additional Context

Image1 shows the result in the api call.
Image2 shows MySql data base time of the same property.
image1
image2

Browser Details

No response

Exact BookStack Version

v23.06.2

PHP Version

No response

Hosting Environment

I used XAMPP on windows to install bookstack.

Originally created by @Phonksy on GitHub (Sep 6, 2023). ### Describe the Bug In .env file I have set the timezone to this value: APP_TIMEZONE = Europe/Vilnius Even so, the time of updated_at property is always wrong. Three hours early to be exact, but the same property in MySql database shows the correct time. ### Steps to Reproduce 1. Using any API call containing updated_at property. ### Expected Behaviour I expect to get the correct time of updated_at property. ### Screenshots or Additional Context Image1 shows the result in the api call. Image2 shows MySql data base time of the same property. ![image1](https://github.com/BookStackApp/BookStack/assets/101298331/5998a4be-cf64-4b80-a348-f836b13526d7) ![image2](https://github.com/BookStackApp/BookStack/assets/101298331/42018c32-577a-483a-be58-c89101b97a3f) ### Browser Details _No response_ ### Exact BookStack Version v23.06.2 ### PHP Version _No response_ ### Hosting Environment I used XAMPP on windows to install bookstack.
OVERLORD added the 🐛 Bug label 2026-02-05 08:11:14 +03:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#4153