atm to get the error you will use name.code but is there a way to pass an option that make the error msg unified whether am using a code or not ?

ex.

// form
<input name="slug[en]" value="abc">
<input name="slug[nl]" value="abc">

// validate
$attributes = request()->validate([
    'slug.*' => ["unique_translation:posts,slug,{$post->id}"],
]);

// error
@if($errors->has('slug'))
    {{ $errors->first('slug') }}
@endif

this way , either i use a single input or array, the error condition doesnt change.

atm, here is how i do the validation

foreach ($locales as $code) {
    $v = Validator::make($request->all(), ["slug.$code" => "unique:pages,slug->$code," . $id ?: '']);

    if ($v->fails()) {
        $validator->errors()->add('slug', 'this slug is already taken');
    }
}

on a side note

also is it possible to use the validation rule with | pipe rules or do i have to use the array instead ?

My hosting provider does not support MySQL version 5.7. Maximum supported version is 5.6.46. So I'm facing JSON_EXTRACT and JSON_UNQUOTE function does not exist error.

Is there any fix on that?

Hi Thanks for your extension.

I have some trouble.

Example

<input type="text" name="post_name[de]">
<input type="text" name="post_name[en]">

class MyRequest extends FormRequest{
  public function rules(): array
    {
        return [
            'post_name.*' => [
                UniqueTranslationRule::for('posts', 'name')
            ]
        ];
}}

When i put exists values and submit form, i got a lot of messages:

Is there any way to generate only one message for each language?

Best regards

How can I ignore soft deleted records?

'FIELD_NAME.*' => [
UniqueTranslationRule::for('TABLE_NAME', 'FIELD_NAME')->ignore(!0, 'deleted_at') -> NO WORKS
UniqueTranslationRule::for('TABLE_NAME', 'FIELD_NAME')->ignore(!NULL, 'deleted_at') -> NO WORKS
UniqueTranslationRule::for('TABLE_NAME', 'FIELD_NAME')->whereNull('deleted_at') -> NO WORKS
]

I form for saving the category. The name field is unique. I'm using FormRequest for validating the form. Create works fine. but while updating getting error showing The name.en has already been taken.

form fields

                <input class="form-control" name="name[en]" type="text" id="name-en" value="{{ old('name[en]', optional($serviceCategory)->getTranslation('name','en')) }}" minlength="1" maxlength="255" placeholder="{{ __('preferencesCategory.name_en__placeholder') }}">
                <input class="form-control" name="name[ar]" type="text" id="name-ar" value="{{ old('name[ar]', optional($serviceCategory)->getTranslation('name','ar')) }}" minlength="1" maxlength="255" placeholder="{{ __('preferencesCategory.name_ar__placeholder') }}">

