number of bound variables does not match number of tokens about footprint HOT 3 CLOSED

It seems to add one parameter for every model that has the behaviour, but when saving related models that have the same behaviour, its generating extra parameter for the same field resulting unused and throwing SQLSTATE[HY093]: Invalid parameter number.

IE:
Being $lineas =[
(int) 0 => [
'producto_id' => '12',
'cantidad' => '1',
'importe' => '5',
'pedido_id' => '8',
],
(int) 1 => [
'producto_id' => '13',
'cantidad' => '1',
'importe' => '1',
'pedido_id' => '8',
],
]

When performing -> $lineas_ent = $this->Lineas->newEntities($lineas,['associated'=>['Productos','Pedidos.Clientes']]);
Fails on -> $this->Lineas->saveMany($lineas_ent,['associated'=>['Productos','Pedidos.Clientes']])

'sql' => 'SELECT 1 AS existing FROM pedidos Pedidos WHERE (Pedidos.id = :c0 AND Pedidos.propietario_id = :c1) LIMIT 1'
'params' => [
':c0' => [
'value' => (int) 8, <- Useful pedido_id
'type' => 'integer',
'placeholder' => 'c0',
],
':c1' => [
'value' => (int) 3, <- Correct propietario_id
'type' => 'integer',
'placeholder' => 'c1',
],
':c2' => [
'value' => (int) 8, <- Unuseful pedido_id
'type' => 'integer',
'placeholder' => 'c2',
],
':c3' => [
'value' => (int) 8, <- Another unuseful pedido_id
'type' => 'integer',
'placeholder' => 'c3',
],

from footprint.

NDM said in cakePHP support forum:

Looking at the behavior's code, there's not really any obvious binding going on other than the where() call that adds the finder conditions. However I could imagine that the SQL generation with the existing query's value binder (https://github.com/UseMuffin/Footprint/blob/2.0.2/src/Model/Behavior/FootprintBehavior.php#L145) could be the source of the problem, I can't test it right now, but it looks like it could potentially cause the values from the expression to be bound multiple times.
Try changing it in your local setup to use a clone of the binder, and see if makes any difference, something like $expression->sql(clone $query->getValueBinder()).

from footprint.

And I tried, and the problem went out! @ADmad what do you think?

from footprint.