Merhabalar projemi kendi sunucumda plesk kontrol paneli kurdum fakat php artisan migrate yaptığımda aşağıdaki hatayı alıyorum.
Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause (SQL: create table `admins` (`id` int unsigned not null auto_increment primary key, `admin_name` varchar(50) not null, `admin_surname` varchar(50) not null, `admin_email` varchar(80) not null, `admin_password` varchar(100) not null, `permission_id` tinyint(1) not null default '0', `is_active` tinyint(1) not null default '0', `remember_token` varchar(100) null, `created_at` timestamp not null default CURRENT_TIMESTAMP, `updated_at` timestamp not null default CURRENT_TIMESTAMP on UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
667| // If an exception occurs when attempting to run a query, we'll format the error
668| // message to include the bindings with SQL, which will make this exception a
669| // lot more helpful to the developer instead of just the database's errors.
670| catch (Exception $e) {
> 671| throw new QueryException(
672| $query, $this->prepareBindings($bindings), $e
673| );
674| }
675|
+9 vendor frames
10 database/migrations/2020_06_23_112543_create_admin_table.php:28
Illuminate\Support\Facades\Facade::__callStatic()
+22 vendor frames
33 artisan:37
Illuminate\Foundation\Console\Kernel::handle()