SVI/ProxmoxVE
1
0
Fork 0
mirror of https://github.com/community-scripts/ProxmoxVE.git synced 2026-07-22 22:03:55 -04:00
Code Issues 2.6k Packages Projects Releases 10 Wiki Activity

Kimai 2.43.0 update process fails, likely (#4247) Composer issue #2320

New Issue
Closed
opened 2025-11-20 05:27:26 -05:00 by saavagebueno · 10 comments
saavagebueno commented 2025-11-20 05:27:26 -05:00
Owner
Copy Link

Originally created by @pintapass on GitHub (Nov 14, 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?

update

⚙️ What settings are you using?

  • Default Settings
  • Advanced Settings

🖥️ Which Linux distribution are you using?

Debian 12

📈 Which Proxmox version are you on?

9.0.11

📝 Provide a clear and concise description of the issue.

Using the "update" command results in an inaccessible Kimai installation.

🔄 Steps to reproduce the issue.

  1. Type "update" in the LXC console.
  2. Monitor verbose output.
  3. Feel your heart sink as your essential time-tracking solution is inaccessible.

❌ Paste the full error output (if available).

[...]

Package doctrine/cache is abandoned, you should avoid using it. No replacement was suggested.
Generating optimized autoload files
94 packages you are using are looking for funding.
Use the composer fund command to find out more!

Run composer recipes at any time to see the status of your Symfony recipes.

Executing script cache:clear [KO]
[KO]
Script cache:clear returned with error code 1
!!
!! // Clearing the cache for the prod environment with debug false
!!
!!
!! In YamlFileLoader.php line 809:
!!
!! There is no extension able to load the configuration for "admin_lte" (in "/
!! opt/kimai/config/packages/local.yaml"). Looked for namespace "admin_lte", f
!! ound ""framework", "doctrine", "doctrine_migrations", "monolog", "twig", "s
!! ecurity", "jms_serializer", "fos_rest", "nelmio_api_doc", "nelmio_cors", "w
!! ebpack_encore", "twig_extra", "tabler", "scheb_two_factor", "kimai"".
!!
!!
!! cache:clear [--no-warmup] [--no-optional-warmers]
!!
!!
Script @auto-scripts was called via post-install-cmd

[ERROR] in line 59: exit code 0: while executing command $STD composer install --no-dev --optimize-autoloader

You have mail in /var/mail/root

🖼️ Additional context (optional).

This seems to be the same bug that was reported in #4247. Even if the newer update scripts are corrected, how does someone repair an existing install in order to update to the latest Kimai version?

Originally created by @pintapass on GitHub (Nov 14, 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? update ### ⚙️ What settings are you using? - [x] Default Settings - [ ] Advanced Settings ### 🖥️ Which Linux distribution are you using? Debian 12 ### 📈 Which Proxmox version are you on? 9.0.11 ### 📝 Provide a clear and concise description of the issue. Using the "update" command results in an inaccessible Kimai installation. ### 🔄 Steps to reproduce the issue. 1. Type "update" in the LXC console. 2. Monitor verbose output. 3. Feel your heart sink as your essential time-tracking solution is inaccessible. ### ❌ Paste the full error output (if available). [...] Package doctrine/cache is abandoned, you should avoid using it. No replacement was suggested. Generating optimized autoload files 94 packages you are using are looking for funding. Use the `composer fund` command to find out more! Run composer recipes at any time to see the status of your Symfony recipes. Executing script cache:clear [KO] [KO] Script cache:clear returned with error code 1 !! !! // Clearing the cache for the prod environment with debug false !! !! !! In YamlFileLoader.php line 809: !! !! There is no extension able to load the configuration for "admin_lte" (in "/ !! opt/kimai/config/packages/local.yaml"). Looked for namespace "admin_lte", f !! ound ""framework", "doctrine", "doctrine_migrations", "monolog", "twig", "s !! ecurity", "jms_serializer", "fos_rest", "nelmio_api_doc", "nelmio_cors", "w !! ebpack_encore", "twig_extra", "tabler", "scheb_two_factor", "kimai"". !! !! !! cache:clear [--no-warmup] [--no-optional-warmers] !! !! Script @auto-scripts was called via post-install-cmd [ERROR] in line 59: exit code 0: while executing command $STD composer install --no-dev --optimize-autoloader You have mail in /var/mail/root ### 🖼️ Additional context (optional). This seems to be the same bug that was reported in #4247. Even if the newer update scripts are corrected, how does someone repair an existing install in order to update to the latest Kimai version?
saavagebueno added the bug label 2025-11-20 05:27:26 -05:00
saavagebueno commented 2025-11-20 05:27:26 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Nov 14, 2025):

I dont See any Change in there Changelog. Maybe you Post it there. Looks Like an Upstream issue

@MickLesk commented on GitHub (Nov 14, 2025): I dont See any Change in there Changelog. Maybe you Post it there. Looks Like an Upstream issue
saavagebueno commented 2025-11-20 05:27:26 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Nov 15, 2025):

ah, can you check following:
nano /opt/kimai/config/packages/local.yaml

is there admin_lte or something inside? that seems to be deprecated

@MickLesk commented on GitHub (Nov 15, 2025): ah, can you check following: nano /opt/kimai/config/packages/local.yaml is there admin_lte or something inside? that seems to be deprecated
saavagebueno commented 2025-11-20 05:27:26 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Nov 15, 2025):

https://github.com/kimai/kimai/issues/5701

@MickLesk commented on GitHub (Nov 15, 2025): https://github.com/kimai/kimai/issues/5701
saavagebueno commented 2025-11-20 05:27:27 -05:00
Author
Owner
Copy Link

@pintapass commented on GitHub (Nov 16, 2025):

So what do I do to restore my installation?

@pintapass commented on GitHub (Nov 16, 2025): So what do I do to restore my installation?
saavagebueno commented 2025-11-20 05:27:27 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Nov 16, 2025):

