DB Transactions and Eloquent Models, don't seem to work...

It looks like you're encountering an issue where the transaction is not rolling back as expected when using Eloquent models. This should work correctly, as Eloquent models are fully compatible with transactions in Laravel. The issue might be related to how the transaction is being handled or an unexpected behavior in your specific environment.

Here's a revised version of your Eloquent model example with some additional debugging and best practices to ensure the transaction rolls back correctly:

use Illuminate\Support\Facades\DB;
use App\Models\User;

DB::transaction(function() {
    try {
        $user = User::where('email', '[email protected]')->firstOrFail();
        $user->name = 'Doughboy'; // Username was John Doe.
        $user->save();

        $user->email = null; // Trigger QueryException.
        $user->save();
    } catch (\Throwable $e) {
        // Log the error message for debugging
        Log::error('Transaction failed: ' . $e->getMessage());
        
        // Rethrow the exception to ensure the transaction is rolled back
        throw $e;
    }
});

Key Points:

1. Exception Handling: Ensure that any exceptions are caught and rethrown within the transaction block. This ensures that the transaction is rolled back properly.
2. Logging: Adding logging can help you debug why the transaction might not be rolling back as expected.
3. Database Configuration: Ensure that your database configuration supports transactions. InnoDB should support transactions, but double-check your database settings.

Additional Debugging Steps:

1. Check Database Logs: Look at your database logs to see if there are any errors or warnings that might indicate why the transaction is not rolling back.
2. Database Connection: Ensure that the database connection being used supports transactions and is correctly configured in your config/database.php file.
3. Laravel Version: Ensure that you are using a compatible version of Laravel and PHP. You mentioned using Laravel 10.48.2 and PHP 8.2.20, which should be fine, but always check for any known issues or updates.

Example with DB Facade for Comparison:

To further ensure that the issue is not with the Eloquent model, you can compare it with the DB facade example you provided:

use Illuminate\Support\Facades\DB;

DB::beginTransaction();
try {
    DB::table('users')
        ->where('email', '=', '[email protected]')
        ->update(['name' => 'Doughboy']);  // Username was John Doe.
    
    DB::table('users')
        ->where('email', '=', '[email protected]')
        ->update(['email' => null]); // Trigger QueryException.

    DB::commit();
} catch (\Throwable $e) {
    Log::error('Transaction failed: ' . $e->getMessage());
    DB::rollBack();
}

If the DB facade example works as expected and the Eloquent model example does not, it might indicate an issue specific to how Eloquent is handling the transaction in your environment.

By following these steps and ensuring proper exception handling, you should be able to get transactions working correctly with Eloquent models.