Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug]: Page with Timesheets: error 500 #2921

Open
Treuman opened this issue Feb 6, 2025 · 1 comment
Open

[Bug]: Page with Timesheets: error 500 #2921

Treuman opened this issue Feb 6, 2025 · 1 comment
Assignees
@marcelfolaron
Labels
Bug

Comments

@Treuman
Copy link

Treuman commented Feb 6, 2025 •
edited
Loading

What is your set up?

Self Hosted Server

Version

3.3.3

Describe the issue

timesheet pages do not work, show error 500.
Perhaps something happens during the database upgrade from leantime version 2.3.5, errors regarding the database are noticed in the trace.
used mariadb 10.6 + nginx + configuration.php + S3

  • When installing a new version of leantime, the database does not want to update(from 2.3.5), while there are no errors anywhere, neither in the database, nor in leantime! But after multiple clicks of the database update button and restarting mariadb, it is updated. I didn't see any pattern as to why it suddenly updated after a few hours.

Reproduction steps

https://leantime.domain.com/timesheets/showMy
https://leantime.domain.com/timesheets/showAll

Error Logs (LEANTIMEFOLDER/storage/logs)

[2025-02-07 02:05:51] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'zp_timesheets.modified' in 'field list' {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'zp_timesheets.modified' in 'field list' at /var/www/leantime/app/Core/Db/Repository.php:146)
[stacktrace]
#0 /var/www/leantime/app/Core/Db/Repository.php(146): PDOStatement->execute()
#1 /var/www/leantime/app/Domain/Timesheets/Repositories/Timesheets.php(328): class@anonymous->__call()
#2 /var/www/leantime/app/Domain/Timesheets/Services/Timesheets.php(289): Leantime\Domain\Timesheets\Repositories\Timesheets->getWeeklyTimesheets()
#3 /var/www/leantime/app/Domain/Timesheets/Controllers/ShowMy.php(74): Leantime\Domain\Timesheets\Services\Timesheets->getWeeklyTimesheets()
#4 /var/www/leantime/app/Core/Controller/Controller.php(73): Leantime\Domain\Timesheets\Controllers\ShowMy->run()
#5 /var/www/leantime/app/Core/Controller/Frontcontroller.php(184): Leantime\Core\Controller\Controller->callAction()
#6 /var/www/leantime/app/Core/Controller/Frontcontroller.php(83): Leantime\Core\Controller\Frontcontroller->executeAction()
#7 /var/www/leantime/app/Core/Controller/Frontcontroller.php(91): Leantime\Core\Controller\Frontcontroller->dispatch()
#8 /var/www/leantime/app/Core/Http/HttpKernel.php(128): Leantime\Core\Controller\Frontcontroller::dispatch_request()
#9 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Leantime\Core\Http\HttpKernel->Leantime\Core\Http\{closure}()
#10 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#11 /var/www/leantime/app/Core/Http/HttpKernel.php(128): Illuminate\Pipeline\Pipeline->then()
#12 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Leantime\Core\Http\HttpKernel->Leantime\Core\Http\{closure}()
#13 /var/www/leantime/app/Core/Middleware/LoadPlugins.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#14 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\LoadPlugins->handle()
#15 /var/www/leantime/app/Core/Middleware/Localization.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#16 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\Localization->handle()
#17 /var/www/leantime/app/Core/Middleware/SetCacheHeaders.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#18 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\SetCacheHeaders->handle()
#19 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#21 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#22 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#24 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#25 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#26 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#27 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#28 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\HandleCors->handle()
#29 /var/www/leantime/app/Core/Middleware/RequestRateLimiter.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#30 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\RequestRateLimiter->handle()
#31 /var/www/leantime/app/Core/Middleware/CurrentProject.php(32): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#32 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\CurrentProject->handle()
#33 /var/www/leantime/app/Core/Middleware/AuthCheck.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#34 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\AuthCheck->handle()
#35 /var/www/leantime/app/Core/Middleware/Updated.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#36 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\Updated->handle()
#37 /var/www/leantime/app/Core/Middleware/Installed.php(60): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#38 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\Installed->handle()
#39 /var/www/leantime/app/Core/Middleware/StartSession.php(128): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#40 /var/www/leantime/app/Core/Middleware/StartSession.php(95): Leantime\Core\Middleware\StartSession->handleStatefulRequest()
#41 /var/www/leantime/app/Core/Middleware/StartSession.php(64): Leantime\Core\Middleware\StartSession->handleRequestWhileBlocking()
#42 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\StartSession->handle()
#43 /var/www/leantime/app/Core/Middleware/InitialHeaders.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#44 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\InitialHeaders->handle()
#45 /var/www/leantime/app/Core/Middleware/TrustProxies.php(75): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#46 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\TrustProxies->handle()
#47 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#48 /var/www/leantime/app/Core/Http/HttpKernel.php(129): Illuminate\Pipeline\Pipeline->then()
#49 /var/www/leantime/app/Core/Http/HttpKernel.php(141): Leantime\Core\Http\HttpKernel->sendRequestThroughRouter()
#50 /var/www/leantime/app/Core/Bootloader.php(87): Leantime\Core\Http\HttpKernel->handle()
#51 /var/www/leantime/app/Core/Bootloader.php(68): Leantime\Core\Bootloader->handleRequest()
#52 /var/www/leantime/public/index.php(14): Leantime\Core\Bootloader->boot()
#53 {main}
"}
[2025-02-07 02:05:56] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'zp_tickets.modified' in 'field list' {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'zp_tickets.modified' in 'field list' at /var/www/leantime/app/Core/Db/Repository.php:146)
[stacktrace]
#0 /var/www/leantime/app/Core/Db/Repository.php(146): PDOStatement->execute()
#1 /var/www/leantime/app/Domain/Timesheets/Repositories/Timesheets.php(146): class@anonymous->__call()
#2 /var/www/leantime/app/Domain/Timesheets/Services/Timesheets.php(267): Leantime\Domain\Timesheets\Repositories\Timesheets->getAll()
#3 /var/www/leantime/app/Domain/Timesheets/Controllers/ShowAll.php(153): Leantime\Domain\Timesheets\Services\Timesheets->getAll()
#4 /var/www/leantime/app/Core/Controller/Controller.php(73): Leantime\Domain\Timesheets\Controllers\ShowAll->run()
#5 /var/www/leantime/app/Core/Controller/Frontcontroller.php(184): Leantime\Core\Controller\Controller->callAction()
#6 /var/www/leantime/app/Core/Controller/Frontcontroller.php(83): Leantime\Core\Controller\Frontcontroller->executeAction()
#7 /var/www/leantime/app/Core/Controller/Frontcontroller.php(91): Leantime\Core\Controller\Frontcontroller->dispatch()
#8 /var/www/leantime/app/Core/Http/HttpKernel.php(128): Leantime\Core\Controller\Frontcontroller::dispatch_request()
#9 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Leantime\Core\Http\HttpKernel->Leantime\Core\Http\{closure}()
#10 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#11 /var/www/leantime/app/Core/Http/HttpKernel.php(128): Illuminate\Pipeline\Pipeline->then()
#12 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Leantime\Core\Http\HttpKernel->Leantime\Core\Http\{closure}()
#13 /var/www/leantime/app/Core/Middleware/LoadPlugins.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#14 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\LoadPlugins->handle()
#15 /var/www/leantime/app/Core/Middleware/Localization.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#16 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\Localization->handle()
#17 /var/www/leantime/app/Core/Middleware/SetCacheHeaders.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#18 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\SetCacheHeaders->handle()
#19 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#21 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#22 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#24 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#25 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#26 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#27 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#28 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\HandleCors->handle()
#29 /var/www/leantime/app/Core/Middleware/RequestRateLimiter.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#30 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\RequestRateLimiter->handle()
#31 /var/www/leantime/app/Core/Middleware/CurrentProject.php(32): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#32 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\CurrentProject->handle()
#33 /var/www/leantime/app/Core/Middleware/AuthCheck.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#34 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\AuthCheck->handle()
#35 /var/www/leantime/app/Core/Middleware/Updated.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#36 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\Updated->handle()
#37 /var/www/leantime/app/Core/Middleware/Installed.php(60): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#38 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\Installed->handle()
#39 /var/www/leantime/app/Core/Middleware/StartSession.php(128): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#40 /var/www/leantime/app/Core/Middleware/StartSession.php(95): Leantime\Core\Middleware\StartSession->handleStatefulRequest()
#41 /var/www/leantime/app/Core/Middleware/StartSession.php(64): Leantime\Core\Middleware\StartSession->handleRequestWhileBlocking()
#42 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\StartSession->handle()
#43 /var/www/leantime/app/Core/Middleware/InitialHeaders.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#44 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\InitialHeaders->handle()
#45 /var/www/leantime/app/Core/Middleware/TrustProxies.php(75): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#46 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Leantime\Core\Middleware\TrustProxies->handle()
#47 /var/www/leantime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#48 /var/www/leantime/app/Core/Http/HttpKernel.php(129): Illuminate\Pipeline\Pipeline->then()
#49 /var/www/leantime/app/Core/Http/HttpKernel.php(141): Leantime\Core\Http\HttpKernel->sendRequestThroughRouter()
#50 /var/www/leantime/app/Core/Bootloader.php(87): Leantime\Core\Http\HttpKernel->handle()
#51 /var/www/leantime/app/Core/Bootloader.php(68): Leantime\Core\Bootloader->handleRequest()
#52 /var/www/leantime/public/index.php(14): Leantime\Core\Bootloader->boot()
#53 {main}
"}
@Treuman Treuman added the Bug label Feb 6, 2025
@marcelfolaron
Copy link
Contributor