Snapshots Like every Update.

@MickLesk commented on GitHub (Nov 16, 2025): Snapshots Like every Update.
saavagebueno commented 2025-11-20 05:27:27 -05:00
Author
Owner
Copy Link

@pintapass commented on GitHub (Nov 16, 2025):

Snapshots Like every Update.

Rolling back to a working state and updating now results in the "Something Went Wrong" error and I get the following output after trying to clear the cache:

 [ERROR] There is no extension able to load the configuration for "admin_lte" (in                                       
         "/opt/kimai/config/packages/local.yaml"). Looked for namespace "admin_lte", found ""framework", "doctrine",    
         "doctrine_migrations", "monolog", "twig", "security", "jms_serializer", "fos_rest", "nelmio_api_doc",          
         "nelmio_cors", "webpack_encore", "twig_extra", "tabler", "scheb_two_factor", "kimai"".
@pintapass commented on GitHub (Nov 16, 2025): > Snapshots Like every Update. Rolling back to a working state and updating now results in the "Something Went Wrong" error and I get the following output after trying to clear the cache: ``` [ERROR] There is no extension able to load the configuration for "admin_lte" (in "/opt/kimai/config/packages/local.yaml"). Looked for namespace "admin_lte", found ""framework", "doctrine", "doctrine_migrations", "monolog", "twig", "security", "jms_serializer", "fos_rest", "nelmio_api_doc", "nelmio_cors", "webpack_encore", "twig_extra", "tabler", "scheb_two_factor", "kimai"". ```
saavagebueno commented 2025-11-20 05:27:27 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Nov 16, 2025):

Yeah you need to remove this before update Like i Said above

@MickLesk commented on GitHub (Nov 16, 2025): Yeah you need to remove this before update Like i Said above
saavagebueno commented 2025-11-20 05:27:27 -05:00
Author
Owner
Copy Link

@pintapass commented on GitHub (Nov 16, 2025):

After removing the "admin_lte" line and updating, I still get the following error:

500
Something is wrong
A critical error occurred, please try again. You may have found a software problem, please contact your administrator if the problem persists.

The update seems to proceed without error. But I've tried fixing permissions, rebuilding the cache, and nothing works.

@pintapass commented on GitHub (Nov 16, 2025): After removing the "admin_lte" line and updating, I still get the following error: 500 Something is wrong A critical error occurred, please try again. You may have found a software problem, please contact your administrator if the problem persists. The update seems to proceed without error. But I've tried fixing permissions, rebuilding the cache, and nothing works.
saavagebueno commented 2025-11-20 05:27:27 -05:00
Author
Owner
Copy Link

@pintapass commented on GitHub (Nov 16, 2025):

I cloned the working Kimai LXC, removed the problematic "local.yaml" and then updated. I go straight into the "Something is wrong" error.

