Level 54
MySQL 5.7.8 onward supports a native JSON data type, check your mysql version.
Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
while importing your database in cPanel! I've encountered this error:
Error
SQL query:
CREATE TABLE IF NOT EXISTS `media` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint(20) UNSIGNED NOT NULL,
`collection_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`mime_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`size` bigint(20) UNSIGNED NOT NULL,
`manipulations` json NOT NULL,
`custom_properties` json NOT NULL,
`responsive_images` json NOT NULL,
`order_column` int(10) UNSIGNED DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json NOT NULL,
`custom_properties` json NOT NULL,
`responsive_images` json N' at line 11
And THis is spatie-> media library database table:
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateMediaTable extends Migration
{
/**
* Run the migrations.
*/
public function up()
{
Schema::create('media', function (Blueprint $table) {
$table->bigIncrements('id');
$table->morphs('model');
$table->string('collection_name');
$table->string('name');
$table->string('file_name');
$table->string('mime_type')->nullable();
$table->string('disk');
$table->unsignedBigInteger('size');
$table->json('manipulations');
$table->json('custom_properties');
$table->json('responsive_images');
$table->unsignedInteger('order_column')->nullable();
$table->nullableTimestamps();
});
}
/**
* Reverse the migrations.
*/
public function down()
{
Schema::dropIfExists('media');
}
}
Plz tell? How can I import database in cPanel without occuring this error?
Please or to participate in this conversation.