© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
FilamentF
Filament•8mo ago•
17 replies
Charles

Unique validation rule not applicable to db index

in my migration file i have applied a unique constraint to the email column of my user model. when trying to addionally apply a frontend validation in the user resource using the unique function, i get no result. thus i am still able to insert duplicat emails resulting in an sql error.

Schema::create('users', function (Blueprint $table) {
  $table->id();
  $table->string('first_name');
  $table->string('last_name');
  $table->string('email')->unique();
  $table->timestamp('email_verified_at')->nullable();
  $table->string('password');
  $table->rememberToken();
  $table->timestamps();
        });
Schema::create('users', function (Blueprint $table) {
  $table->id();
  $table->string('first_name');
  $table->string('last_name');
  $table->string('email')->unique();
  $table->timestamp('email_verified_at')->nullable();
  $table->string('password');
  $table->rememberToken();
  $table->timestamps();
        });

TextInput::make('email')
  ->required()
  ->unique(table: User::class, column: 'email')
TextInput::make('email')
  ->required()
  ->unique(table: User::class, column: 'email')

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'user@user.com' for key 'users.users_email_unique'
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'user@user.com' for key 'users.users_email_unique'
Filament banner
FilamentJoin
A powerful open source UI framework for Laravel • Build and ship admin panels & apps fast with Livewire
20,307Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Unique validation rule in repeater
FilamentFFilament / ❓┊help
3y ago
Customizing the Unique validation rule
FilamentFFilament / ❓┊help
3y ago
Unique validation
FilamentFFilament / ❓┊help
2y ago
unique validation
FilamentFFilament / ❓┊help
3y ago