Because i am interested to migrate to CakePHP 4 now i give more details:
pls don’t suggest to change the database or field type
Environment:
Your version of PHP is 7.2.0 or higher (detected 7.2.26-1+ubuntu18.04.1+deb.sury.org+1).
Your version of PHP has the mbstring extension loaded.
Your version of PHP has the openssl extension loaded.
Your version of PHP has the intl extension loaded.
models and controllers was created by bake
configs are from: https://github.com/cakephp/app/tree/master/config
in /config/app.php i have:
‘App’ ‘defaultLocale’ => env(‘APP_DEFAULT_LOCALE’, ‘en_US’),
‘App’ ‘defaultTimezone’ => env(‘APP_DEFAULT_TIMEZONE’, ‘UTC’),
‘Datasources’ ‘default’ ‘timezone’ => ‘UTC’,
in /config/bootstrap i have:
date_default_timezone_set(Configure::read(‘App.defaultTimezone’));
ini_set(‘intl.default_locale’, Configure::read(‘App.defaultLocale’));
in the Users.created field i have : 2015-03-19 22:37:48
the error persist also for MutableDateTime or FrozenTime
inside controller i have:
$this->loadModel(‘Usermgmt.Users’);
$query = $this->Users->find(‘all’, [
‘fields’ => [
‘id’,
‘active’,
‘first_name’,
‘last_name’,
‘username’,
‘email’,
‘user_group_id’,
‘email_verified’,
‘created’,
],
‘order’ => ‘Users.id ASC’,
‘limit’ => 1,
]);
$users = $query->toArray();
debug($users);
here are the logs:
2020-01-24 10:01:13 Error: [Exception] DateTimeImmutable::__construct(): Failed to parse time string (19/03/2015 22:37:48) at position 0 (1): Unexpected character in /var/www/crm41.hecamga.it/vendor/cakephp/chronos/src/Chronos.php on line 99
Stack Trace:
- /var/www/crm41.hecamga.it/vendor/cakephp/chronos/src/Chronos.php:99
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/I18n/FrozenTime.php:141
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Database/Type/DateTimeType.php:204
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Database/FieldTypeConverter.php:127
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Database/Statement/CallbackStatement.php:63
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/ORM/ResultSet.php:426
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/ORM/ResultSet.php:261
- iterator_to_array - [internal], line ??- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Collection/CollectionTrait.php:687
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php:309
- /var/www/crm41.hecamga.it/plugins/Usermgmt/src/Controller/UsersController.php:63
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Controller/Controller.php:524
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php:79
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/BaseApplication.php:229
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:77
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php:156
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php:68
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php:118
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:58
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Server.php:90
- /var/www/crm41.hecamga.it/webroot/index.php:40
Request URL: /usermgmt/users/index
2020-01-24 10:02:15 Error: [Exception] DateTime::__construct(): Failed to parse time string (19/03/2015 22:37:48) at position 0 (1): Unexpected character in /var/www/crm41.hecamga.it/vendor/cakephp/chronos/src/MutableDateTime.php on line 90
Stack Trace:
- /var/www/crm41.hecamga.it/vendor/cakephp/chronos/src/MutableDateTime.php:90
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/I18n/Time.php:138
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Database/Type/DateTimeType.php:204
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Database/FieldTypeConverter.php:127
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Database/Statement/CallbackStatement.php:63
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/ORM/ResultSet.php:426
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/ORM/ResultSet.php:261
- iterator_to_array - [internal], line ??- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Collection/CollectionTrait.php:687
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php:309
- /var/www/crm41.hecamga.it/plugins/Usermgmt/src/Controller/UsersController.php:63
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Controller/Controller.php:524
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php:79
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/BaseApplication.php:229
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:77
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php:156
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php:68
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php:118
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Runner.php:58
- /var/www/crm41.hecamga.it/vendor/cakephp/cakephp/src/Http/Server.php:90
- /var/www/crm41.hecamga.it/webroot/index.php:40
Request URL: /usermgmt/users/index
I have no idea from where the format 19/03/2015 22:37:48 comes
Welcome for all suggestions to solve my problem