[2026-05-06 06:34:56] local.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'CRMTEST0' for key 'reservations_locator_unique' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: agenc137_pms, SQL: insert into `reservations` (`hotel_id`, `reservation_type`, `locator`, `guest_id`, `room_id`, `room_category_id`, `sales_channel_id`, `status`, `check_in_expected`, `check_out_expected`, `total_expected`, `total_paid`, `updated_at`, `created_at`) values (1, standard, CRMTEST0, 7, 1, 1, 1, confirmed, 2026-04-26 06:34:56, 2026-04-27 06:34:56, 1500, 1500, 2026-05-06 06:34:56, 2026-05-06 06:34:56)) {"exception":"[object] (Illuminate\\Database\\UniqueConstraintViolationException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'CRMTEST0' for key 'reservations_locator_unique' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: agenc137_pms, SQL: insert into `reservations` (`hotel_id`, `reservation_type`, `locator`, `guest_id`, `room_id`, `room_category_id`, `sales_channel_id`, `status`, `check_in_expected`, `check_out_expected`, `total_expected`, `total_paid`, `updated_at`, `created_at`) values (1, standard, CRMTEST0, 7, 1, 1, 1, confirmed, 2026-04-26 06:34:56, 2026-04-27 06:34:56, 1500, 1500, 2026-05-06 06:34:56, 2026-05-06 06:34:56)) at /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Connection.php:838)
[stacktrace]
#0 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Connection.php(794): Illuminate\\Database\\Connection->runQueryCallback('insert into `re...', Array, Object(Closure))
#1 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run('insert into `re...', Array, Object(Closure))
#2 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/MySqlProcessor.php(35): Illuminate\\Database\\MySqlConnection->insert('insert into `re...', Array, 'id')
#3 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(4170): Illuminate\\Database\\Query\\Processors\\MySqlProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into `re...', Array, 'id')
#4 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2237): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id')
#5 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1436): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array)
#6 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1401): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array)
#7 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder))
#8 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save()
#9 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Support/helpers.php(393): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\Reservation))
#10 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap(Object(App\\Models\\Reservation), Object(Closure))
#11 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create(Array)
#12 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'create', Array)
#13 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call('create', Array)
#14 /home/agenc137/pms.agencialocal.com.br/test_crm.php(31): Illuminate\\Database\\Eloquent\\Model::__callStatic('create', Array)
#15 {main}

[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'CRMTEST0' for key 'reservations_locator_unique' at /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php:53)
[stacktrace]
#0 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(53): PDOStatement->execute()
#1 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Connection.php(827): Illuminate\\Database\\MySqlConnection->Illuminate\\Database\\{closure}('insert into `re...', Array)
#2 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Connection.php(794): Illuminate\\Database\\Connection->runQueryCallback('insert into `re...', Array, Object(Closure))
#3 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\\Database\\Connection->run('insert into `re...', Array, Object(Closure))
#4 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/MySqlProcessor.php(35): Illuminate\\Database\\MySqlConnection->insert('insert into `re...', Array, 'id')
#5 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(4170): Illuminate\\Database\\Query\\Processors\\MySqlProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into `re...', Array, 'id')
#6 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2237): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id')
#7 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1436): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array)
#8 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1401): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array)
#9 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1240): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder))
#10 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1219): Illuminate\\Database\\Eloquent\\Model->save()
#11 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Support/helpers.php(393): Illuminate\\Database\\Eloquent\\Builder->Illuminate\\Database\\Eloquent\\{closure}(Object(App\\Models\\Reservation))
#12 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1218): tap(Object(App\\Models\\Reservation), Object(Closure))
#13 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\\Database\\Eloquent\\Builder->create(Array)
#14 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2540): Illuminate\\Database\\Eloquent\\Model->forwardCallTo(Object(Illuminate\\Database\\Eloquent\\Builder), 'create', Array)
#15 /home/agenc137/pms.agencialocal.com.br/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2556): Illuminate\\Database\\Eloquent\\Model->__call('create', Array)
#16 /home/agenc137/pms.agencialocal.com.br/test_crm.php(31): Illuminate\\Database\\Eloquent\\Model::__callStatic('create', Array)
#17 {main}
"}