SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

When i tried run the /lnms migrate
I getting these errors.

i found the full error in log:

[ERROR] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-1-App\Models\User’ for key ‘PRIMARY’ (Connection: mysql, SQL: insert into model_has_roles (role_id, model_type, model_id) values (1, App\Models\User, 1)) {“exception”:“[object] (Illuminate\Database\UniqueConstraintViolationException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-1-App\Models\User’ for key ‘PRIMARY’ (Connection: mysql, SQL: insert into model_has_roles (role_id, model_type, model_id) values (1, App\Models\User, 1)) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:824)
[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-1-App\Models\User’ for key ‘PRIMARY’ at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php:45)”}

Could you please let me know how to fix this

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.