Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Migration not inserting data to table?

The below migration is running successfully with no errors but it’s not inserting any data do table. Why it can be? can some one tell me what is wrong here?

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddValuesTOBusiness extends Migration
{
   
    public function up()
    {
       //  Schema::table('business', function (Blueprint $table) {
            DB::table('business')->insertOrIgnore([[
                'id' => 1,
                'name' => 'fg',
                'description' => 'best IT & software solutions',
                'clientAddress' => 'fdgd 682028',
                'status' => 'active',
                'email' => 'fg@y.com',
                'phone' => 3455645656,
                'appInfo' => 'learningApp',
                'defaultClient' => true,
                'eustardApp' => true,
                'sellerCategory' => 'internal',
                'created_at' => now()]
            ]);
       // }
    }

    public function down()
    {
      // Schema::table('business', function (Blueprint $table) {
        DB::table('business')->truncate();
      //}
    }
}

>Solution :

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

You are not getting any error because you are using "insertOrIgnore", this method does not throw any error but simply ignores and moves forward.
Your error is probably some data validation, for example, the id that should be set automatically by the database.

Try using the "insert" method instead and you’ll probably get the error you are looking for

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading