antonioribeiro / antonioribeiro/tracker
Erorr in events page
- Dominant language
- PHP
- Stars
- 2.9k
- Forks
- 594
- PR merge metrics
- No merged PRs in 30d
Description
I installed the pakage and worked fine but when trying to open events page in stats it's giving me error
pop up error:
DataTables warning: table id=table_div - Ajax error. For more information about this error, please see http://datatables.net/tn/7
and when trying to see the requests
here's the Request URL
http://localhost/.../public/stats/api/events?draw=1&columns[0][data]=name&columns[0][name]=&columns[0][searchable]=false&columns[0][orderable]=true&columns[0][search][value]=&columns[0][search][regex]=false&columns[1][data]=total&columns[1][name]=&columns[1][searchable]=false&columns[1][orderable]=true&columns[1][search][value]=&columns[1][search][regex]=false&order[0][column]=0&order[0][dir]=asc&start=0&length=10&search[value]=&search[regex]=false&_=1547915504921
and here's the response
message | SQLSTATE[HY000]: General error: 1 ambiguous column name: id (SQL: select "tracker_events"."id", "tracker_events"."name", count(tracker_events_log.id) as total from "tracker_events" inner join "tracker_events_log" on "tracker_events_log"."event_id" = "tracker_events"."id" where "tracker_events_log"."updated_at" >= 2019-01-18 16:31:47 and "tracker_events_log"."updated_at" <= 2019-01-19 16:31:47 group by "tracker_events"."id", "tracker_events"."name" order by "total" desc, "id" asc limit 10 offset 0)
exception | Illuminate\Database\QueryException
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.