That's odd. It must have failed right at the last update script, which is where this column was added. Just to be sure though, can you take a look at the database zp_settings table and check the db-version number?
Can you try to run the following sql queries manually:

#First and foremost (these seem to be the ones missing from the logs): 
ALTER TABLE `zp_timesheets` ADD COLUMN `modified` datetime NULL DEFAULT NULL;
ALTER TABLE `zp_tickets` ADD COLUMN `modified` datetime NULL DEFAULT NULL;

#Highly likely some of these are missing too
ALTER TABLE `zp_canvas` ADD COLUMN `modified` datetime NULL DEFAULT NULL;
ALTER TABLE `zp_clients` ADD COLUMN `modified` datetime NULL DEFAULT NULL;
ALTER TABLE `zp_sprints` ADD COLUMN `modified` datetime NULL DEFAULT NULL;
ALTER TABLE `zp_projects` ADD COLUMN `modified` datetime NULL DEFAULT NULL;

All update scripts are inside of https://github.com/Leantime/leantime/blob/v3.3.3/app/Domain/Install/Repositories/Install.php
update_sql_30003 seems to have failed but you may want to verify that the other db changes were applied as well.

update_sql_30002
update_sql_20407
update_sql_20406
update_sql_20405
update_sql_20402
update_sql_20401

This should cover you all the way back to 2.3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@marcelfolaron marcelfolaron

Labels
Bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Treuman @marcelfolaron