You can't have a dot in you column name.
You should also use lowercase letters in the names, not a mix.
Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
This is my migration Code : public function up() { Schema::create('ressos', function (Blueprint $table) { $table->id(); $table->string('Personne'); $table->string('Nom_F'); $table->string('Nom_A'); $table->string('Cni'); $table->string('Secteur'); $table->string('Fjuridique'); $table->string('Activite'); $table->string('Membre'); $table->string('Adherant'); $table->string('Patente'); $table->string('R.C_Analytique'); $table->string('R.C_Chronologique'); $table->date('dateRc'); $table->string('ice'); $table->string('Identification_Fiscale'); $table->date('dateIDF'); $table->string('Address'); $table->string('commune'); $table->string('tele'); $table->string('Gsm'); $table->string('Fax'); $table->string('email'); $table->string('site');
$table->timestamps();
});
}
and this is the error that I got from using the PHP artisan migrate command :
SQLSTATE[42000]: Syntax error or access violation: 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 '.C_Analytique varchar(191) not null, R.C_Chronologique varchar(191) not nu' at line 1 (SQL: create table ressos (id bigint unsigned not null auto_increment primary key, Personne varchar(191) not null, Nom_F varchar(191) not null, Nom_A varchar(191) not null, Cni varchar(191) not null, Secteur varchar(191) not null, Fjuridique varchar(191) not null, Activite varchar(191) not null, Membre varchar(191) not null, Adherant varchar(191) not null, Patente varchar(191) not null, R.C_Analytique varchar(191) not null, R.C_Chronologique varchar(191) not null, dateRc date not null, ice varchar(191) not null, Identification_Fiscale varchar(191) not null, dateIDF date not null, Address varchar(191) not null, commune varchar(191) not null, tele varchar(191) not null, Gsm varchar(191) not null, Fax varchar(191) not null, email varchar(191) not null, site varchar(191) not null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
at C:\laragon\www\cista\vendor\laravel\framework\src\Illuminate\Database\Connection.php:759 755▕ // If an exception occurs when attempting to run a query, we'll format the error 756▕ // message to include the bindings with SQL, which will make this exception a 757▕ // lot more helpful to the developer instead of just the database's errors. 758▕ catch (Exception $e) { ➜ 759▕ throw new QueryException( 760▕ $query, $this->prepareBindings($bindings), $e 761▕ ); 762▕ } 763▕ }
1 C:\laragon\www\cista\vendor\laravel\framework\src\Illuminate\Database\Connection.php:538
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 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 '.C_Analytique varchar(191) not null, R.C_Chronologique varchar(191) not nu' at line 1")
2 C:\laragon\www\cista\vendor\laravel\framework\src\Illuminate\Database\Connection.php:538
PDO::prepare("create table ressos (id bigint unsigned not null auto_increment primary key, Personne varchar(191) not null, Nom_F varchar(191) not null, Nom_A varchar(191) not null, Cni varchar(191) not null, Secteur varchar(191) not null, Fjuridique varchar(191) not null, Activite varchar(191) not null, Membre varchar(191) not null, Adherant varchar(191) not null, Patente varchar(191) not null, R.C_Analytique varchar(191) not null, R.C_Chronologique varchar(191) not null, dateRc date not null, ice varchar(191) not null, Identification_Fiscale varchar(191) not null, dateIDF date not null, Address varchar(191) not null, commune varchar(191) not null, tele varchar(191) not null, Gsm varchar(191) not null, Fax varchar(191) not null, email varchar(191) not null, site varchar(191) not null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'")
So if someone can help me please
You can't have a dot in you column name.
You should also use lowercase letters in the names, not a mix.
Please or to participate in this conversation.