samedi 7 août 2021

Laravel MySQL SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry not solved

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry laravel, I have tried all solution on iternet. I am getting this error when adding new record, strang things is I am not getting this all time but error coming on every 2nd or 3rd record.

This I start noticing after import data from Backup

  • I have truncate table and create from migration, but after importing old records still same issue.
  • Have tried resetting auto increment field.

in controller I have tried 2 ways given below

'''

$data = array(
        'hospital_id' => $hospitalid,
        'doctor_name' => 'newdoc',
        'doctor_id' => $this->myGUID(), 
        'created_at' => NOW(),
        'updated_at' => NOW(),
        'status' => 0,
        'slug' => $docslug       
      );
      $doctor_id = Doctor::create($data)->id;

       $doct = new Doctor();
        $doct->hospital_id = $hospitalid;
        $doct->doctor_name = 'newdoc';
        $doct->doctor_id = $this->myGUID();
        $doct->slug =  $docslug;
        $doct->created_at = NOW();
        $doct->updated_at = NOW();
        $doct->status = 0;
        
        $doct->save();

'''



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire