antonioribeiro / antonioribeiro/tracker

Erorr in events page

Open
#417 12 comments 0 reactions 1 assignee Claimed by @napestershine View on GitHub
bug Fixed
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.