andersao / andersao/l5-repository
sorting related table error duplicate join
- Lenguaje dominante
- PHP
- Estrellas
- 4.2k
- Forks
- 880
- Métricas de merge de PR
- Sin PR fusionados en 30 d
Descripción
in request `orderBy=sias_peserta_didik:peserta_didik_id|sias_peserta_didik.nisn&sortedBy=asc`
i get error:
`code: "42000"
exception: "Illuminate\Database\QueryException"
file: "D:\WWW\sias\vendor\laravel\framework\src\Illuminate\Database\Connection.php"
line: 664
message: "SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'sias_peserta_didik' (SQL: select count(*) as aggregate from `sias_peserta_didik_rombel` left join `sias_peserta_didik` on `sias_peserta_didik_rombel`.`peserta_didik_id` = `sias_peserta_didik`.`id` left join `sias_peserta_didik` on `sias_peserta_didik_rombel`.`peserta_didik_id` = `sias_peserta_didik`.`id`)"
status: "error"
status_code: 500`
**the duplicate join:**
`select count(*) as aggregate from `sias_peserta_didik_rombel`
left join `sias_peserta_didik` on `sias_peserta_didik_rombel`.`peserta_didik_id` = `sias_peserta_didik`.`id` left join `sias_peserta_didik` on `sias_peserta_didik_rombel`.`peserta_didik_id` = `sias_peserta_didik`.`id`
Guía de contribución
Evaluación
Este issue todavía no se ha evaluado.