Data too long for column 'name' at row

[fahjan]

Addding new image from using
$product->addMediaFromRequest('image')->toMediaCollection('products', 's3');

the result:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1 (Connection: mysql, SQL: insert into media (name, file_name, disk, conversions_disk, collection_name, mime_type, size, custom_properties, generated_conversions, responsive_images, manipulations, model_id, model_type, uuid, order_column, updated_at, created_at) values (Download this Premium AI-generated image about An experienced video editor in a modern editing bay multiple screens displaying video editing tools color correction panels moody lighting, and discover more t, Download-this-Premium-AI-generated-image-about-An-experienced-video-editor-in-a-modern-editing-bay-multiple-screens-displaying-video-editing-tools-color-correction-panels-moody-lighting,-and-discover-more-t.jpg, s3, s3, products, image/jpeg, 39229, [], [], [], [], 118, App\Models\Product, 427997fb-436e-4e15-aae9-027d00e13544, 1, 2025-09-06 09:52:48, 2025-09-06 09:52:48))

[tusharnain]

@fahjan Update your media table migration 'create_media_table.php'... and extend the name column size to your convenience

$table->string('name', 512); // or maybe more large, or you can change the type to TEXT

[imhayatunnabi]

This error occurs because the default name column in the media table (255 characters) is too small to accommodate the extremely long filename being generated.

Quick Fix:

Modify your create_media_table.php migration to increase the name column size:

$table->string('name', 500); // or use ->text('name') for unlimited length

Then run:

php artisan migrate:fresh
# or if you can't lose data:
php artisan make:migration increase_media_name_column_length

For the new migration:

public function up()
{
    Schema::table('media', function (Blueprint $table) {
        $table->string('name', 500)->change();
    });
}

Better Long-term Solution:

The root cause is your filename is 255+ characters. Consider sanitizing filenames before upload:

use Illuminate\Support\Str;

$product->addMediaFromRequest('image')
    ->usingName(Str::limit(request()->file('image')->getClientOriginalName(), 200, ''))
    ->toMediaCollection('products', 's3');

Or use sanitizingFileName():

$product->addMediaFromRequest('image')
    ->sanitizingFileName(function($fileName) {
        return Str::limit($fileName, 200, '');
    })
    ->toMediaCollection('products', 's3');

@fahjan you can close the issue by simply implementing this.