500 server error thrown when updating records

[nikolagi]

Debug mode

• I have enabled debug mode
• I have read checked the Common Issues page

Describe the bug

Hi all,

When updating records, server 500 error is thrown, record is not edited. Creating of the records is working fine.

debug :

Carbon\Exceptions\InvalidFormatException thrown with message "Unexpected data found.
Data missing"

Stacktrace:
#67 Carbon\Exceptions\InvalidFormatException in /var/www/snipeit/vendor/nesbot/carbon/src/Carbon/Traits/Creator.php:675
#66 Carbon\Carbon:rawCreateFromFormat in /var/www/snipeit/vendor/nesbot/carbon/src/Carbon/Traits/Creator.php:698
#65 Carbon\Carbon:createFromFormat in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Support/DateFactory.php:217
#64 Illuminate\Support\DateFactory:__call in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
#63 Illuminate\Support\Facades\Facade:__callStatic in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:813
#62 Illuminate\Database\Eloquent\Model:asDateTime in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:835
#61 Illuminate\Database\Eloquent\Model:fromDateTime in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:1176
#60 Illuminate\Database\Eloquent\Model:originalIsEquivalent in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:1138
#59 Illuminate\Database\Eloquent\Model:getDirty in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:1072
#58 Illuminate\Database\Eloquent\Model:isDirty in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:660
#57 Illuminate\Database\Eloquent\Model:save in /var/www/snipeit/app/Http/Controllers/Licenses/LicensesController.php:179
#56 App\Http\Controllers\Licenses\LicensesController:update in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#55 Illuminate\Routing\Controller:callAction in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
#54 Illuminate\Routing\ControllerDispatcher:dispatch in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
#53 Illuminate\Routing\Route:runController in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
#52 Illuminate\Routing\Route:run in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
#51 Illuminate\Routing\Router:Illuminate\Routing{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
#50 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php:43
#49 Illuminate\Auth\Middleware\Authenticate:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#48 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/AssetCountForSidebar.php:56
#47 App\Http\Middleware\AssetCountForSidebar:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#46 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/passport/src/Http/Middleware/CreateFreshApiToken.php:50
#45 Laravel\Passport\Http\Middleware\CreateFreshApiToken:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#44 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckForTwoFactor.php:53
#43 App\Http\Middleware\CheckForTwoFactor:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#42 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckLocale.php:37
#41 App\Http\Middleware\CheckLocale:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#40 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78
#39 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
#37 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#36 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67
#35 Illuminate\Cookie\Middleware\EncryptCookies:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#34 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
#33 Illuminate\Pipeline\Pipeline:then in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
#32 Illuminate\Routing\Router:runRouteWithinStack in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
#31 Illuminate\Routing\Router:runRoute in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
#30 Illuminate\Routing\Router:dispatchToRoute in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
#29 Illuminate\Routing\Router:dispatch in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
#28 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
#27 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:67
#26 Barryvdh\Debugbar\Middleware\InjectDebugbar:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#25 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/PreventBackHistory.php:23
#24 App\Http\Middleware\PreventBackHistory:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#23 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/SecurityHeaders.php:26
#22 App\Http\Middleware\SecurityHeaders:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#21 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
#20 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#19 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckForDebug.php:25
#18 App\Http\Middleware\CheckForDebug:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#17 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckForSetup.php:26
#16 App\Http\Middleware\CheckForSetup:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#15 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/fideloper/proxy/src/TrustProxies.php:57
#14 Fideloper\Proxy\TrustProxies:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
#12 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#11 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
#10 Illuminate\Session\Middleware\StartSession:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#9 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
#8 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/NoSessionStore.php:27
#6 App\Http\Middleware\NoSessionStore:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#5 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/barryvdh/laravel-cors/src/HandlePreflight.php:29
#4 Barryvdh\Cors\HandlePreflight:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#3 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
#2 Illuminate\Pipeline\Pipeline:then in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:145
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:110
#0 Illuminate\Foundation\Http\Kernel:handle in /var/www/snipeit/public/index.php:58

Many thanks

Reproduction steps

1.Select License
2.Edit some field for example Name or Note (modify or add text)
3. Click update
...

Expected behavior

Record to be updated with success.

Screenshots

Snipe-IT Version

Version v5.3.5 - build 6558 (master)

Operating System

Ubuntu 20.04

Web Server

Apache/2.4.41

PHP Version

PHP 7.4.3

Operating System

Windows 10

Browser

Chrome

Version

No response

Device

No response

Operating System

No response

Browser

No response

Version

No response

Error messages

No response

Additional context

Laravel Framework 6.20.29

[welcome]

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

[nikolagi]

Forgot to mention that the problem wasn't resolved by automatic upgrade that went perfectly fine.

[nikolagi]

More info :
I just found out that our installation of snipeIT was moved from another instance - no information how it was done.
Also problem is not present when editing newly created records.
All the help greatly appreciated.

[nikolagi]

Hi guys,
The problem is solved.

The problem was that somehow during migration of the database, Termination date field was populated with strange kind of value as on the picture.

After selecting proper date from the date drop down menu, everything working as expected.

Thanks for reading.