Page view reports: category dropdown does nothing, 500 Server error

(Stefano Costa) #1

If I go to the dashboard lets me optionally select a date interval and a category. However this doesn’t seem to work. The console shows a 500 Server error for the request:

GET  [HTTP/2.0 404 Not Found 50ms]
GET XHR [HTTP/2.0 500 Internal Server Error 81ms]

That’s the first time I look into this feature so I have no idea if it worked before.

Visualised traffic statistics
(Jeff Atwood) #2

Can you repro this @techapj?

(Allen - Watchman Monitoring) #3

I didn’t even know this existed, but can view admin/reports/page_view_total_reqs without error on each of my 4 discourse.

One was just updated to the latest tests-passed branch, and this view is fine.

(Stefano Costa) #4

I can load the initial view without error, too. The issue is triggered by selecting a category from the dropdown and clicking on update view (not sure that’s the exact label).

(Arpit Jalan) #5

Yes, I can repro this issue. Will fix it today.

(Allen - Watchman Monitoring) #6

I see.

I didn’t have any problem selecting a category & clicking Refresh Report, but it seems like Arpit has it going on.

What I do find interesting is that the first day in the report always seems to have a spike, much like the current day has a drop off. (the drop off seems legit, as the day isn’t complete yet)

(Allen - Watchman Monitoring) #7

Ah, I see… the graph doesn’t change… I only thought it was OK because I didn’t see an error visually. Only when I wondered why there was no variance would I have wondered what was up.

Anyway, glad you posted, or I may not have discovered this feature for quite some time.

(Arpit Jalan) #8

The category filter was giving error on page view reports because the category_id column does not exist in application_requests table.

I have removed the category filter from all page view reports.

(Jeff Atwood) #9