mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-05 16:49:47 +03:00
Setting Timezone breaks audit log #3864
Closed
opened 2026-02-05 07:42:51 +03:00 by OVERLORD
·
13 comments
No Branch/Tag Specified
development
l10n_development
further_theme_development
release
llm_only
vectors
v25-11
docker_env
drawio_rendering
user_permissions
ldap_host_failover
svg_image
prosemirror
captcha_example
fix/video-export
v25.12.3
v25.12.2
v25.12.1
v25.12
v25.11.6
v25.11.5
v25.11.4
v24.11.4
v25.11.3
v25.11.2
v25.11.1
v25.11
v25.07.3
v25.07.2
v25.07.1
v25.07
v25.05.2
v25.05.1
v25.05
v25.02.5
v25.02.4
v25.02.3
v25.02.2
v25.02.1
v25.02
v24.12.1
v24.12
v24.10.3
v24.10.2
v24.10.1
v24.10
v24.05.4
v24.05.3
v24.05.2
v24.05.1
v24.05
v24.02.3
v24.02.2
v24.02.1
v24.02
v23.12.3
v23.12.2
v23.12.1
v23.12
v23.10.4
v23.10.3
v23.10.2
v23.10.1
v23.10
v23.08.3
v23.08.2
v23.08.1
v23.08
v23.06.2
v23.06.1
v23.06
v23.05.2
v23.05.1
v23.05
v23.02.3
v23.02.2
v23.02.1
v23.02
v23.01.1
v23.01
v22.11.1
v22.11
v22.10.2
v22.10.1
v22.10
v22.09.1
v22.09
v22.07.3
v22.07.2
v22.07.1
v22.07
v22.06.2
v22.06.1
v22.06
v22.04.2
v22.04.1
v22.04
v22.03.1
v22.03
v22.02.3
v22.02.2
v22.02.1
v22.02
v21.12.5
v21.12.4
v21.12.3
v21.12.2
v21.12.1
v21.12
v21.11.3
v21.11.2
v21.11.1
v21.11
v21.10.3
v21.10.2
v21.10.1
v21.10
v21.08.6
v21.08.5
v21.08.4
v21.08.3
v21.08.2
v21.08.1
v21.08
v21.05.4
v21.05.3
v21.05.2
v21.05.1
v21.05
v21.04.6
v21.04.5
v21.04.4
v21.04.3
v21.04.2
v21.04.1
v21.04
v0.31.8
v0.31.7
v0.31.6
v0.31.5
v0.31.4
v0.31.3
v0.31.2
v0.31.1
v0.31.0
v0.30.7
v0.30.6
v0.30.5
v0.30.4
v0.30.3
v0.30.2
v0.30.1
v0.30.0
v0.29.3
v0.29.2
v0.29.1
v0.29.0
v0.28.3
v0.28.2
v0.28.1
v0.28.0
v0.27.5
v0.27.4
v0.27.3
v0.27.2
v0.27.1
v0.27
v0.26.4
v0.26.3
v0.26.2
v0.26.1
v0.26.0
v0.25.5
v0.25.4
v0.25.3
v0.25.2
v0.25.1
v0.25.0
v0.24.3
v0.24.2
v0.24.1
v0.24.0
v0.23.2
v0.23.1
v0.23.0
v0.22.0
v0.21.0
v0.20.3
v0.20.2
v0.20.1
v0.20.0
v0.19.0
v0.18.5
v0.18.4
v0.18.3
v0.18.2
v0.18.1
v0.18.0
v0.17.4
v0.17.3
v0.17.2
v0.17.1
v0.17.0
v0.16.3
v0.16.2
v0.16.1
v0.16.0
v0.15.3
v0.15.2
v0.15.1
v0.15.0
v0.14.3
v0.14.2
v0.14.1
v0.14.0
v0.13.1
v0.13.0
v0.12.2
v0.12.1
v0.12.0
v0.11.2
v0.11.1
v0.11.0
v0.10.0
v0.9.3
v0.9.2
v0.9.1
v0.9.0
v0.8.2
v0.8.1
v0.8.0
v0.7.6
v0.7.5
v0.7.4
v0.7.3
0.7.2
v.0.7.1
v0.7.0
v0.6.3
v0.6.2
v0.6.1
v0.6.0
v0.5.0
Labels
Clear labels
🎨 Design
📖 Docs Update
🐛 Bug
🐛 Bug
:cat2:🐈 Possible duplicate
💿 Database
☕ Open to discussion
💻 Front-End
🐕 Support
🚪 Authentication
🌍 Translations
🔌 API Task
🏭 Back-End
⛲ Upstream
🔨 Feature Request
🛠️ Enhancement
🛠️ Enhancement
🛠️ Enhancement
❤️ Happy feedback
🔒 Security
🔍 Pending Validation
💆 UX
📝 WYSIWYG Editor
🌔 Out of scope
🔩 API Request
:octocat: Admin/Meta
🖌️ View Customization
❓ Question
🚀 Priority
🛡️ Blocked
🚚 Export System
♿ A11y
🔧 Maintenance
> Markdown Editor
pull-request
Mirrored from GitHub Pull Request
No Label
🐛 Bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: starred/BookStack#3864
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @WebWalker3D on GitHub (Jun 16, 2023).
Describe the Bug
Everything is being recorded in UTC. This is because the file app.php on line 74 sets it as such. I also understand to fix this, I simply need to add the line
APP_TIMEZONE=America/New_Yorkin the .env and this should correct the timezone issue. Unfortunately, what ends up happening instead is the audit log stops recording any of the logs. Unsetting this in .env fixes the audit log recording.Steps to Reproduce
Expected Behaviour
Screenshots or Additional Context
php.ini date.timezone is set correctly See also #2509
Browser Details
No response
Exact BookStack Version
v23.02.2
PHP Version
8.2.7
Hosting Environment
Ubuntu 22.04.2 LTS VPS @ Digital Ocean, installed following the install instructions for production
@ssddanbrown commented on GitHub (Jun 17, 2023):
Hi @WebWalker3D,
Just tested this, setting
APP_TIMEZONE=America/New_Yorkworks for me.Are you sure this is the case?
And it's not the case that the logs are being recorded, but are just showing up below some of the older UTC logs (Which are recorded with a latter time)? This can happen when going back in time like you're doing here.
@WebWalker3D commented on GitHub (Jun 17, 2023):
Yes, 100% positive. If I turn the .env variable on, nothing further is logged in audit log for anything, ever. The second I remove this from .env everything works again as expected, just UTC
Get Outlook for Androidhttps://aka.ms/AAb9ysg
From: Dan Brown @.>
Sent: Friday, June 16, 2023 5:22:58 PM
To: BookStackApp/BookStack @.>
Cc: WebWalker3D @.>; Mention @.>
Subject: Re: [BookStackApp/BookStack] Setting Timezone breaks audit log (Issue #4324)
Hi @WebWalker3Dhttps://github.com/WebWalker3D,
Just tested this, setting APP_TIMEZONE=America/New_York works for me.
Unfortunately, what ends up happening instead is the audit log stops recording any of the logs.
Are you sure this is the case?
And it's not the case that the logs are being recorded, but are just showing up below some of the older UTC logs (Which are recorded with a latter time)? This can happen when going back in time like you're doing here.
—
Reply to this email directly, view it on GitHubhttps://github.com/BookStackApp/BookStack/issues/4324#issuecomment-1595332274, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BATMYSN2MFCE3K4SM6JOL6TXLTFDFANCNFSM6AAAAAAZJQWXTA.
You are receiving this because you were mentioned.Message ID: @.***>
@ssddanbrown commented on GitHub (Jun 17, 2023):
@WebWalker3D With the timezone changed as desired, If you create a completely new book, then create a new page within that book, then update that page, do these actions show in the sidebar when going back up and viewing that new book? Under the "Recent Activity" heading.
@WebWalker3D commented on GitHub (Jun 17, 2023):
Large Screenshot
@WebWalker3D commented on GitHub (Jun 17, 2023):
These times are +4 ahead. It's UTC still
@WebWalker3D commented on GitHub (Jun 17, 2023):
If I make the change in the .env file, nothing logs ever in the audit
@ssddanbrown commented on GitHub (Jun 17, 2023):
@WebWalker3D Please can you respond based upon the specific steps in my last comment?
@WebWalker3D commented on GitHub (Jun 17, 2023):
It's the same as you asked
@ssddanbrown commented on GitHub (Jun 17, 2023):
@WebWalker3D That's not what I asked. I'll reformat the steps into bullet points, and specify what to screenshot:
@WebWalker3D commented on GitHub (Jun 17, 2023):
Alright. I'll update on Sunday when I'm in front of a computer and not mobile. Appreciate your time my friend
@WebWalker3D commented on GitHub (Jun 18, 2023):
I'm stupid, sorry. lol
@ssddanbrown commented on GitHub (Jun 18, 2023):
Was data being recorded as expected, but just below/behind existing audit log entries as per my first response?
@WebWalker3D commented on GitHub (Jun 18, 2023):
It was. I just didn't see it because the system was being used so there was a bunch of logs. Today with it not being used, it was easy to see.