FormRequest.php

  public function rules()
    {
        return [
            'code' => 'string|min:1|nullable',
            'name.*' => 'required|string|min:1|max:255|unique_translation:service_categories,name,{$this->serviceCategory->id}',
            'status' => 'string|min:1|nullable',
        ];

web.php (route file)

Route::put('service_category/{serviceCategory}', 'ServiceCategoriesController@update')
            ->name('service_categories.service_category.update')->where('id', '[0-9]+');

controller.php

public function update(ServiceCategory $serviceCategory, ServiceCategoriesFormRequest $request)
    {
        try {
            $data = $request->getData();
            $data['updated_by'] = \Auth::guard('admin')->user()->id;

            $serviceCategory->update($data);

            return redirect()->route('service_categories.service_category.index')
                ->with('success_message', 'Service Category was successfully updated.');
        } catch (Exception $exception) {
            return back()->withInput()
                ->withErrors(['unexpected_error' => 'Unexpected error occurred while trying to process your request.']);
        }
    }

Hello @ivanvermeyen!

First, thanks for developing this great package. I'm trying to use it on a Laravel 8 project I started recently, but I can't get it to work. I'm pretty sure I forgot something stupid, but I've been looking for a week and even showed it to a colleague, but we can't find an error. Maybe you can help me?

When I try to update a post with the same slug as another (or create once with the same slug as another), the UniqueTranslationRule rule doesn't detect it. My form request App\Http\Requests\Admin\PostRequest has this rules function :

public function rules()
    {
        return [
            'post.title' => 'required|string',
            'post.slug' => ['required', 'max:2000', UniqueTranslationRule::for('posts', 'slug'), 'regex:/^([a-z0-9\-\/]*)$/'],
            'post.category_id' => ['nullable', 'numeric', Rule::exists('categories', 'id')
                ->where('deleted_at', NULL)->where('type', Category::TYPE_POST)],
        ];
    }

Things I checked :

• Spatie\laravel-translatable is working (all data are saved in JSON in the database)
• I call use CodeZero\UniqueTranslation\UniqueTranslationRule; at the beginning of the file
• I remove and resinstalled the package with composer require codezero/laravel-unique-translation

Thanks in advance ! 🙏

In this case:

{
  "en":"unique_title", //scoped for en
  "lt":"unique_title", //scoped for lt
}

<input name="title_en" value="unique_title" />
<input name="title_lt" value="some other title"/>

I want to have different validation for each input like:

$attributes = request()->validate([
    'title_lt' => 'required|unique_translation:posts:title',
    'title_en' => 'unique_translation:posts:title',
]);

how would i check against a specific value? Or this will just work?

It seems that the where clause in the unique_translation rule is case sensitive.

https://github.com/codezero-be/laravel-unique-translation/blob/1eb3d56b1f4af36b4985730619838bb124436b81/src/UniqueTranslationValidator.php#L161-L164

According to my Google searches, MySQL is supposed to be case insensitive when using a collation that ends in _ci (I'm using utf8mb4_unicode_ci). But that's not what my tests are saying...

Is anyone else having this issue?

am not sure if its an issue with the https://github.com/spatie/laravel-tags package or something is missing from the validation package,

but here is what i have

$request->validate([
    'name.*' => 'unique_translation:tags,name,' . $id
]);

the db name column i will update is

{"en": "black"}

and will be replaced with

{
  "en": "test",
  "fr": null
}

but i keep getting the error that the item already exists in the db, so maybe u can help me with this one

Hello, I'm using this package with MariaDB 10.6.9, Laravel 9, PHP 8.1 and Spatie Laravel Translatable v6, but it is not working. Is it compatible with this environment or only compatible only with MySQL? Thanks.

Hi! Fantastic package. Works great during browser usage, but I get a really weird error when testing the form I want to validate. Basics: I am using Laravel-translatable from Spatie and want to check that the title is unique in a JSON column for a specific locale. My form is really simple:

<label>TítuloES</label><br>
<input class="border" type="text" name="title[es]"><br>
<label>TítuloEN</label><br>
<input class="border" type="text" name="title[en]"><br>

My validation looks like this:

 $attributes = request()->validate([
            'title.*' => 'required|max:255|unique_translation:posts,title',
            'summary.*' => 'required',
            'content.*' => 'required',
            'imagetitle' => [
                'sometimes', 
                'mimes:jpeg,jpg,png'
                ]
        ]);

When I use the web, it works, but when I test it, I get a super long error, but the most important part seems this one:

The following exception occurred during the last request:

ErrorException: Undefined array key "collation" in E:\Programas\laragon\www\webtronica\vendor\codezero\laravel-unique-translation\src\UniqueTranslationValidator.php:238
Stack trace:
#0 E:\Programas\laragon\www\myapp\vendor\laravel\framework\src\Illuminate\Foundation\Bootstrap\HandleExceptions.php(259): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(2, 'Undefined array...', 'E:\\Programas\\la...', 238)
#1 E:\Programas\laragon\www\myapp\vendor\codezero\laravel-unique-translation\src\UniqueTranslationValidator.php(238): Illuminate\Foundation\Bootstrap\HandleExceptions->Illuminate\Foundation\Bootstrap\{closure}(2, 'Undefined array...', 'E:\\Programas\\la...', 238)
#2 E:\Programas\laragon\www\myapp\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1551): CodeZero\UniqueTranslation\UniqueTranslationValidator->CodeZero\UniqueTranslation\{closure}(Object(Illuminate\Database\Query\Builder))

I guess the package is trying to get some info from the DB, but it is not getting it. Then, everything breaks. So, I have 2 questions: Should I somehow modify configuration of PHP unit? Now it looks like this:

  <php>
    <server name="APP_ENV" value="testing"/>
    <server name="BCRYPT_ROUNDS" value="4"/>
    <server name="CACHE_DRIVER" value="array"/>
    <server name="DB_CONNECTION" value="sqlite"/>
    <server name="DB_DATABASE" value=":memory:"/>
    <server name="MAIL_DRIVER" value="array"/>
    <server name="QUEUE_CONNECTION" value="sync"/>
    <server name="SESSION_DRIVER" value="array"/>
    <env name="DB_CONNECTION" value="sqlite"/>
    <env name="RECAPTCHA_KEY" value="6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI"/>
    <env name="RECAPTCHA_SECRET" value="6LeIxAcTAAAAAGG-vFI1TnRWxMZNFuojJ4WifJWe"/>
  </php>
</phpunit>

Question number 2: when using browser and submitting the form, no error is seen and the post is created with success. The collation fields of my database are empty, so I don't understand how its working:

Many thanks!!!