Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/demo.cartinsight.co/Corals/core/Media/update-batches/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Spatie\MediaLibrary\MediaCollections\Models\Media;

if (!Schema::hasColumn('media', 'generated_conversions')) {
    Schema::table('media', function (Blueprint $table) {
        $table->text('generated_conversions')->nullable();
    });
}

Media::query()->where(function ($query) {
    $query->whereNull('generated_conversions')
        ->orWhere('generated_conversions', '')
        ->orWhereRaw("JSON_TYPE(generated_conversions) = 'NULL'");
})->whereRaw("JSON_LENGTH(custom_properties) > 0")
    ->update([
        'generated_conversions' => DB::raw("JSON_EXTRACT(custom_properties, '$.generated_conversions')"),
        'custom_properties' => DB::raw("JSON_REMOVE(custom_properties, '$.generated_conversions')")
    ]);