starred/ProxmoxVE
1
0
Fork 0
mirror of https://github.com/community-scripts/ProxmoxVE.git synced 2026-02-05 00:29:55 +03:00
Code Issues 14 Packages Projects Releases 10 Wiki Activity

Kimai fails to create database #1898

New Issue
Closed
opened 2026-02-05 02:42:45 +03:00 by OVERLORD · 1 comment
OVERLORD commented 2026-02-05 02:42:45 +03:00
Owner
Copy Link

Originally created by @johanngrobe on GitHub (Oct 30, 2025).

✅ Have you read and understood the above guidelines?

yes

📜 What is the name of the script you are using?

Kimai

📂 What was the exact command used to execute the script?

bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/kimai.sh)"

⚙️ What settings are you using?

  • Default Settings
  • Advanced Settings

🖥️ Which Linux distribution are you using?

Debian 12

📈 Which Proxmox version are you on?

pve-manager/8.4.14/b502d23c55afcba1 (running kernel: 6.8.12-15-pve)

📝 Provide a clear and concise description of the issue.

I tried installing Kimai based on Debian 12 and 13. After you guys fixed the MySQL error everything works fine until it comes to the installation of kimai itself. I ran the script in verbose mode and attached the error message below.

🔄 Steps to reproduce the issue.

Just run install script with default settings.

❌ Paste the full error output (if available).

 Start installation ...
Database `kimai_db` for connection named default already exists. Skipped.
 Creating database ...
[notice] Migrating up to DoctrineMigrations\Version20250608143244
[error] Migration DoctrineMigrations\Version20210802160837 failed during Execution. Error: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'date_tz'"

                                                                                                                        
 [ERROR] Failed to set migration status: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or
         access violation: 1067 Invalid default value for 'date_tz'                                                     
                                                                                                                        


[ERROR] in line 53: exit code 0: while executing command $STD bin/console kimai:install -n

[ERROR] in line 1345: exit code 0: while executing command lxc-attach -n "$CTID" -- bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/install/${var_install}.sh)"

🖼️ Additional context (optional).

No response

Originally created by @johanngrobe on GitHub (Oct 30, 2025). ### ✅ Have you read and understood the above guidelines? yes ### 📜 What is the name of the script you are using? Kimai ### 📂 What was the exact command used to execute the script? bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/kimai.sh)" ### ⚙️ What settings are you using? - [x] Default Settings - [ ] Advanced Settings ### 🖥️ Which Linux distribution are you using? Debian 12 ### 📈 Which Proxmox version are you on? pve-manager/8.4.14/b502d23c55afcba1 (running kernel: 6.8.12-15-pve) ### 📝 Provide a clear and concise description of the issue. I tried installing Kimai based on Debian 12 and 13. After you guys fixed the MySQL error everything works fine until it comes to the installation of kimai itself. I ran the script in verbose mode and attached the error message below. ### 🔄 Steps to reproduce the issue. Just run install script with default settings. ### ❌ Paste the full error output (if available). ``` Start installation ... Database `kimai_db` for connection named default already exists. Skipped. Creating database ... [notice] Migrating up to DoctrineMigrations\Version20250608143244 [error] Migration DoctrineMigrations\Version20210802160837 failed during Execution. Error: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'date_tz'" [ERROR] Failed to set migration status: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'date_tz' [ERROR] in line 53: exit code 0: while executing command $STD bin/console kimai:install -n [ERROR] in line 1345: exit code 0: while executing command lxc-attach -n "$CTID" -- bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/install/${var_install}.sh)" ``` ### 🖼️ Additional context (optional). _No response_
OVERLORD added the bug label 2026-02-05 02:42:45 +03:00
OVERLORD commented 2026-02-05 02:42:49 +03:00
Author
Owner
Copy Link

@tremor021 commented on GitHub (Oct 30, 2025):

Yea, the connection string needs adjustment. Try after #8758 merges. This should fix all issues

@tremor021 commented on GitHub (Oct 30, 2025): Yea, the connection string needs adjustment. Try after #8758 merges. This should fix all issues
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Implemented in VED waiting push to Main
breaking change
bug
bug
bugfix
deferred
delete script
dependencies
enhancement
external
feature
github
help wanted
in project pipeline
invalid
investigation
json
maintenance
needs triage
new script
new script
nice to have
not a script issue
not planned
organization
pull-request
Mirrored from GitHub Pull Request
 question
refactor
rename script
security
update script
website
wontdo
🛑 Failure to comply with the guidelines
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/ProxmoxVE#1898
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?