LdapRecord\Models\ActiveDirectory\User dates returning as Window int

[jollyrogers11]

I have a project that has been working just fine. This morning I did an update to all my composer dependencies to start migrating over to PHP 8.2. After updating, I started getting a crash complaining that there is no format method on an int. For some reason, all of my dates in the User class are not being converted to a Carbon instance. I am looking at the User class and see the following:

/**
* The attributes that should be mutated to dates.
*
* @var array
*/
protected $dates = [
'lastlogon' => 'windows-int',
'lastlogoff' => 'windows-int',
'pwdlastset' => 'windows-int',
'lockouttime' => 'windows-int',
'accountexpires' => 'windows-int',
'badpasswordtime' => 'windows-int',
'lastlogontimestamp' => 'windows-int',
];

so the dates should be converted. Am I missing something else that is keeping these properties as integers?

[stevebauman]

Hi @jollyrogers11,

To assist you, I’m going to need to see the stack trace, or a repo/script reproducing this issue, thanks!

[jollyrogers11]

Here is what I see in the log:

[2023-05-30 11:51:41] production.ERROR: Call to a member function format() on int {"userId":"c38945b9-bbb8-4ec0-ad2e-65b593af396b","exception":"[object] (Error(code: 0): Call to a member function format() on int at C:\_repos\webint1\samus3\app\Http\Controllers\EmployeeInfoController.php:80)
[stacktrace]
#0 C:\_repos\webint1\samus3\app\Http\Controllers\EmployeeInfoController.php(211): App\Http\Controllers\EmployeeInfoController->LDAPemployeeInfo()
#1 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): App\Http\Controllers\EmployeeInfoController->employeeInfo()
#2 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction()
#3 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Route.php(259): Illuminate\Routing\ControllerDispatcher->dispatch()
#4 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Route.php(205): Illuminate\Routing\Route->runController()
#5 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Router.php(798): Illuminate\Routing\Route->run()
#6 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#7 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#8 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#9 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Auth\Middleware\Authenticate.php(44): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#10 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Auth\Middleware\Authenticate->handle()
#11 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#12 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
#13 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#14 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#15 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#16 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
#17 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle()
#18 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#19 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#20 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle()
#22 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Router.php(797): Illuminate\Pipeline\Pipeline->then()
#24 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Router.php(776): Illuminate\Routing\Router->runRouteWithinStack()
#25 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Router.php(740): Illuminate\Routing\Router->runRoute()
#26 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Routing\Router.php(729): Illuminate\Routing\Router->dispatchToRoute()
#27 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(190): Illuminate\Routing\Router->dispatch()
#28 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
#29 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#30 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#31 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#32 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#33 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#34 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#35 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#36 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#37 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#38 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#39 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Http\Middleware\HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#40 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle()
#41 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Http\Middleware\TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#42 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()
#43 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#44 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(165): Illuminate\Pipeline\Pipeline->then()
#45 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(134): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#46 C:\_repos\webint1\samus3\public\index.php(51): Illuminate\Foundation\Http\Kernel->handle()
#47 C:\_repos\webint1\samus3\vendor\laravel\framework\src\Illuminate\Foundation\resources\server.php(16): require_once('C:\\_repos\\webin...')
#48 {main}
"}

[jollyrogers11]

The line it is crashing on contains the following:

$EmployeeLDAP->accountexpires->format('m/d/Y h:i:s A')

and it is complaining about trying to call the format method on an int. (It should be a Carbon instance)

[stevebauman]

Can you dump the value of accountexpires? Is it 0?

[jollyrogers11]

accountexpires is equal to 9223372036854775807

[jollyrogers11]

I am trying to isolate what is causing the issue. I reverted all my changes from earlier, stayed on the same version of PHP(8.0.17) and just upated directorytree/ldaprecord-laravel with dependencies. After doing this, it is still returning the Windows int for accountexpires instead of the wanted Carbon instance. Here is my output from the composer update so you can see what dependencies updated:

$ composer update directorytree/ldaprecord-laravel -W
Loading composer repositories with package information
Updating dependencies
Lock file operations: 3 installs, 48 updates, 0 removals

• Upgrading brick/math (0.10.2 => 0.11.0)
• Upgrading dflydev/dot-access-data (v3.0.1 => v3.0.2)
• Upgrading directorytree/ldaprecord (v2.17.2 => v2.20.4)
• Upgrading directorytree/ldaprecord-laravel (v2.6.0 => v2.7.3)
• Locking doctrine/deprecations (v1.1.0)
• Upgrading doctrine/inflector (2.0.5 => 2.0.6)
• Upgrading doctrine/lexer (1.2.3 => 2.1.0)
• Upgrading egulias/email-validator (3.2.1 => 3.2.5)
• Upgrading graham-campbell/result-type (v1.1.0 => v1.1.1)
• Locking guzzlehttp/uri-template (v1.0.1)
• Upgrading laravel/framework (v9.34.0 => v9.52.8)
• Upgrading laravel/serializable-closure (v1.2.2 => v1.3.0)
• Upgrading league/commonmark (2.3.5 => 2.4.0)
• Upgrading league/config (v1.1.1 => v1.2.0)
• Upgrading league/flysystem (3.5.2 => 3.15.1)
• Locking league/flysystem-local (3.15.0)
• Upgrading monolog/monolog (2.8.0 => 2.9.1)
• Upgrading nesbot/carbon (2.62.1 => 2.67.0)
• Upgrading nette/schema (v1.2.2 => v1.2.3)
• Upgrading nette/utils (v3.2.8 => v4.0.0)
• Upgrading nunomaduro/termwind (v1.14.0 => v1.15.1)
• Upgrading phpoption/phpoption (1.9.0 => 1.9.1)
• Upgrading ramsey/collection (1.2.2 => 1.3.0)
• Upgrading ramsey/uuid (4.5.1 => 4.7.4)
• Upgrading symfony/console (v6.0.13 => v6.0.19)
• Upgrading symfony/css-selector (v6.0.11 => v6.0.19)
• Upgrading symfony/error-handler (v6.0.11 => v6.0.19)
• Upgrading symfony/event-dispatcher (v6.0.9 => v6.0.19)
• Upgrading symfony/finder (v6.0.11 => v6.0.19)
• Upgrading symfony/http-foundation (v6.0.13 => v6.0.20)
• Upgrading symfony/http-kernel (v6.0.13 => v6.0.20)
• Upgrading symfony/mailer (v6.0.13 => v6.0.19)
• Upgrading symfony/mime (v6.0.13 => v6.0.19)
• Upgrading symfony/polyfill-ctype (v1.26.0 => v1.27.0)
• Upgrading symfony/polyfill-intl-grapheme (v1.26.0 => v1.27.0)
• Upgrading symfony/polyfill-intl-idn (v1.26.0 => v1.27.0)
• Upgrading symfony/polyfill-intl-normalizer (v1.26.0 => v1.27.0)
• Upgrading symfony/polyfill-mbstring (v1.26.0 => v1.27.0)
• Upgrading symfony/polyfill-php72 (v1.26.0 => v1.27.0)
• Upgrading symfony/polyfill-php80 (v1.26.0 => v1.27.0)
• Upgrading symfony/polyfill-php81 (v1.26.0 => v1.27.0)
• Upgrading symfony/polyfill-uuid (v1.26.0 => v1.27.0)
• Upgrading symfony/process (v6.0.11 => v6.0.19)
• Upgrading symfony/routing (v6.0.11 => v6.0.19)
• Upgrading symfony/string (v6.0.13 => v6.0.19)
• Upgrading symfony/translation (v6.0.12 => v6.0.19)
• Upgrading symfony/uid (v6.0.13 => v6.0.19)
• Upgrading symfony/var-dumper (v6.0.13 => v6.0.19)
• Upgrading tightenco/collect (v8.83.25 => v9.52.7)
• Upgrading tijsverkoyen/css-to-inline-styles (2.2.5 => 2.2.6)
• Upgrading vlucas/phpdotenv (v5.4.1 => v5.5.0)
  Writing lock file
  Installing dependencies from lock file (including require-dev)
  Package operations: 3 installs, 48 updates, 0 removals
• Upgrading symfony/polyfill-php81 (v1.26.0 => v1.27.0): Extracting archive
• Upgrading ramsey/collection (1.2.2 => 1.3.0): Extracting archive
• Upgrading brick/math (0.10.2 => 0.11.0): Extracting archive
• Upgrading ramsey/uuid (4.5.1 => 4.7.4): Extracting archive
• Upgrading symfony/polyfill-php80 (v1.26.0 => v1.27.0): Extracting archive
• Upgrading symfony/polyfill-mbstring (v1.26.0 => v1.27.0): Extracting archive
• Upgrading symfony/polyfill-ctype (v1.26.0 => v1.27.0): Extracting archive
• Upgrading phpoption/phpoption (1.9.0 => 1.9.1): Extracting archive
• Upgrading graham-campbell/result-type (v1.1.0 => v1.1.1): Extracting archive
• Upgrading vlucas/phpdotenv (v5.4.1 => v5.5.0): Extracting archive
• Upgrading symfony/css-selector (v6.0.11 => v6.0.19): Extracting archive
• Upgrading tijsverkoyen/css-to-inline-styles (2.2.5 => 2.2.6): Extracting archive
• Upgrading symfony/var-dumper (v6.0.13 => v6.0.19): Extracting archive
• Upgrading symfony/polyfill-uuid (v1.26.0 => v1.27.0): Extracting archive
• Upgrading symfony/uid (v6.0.13 => v6.0.19): Extracting archive
• Upgrading symfony/routing (v6.0.11 => v6.0.19): Extracting archive
• Upgrading symfony/process (v6.0.11 => v6.0.19): Extracting archive
• Upgrading symfony/polyfill-php72 (v1.26.0 => v1.27.0): Extracting archive
• Upgrading symfony/polyfill-intl-normalizer (v1.26.0 => v1.27.0): Extracting archive
• Upgrading symfony/polyfill-intl-idn (v1.26.0 => v1.27.0): Extracting archive
• Upgrading symfony/mime (v6.0.13 => v6.0.19): Extracting archive
• Upgrading symfony/event-dispatcher (v6.0.9 => v6.0.19): Extracting archive
• Installing doctrine/deprecations (v1.1.0): Extracting archive
• Upgrading doctrine/lexer (1.2.3 => 2.1.0): Extracting archive
• Upgrading egulias/email-validator (3.2.1 => 3.2.5): Extracting archive
• Upgrading symfony/mailer (v6.0.13 => v6.0.19): Extracting archive
• Upgrading symfony/http-foundation (v6.0.13 => v6.0.20): Extracting archive
• Upgrading symfony/error-handler (v6.0.11 => v6.0.19): Extracting archive
• Upgrading symfony/http-kernel (v6.0.13 => v6.0.20): Extracting archive
• Upgrading symfony/finder (v6.0.11 => v6.0.19): Extracting archive
• Upgrading symfony/polyfill-intl-grapheme (v1.26.0 => v1.27.0): Extracting archive
• Upgrading symfony/string (v6.0.13 => v6.0.19): Extracting archive
• Upgrading symfony/console (v6.0.13 => v6.0.19): Extracting archive
• Upgrading nunomaduro/termwind (v1.14.0 => v1.15.1): Extracting archive
• Upgrading symfony/translation (v6.0.12 => v6.0.19): Extracting archive
• Upgrading nesbot/carbon (2.62.1 => 2.67.0): Extracting archive
• Upgrading monolog/monolog (2.8.0 => 2.9.1): Extracting archive
• Upgrading league/flysystem (3.5.2 => 3.15.1): Extracting archive
• Installing league/flysystem-local (3.15.0): Extracting archive
• Upgrading nette/utils (v3.2.8 => v4.0.0): Extracting archive
• Upgrading nette/schema (v1.2.2 => v1.2.3): Extracting archive
• Upgrading dflydev/dot-access-data (v3.0.1 => v3.0.2): Extracting archive
• Upgrading league/config (v1.1.1 => v1.2.0): Extracting archive
• Upgrading league/commonmark (2.3.5 => 2.4.0): Extracting archive
• Upgrading laravel/serializable-closure (v1.2.2 => v1.3.0): Extracting archive
• Installing guzzlehttp/uri-template (v1.0.1): Extracting archive
• Upgrading doctrine/inflector (2.0.5 => 2.0.6): Extracting archive
• Upgrading laravel/framework (v9.34.0 => v9.52.8): Extracting archive
• Upgrading tightenco/collect (v8.83.25 => v9.52.7): Extracting archive
• Upgrading directorytree/ldaprecord (v2.17.2 => v2.20.4): Extracting archive
• Upgrading directorytree/ldaprecord-laravel (v2.6.0 => v2.7.3): Extracting archive

[jollyrogers11]

This is output from tinker before updating:

$e = LdapRecord\Models\ActiveDirectory\User::where('employeeNumber', 'EP#')->first();
=> LdapRecord\Models\ActiveDirectory\User {#3739
+exists: true,
+wasRecentlyCreated: false,
+wasRecentlyRenamed: false,
}

$e->accountexpires
=> Carbon\Carbon @1221356885 {#3728
date: 2008-09-13 20:48:05.0 America/Chicago (-05:00),
}

I then run composer update directorytree/ldaprecord and it updates from version v2.17.2 => v2.20.4

Then I do the same thing in tinker:

$e = LdapRecord\Models\ActiveDirectory\User::where('employeeNumber', 'EP#')->first();
=> LdapRecord\Models\ActiveDirectory\User {#3738
+exists: true,
+wasRecentlyCreated: false,
+wasRecentlyRenamed: false,
}

$e->accountexpires
=> 9223372036854775807

[jollyrogers11]

I just stepped through and updated directorytree/ldaprecord one version at a time to see where it stops working for me. This is where I start getting an int back for accountexpires:

Upgrading directorytree/ldaprecord (v2.20.0 => v2.20.1): Extracting archive

[stevebauman]

Hey @jollyrogers11,

This comment and issue explains the change you’re encountering here:

DirectoryTree/LdapRecord#552 (comment)

The value “9223372036854775807” is PHPs maximum number for an integer, which means that the account never expires. When checking for account expiry, the above value, zero (0), or a Carbon instance may be returned. These values must be returned to be able to determine the account expiry setting from your directory properly.

Apologies for the inconvenience!

[jollyrogers11]

@stevebauman Thanks!! I'll check for zero or max first to see if is an integer before calling format.

[stevebauman]

Happy to help @jollyrogers11! Let me know if you encounter any other issues 🙏