prod.log is rife with errors, even after clearing the cache and attempting to fix permissions. This is just a small sample:

[2025-11-16 18:22:23] [request] INFO: Matched route "timesheet". {"route":"timesheet","route_parameters":{"route":"timesheet","page":1,"controller":"App\Controller\TimesheetController::indexAction","locale":"en"},"request_uri":"http://192.168.1.27/index.php/en/timesheet/","method":"GET"} []
[2025-11-16 18:22:23] [request] CRITICAL: Uncaught PHP Exception Twig\Error\RuntimeError: "An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0.address_line1' in 'field list'") in "datatable.html.twig" at line 14." at datatable.html.twig line 14 {"exception":"[object] (Twig\Error\RuntimeError(code: 0): An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0.address_line1' in 'field list'") in "datatable.html.twig" at line 14. at /opt/kimai/templates/datatable.html.twig:14)\n[previous exception] [object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} []
[2025-11-16 18:27:27] [request] INFO: Matched route "timesheet". {"route":"timesheet","route_parameters":{"route":"timesheet","page":1,"controller":"App\Controller\TimesheetController::indexAction","locale":"en"},"request_uri":"http://192.168.1.27/index.php/en/timesheet/","method":"GET"} []
[2025-11-16 18:27:27] [request] CRITICAL: Uncaught PHP Exception Twig\Error\RuntimeError: "An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0.address_line1' in 'field list'") in "datatable.html.twig" at line 14." at datatable.html.twig line 14 {"exception":"[object] (Twig\Error\RuntimeError(code: 0): An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0.address_line1' in 'field list'") in "datatable.html.twig" at line 14. at /opt/kimai/templates/datatable.html.twig:14)\n[previous exception] [object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"}

@pintapass commented on GitHub (Nov 16, 2025): I cloned the working Kimai LXC, removed the problematic "local.yaml" and then updated. I go straight into the "Something is wrong" error. prod.log is rife with errors, even after clearing the cache and attempting to fix permissions. This is just a small sample: [2025-11-16 18:22:23] [request] INFO: Matched route "timesheet". {"route":"timesheet","route_parameters":{"_route":"timesheet","page":1,"_controller":"App\\Controller\\TimesheetController::indexAction","_locale":"en"},"request_uri":"http://192.168.1.27/index.php/en/timesheet/","method":"GET"} [] [2025-11-16 18:22:23] [request] CRITICAL: Uncaught PHP Exception Twig\Error\RuntimeError: "An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list'") in "datatable.html.twig" at line 14." at datatable.html.twig line 14 {"exception":"[object] (Twig\\Error\\RuntimeError(code: 0): An exception has been thrown during the rendering of a template (\"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list'\") in \"datatable.html.twig\" at line 14. at /opt/kimai/templates/datatable.html.twig:14)\n[previous exception] [object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} [] [2025-11-16 18:27:27] [request] INFO: Matched route "timesheet". {"route":"timesheet","route_parameters":{"_route":"timesheet","page":1,"_controller":"App\\Controller\\TimesheetController::indexAction","_locale":"en"},"request_uri":"http://192.168.1.27/index.php/en/timesheet/","method":"GET"} [] [2025-11-16 18:27:27] [request] CRITICAL: Uncaught PHP Exception Twig\Error\RuntimeError: "An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list'") in "datatable.html.twig" at line 14." at datatable.html.twig line 14 {"exception":"[object] (Twig\\Error\\RuntimeError(code: 0): An exception has been thrown during the rendering of a template (\"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list'\") in \"datatable.html.twig\" at line 14. at /opt/kimai/templates/datatable.html.twig:14)\n[previous exception] [object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k0_.address_line1' in 'field list' at /opt/kimai/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"}
saavagebueno commented 2025-11-20 05:27:27 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Nov 16, 2025):

Create this to kimai, we dont migrate something, its there composer action

@MickLesk commented on GitHub (Nov 16, 2025): Create this to kimai, we dont migrate something, its there composer action
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
🛑 Failure to comply with the guidelines
breaking change
bug
bug
bugfix
deferred
delete script
dependencies
enhancement
external
feature
github
help wanted
Implemented in VED waiting push to Main
in project pipeline
invalid
investigation
json
maintenance
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
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
saavagebueno
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: SVI/ProxmoxVE#2320
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?