1366 Incorrect integer value: 'did_providers' for column 'auditable_id'

[erimeilis]

PHP Version

8.4

Laravel Version

12.10.2

Package Version

14.0.0

Description

Have string id, added everything needed to the model, but get error on save

Steps To Reproduce

public $incrementing = false;
protected $primaryKey = 'id';
protected $keyType = 'string';

protected function casts(): array
{
return [
'id' => 'string',
'auditable_id' => 'string'
];
}

Possible Solutions

No response

[erikn69]

Did you change the field on migration??

laravel-auditing/database/migrations/audits.stub

Line 25 in f92602d

$table->morphs('auditable');

Read #992

you should have something like

$table->string('auditable_type');
$table->string('auditable_id');

[erimeilis]

Did you change the field on migration??

laravel-auditing/database/migrations/audits.stub

Line 25 in f92602d

$table->morphs('auditable');

Read #992
you should have something like

$table->string('auditable_type');
$table->string('auditable_id');

Nope. But i'm already using it for other models, they have int id's

[erikn69]

Nope. But i'm already using it for other models, they have int id's

Check that, it shouldn't work for some models and not for others.

[erimeilis]

Nope. But i'm already using it for other models, they have int id's

Check that, it shouldn't work for some models and not for others.

Well, have to make an experiment. Cos i can't lose what's already audited and can't let other models stop working

[parallels999]

Maybe

laravel-auditing/src/Models/Audit.php

Lines 34 to 38 in f92602d

	protected $casts = [
	'old_values' => 'json',
	'new_values' => 'json',
	// Note: Please do not add 'auditable_id' in here, as it will break non-integer PK models
	];