[Bug]: while using OnEachRow it not rollback entries from second table if database or some another error occur. or you can say it delete entries from parent table but not child table. i am trying to do relation entries

[krishantalwar]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1

What version of Laravel are you using?

8.75

What version of PHP are you using?

8.1.6

Describe your issue

if their error comes it rollback the entries from the first table. but it does not roll back the entries from the second table.

Can anyone guide how it is possible?

what my case is.

if their error comes it rollback the entries from the agent table. but it does not roll back the entries from the payment table.

How can the issue be reproduced?

To create this error I hardcoded the value for the third row and set the status value to null. but status only takes an integer value why it creates the error.

it gives an error Incorrect integer value: '' for column 'status'

but it rollbacks entries from the agent table but not from the payment table

class noteImport implements OnEachRow {

    public function onRow(Row $row){
        $row = $row->toArray();
        
            $Option = [
            "firstpay" => 1,
            "amount" => 1,
            "payment_type" => 1,
            "info" => "1",
            "enter_date" => date('y/m/d'),
            "recieve_date" => date('y/m/d'),
            "status" => $row['srno'] != 3 ? 1 : "",     
            ];

            $agent = Agent::create([
            "agent_code" => "1",
            "name" => "1",
            "address" => "1",
            "phone" => 454,
            "password" => "asd",
            "upload" => "1",
            "status" => 1,
            ]);

        $agent->payment()->create($Option);
    }
}

What should be the expected behaviour?

The expected behavior is it should delete an entry from the second (payment) table

[stale]

This bug report has been automatically closed because it has not had recent activity. If this is still an active bug, please comment to reopen. Thank you for your contributions.