Hi, I am configuring permession of a Role to View and Edit only, then when a user login it will cause error
Error in results, duplicate field name createdById
. (see option checkDuplicate
) sql: SELECT complete_percent
, created_at
AS createdAt
, created_by_id
AS createdById
, end_date
, id
, start_date
, status
, status_sort
, task_description
, task_detail
, task_name
, updated_at
AS updatedAt
, updated_by_id
AS updatedById
, created_by_id
AS createdById
FROM tasks
AS tasks
ORDER BY ISNULL(tasks
.id
), tasks
.id
ASC LIMIT 0, 20; - parameters:
I think this error because SQL query includes **the same alias createdById
twice:
SELECT
complete_percent
,
created_at
AS createdAt
,
created_by_id
AS createdById
, – first time
end_date
,
id
,
start_date
,
status
,
status_sort
,
task_description
,
task_detail
,
task_name
,
updated_at
AS updatedAt
,
updated_by_id
AS updatedById
,
created_by_id
AS createdById
– second time (duplicate alias)
FROM tasks
AS tasks
…