Laravel: SQLSTATE[23000] error with dataTables

Question

Why do i get this error? I have the right relationships and in tinker, it works really well, do u guys have any idea about this?

Tinker:

Controller:

$emp = Empresa::find($request->empresa_id);
$mov = $emp->movimientos()->where('linea_id', intval($request->id_caso))->with('producto_nombre', 'costo_promedio');
return DataTables::of($mov)->make(true);

Error:

Table structure:

Thx for the help.

since there are multiple table in your query you must specify the table name in your condition movimiento.linea_id — Beginner
– Beginner, Commented Sep 26, 2018 at 2:57

Beginner · Accepted Answer · 2018-09-26 03:04:36Z

1

ambiguous error occurs when there are multiple columns with the same name and you dont specified its table

since there are multiple table and have a column with the same name in your query you must specify the table name in your condition

$emp = Empresa::find($request->empresa_id);
$mov = $emp->movimientos()->where('movimiento.linea_id', intval($request->id_caso))->with('producto_nombre', 'costo_promedio');
return DataTables::of($mov)->make(true);

edited Sep 26, 2018 at 3:04

answered Sep 26, 2018 at 3:02

Beginner

4,1183 gold badges19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Christian Over a year ago

It's working now, how a simple thing can make u waste so much time... thank you so much

Collectives™ on Stack Overflow

Laravel: SQLSTATE[23000] error with dataTables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related