CSV export is not working for me

(Scott Davidson) #1

I have a simple query result from Data Explorer.

select user_id, 
    count(1) as visits,
    sum(posts_read) as posts_read
from user_visits
where posts_read > 0
and visited_at > CURRENT_TIMESTAMP - INTERVAL '30 days'
group by user_id
order by visits desc, posts_read desc

I try and use CSV export, nothing seems to happen. In the Logs, I see these errors:

Deprecation Notice: exec_sql should not be used anymore, please use DB.exec or DB.query instead! At: block in run_query /var/www/discourse/plugins/discourse-data-explorer/plugin.rb:94

Not sure why that should stop it.

I have seen reports the CSV export was a problem. but it looked like those were fixed?

(Joffrey Jaffeux) #2

Hi @scottd,

indeed that deprecation warning is probably not the cause here. Let me investigate and try to reproduce, I will keep you updated.

(Joffrey Jaffeux) #3

I can’t reproduce on your forum. Could you tell me your browser/OS please? I tried with macOS/Chrome. Also do you see any error in the javascript console please (let me know if you need help to get this) ?

Meanwhile I exported the CSV if it’s urgent to you:
discourse-support-test@discourse-mcneel-com-2018-07-11.dcqresult.csv (28,9 Ko)

(Scott Davidson) #4

It was a darn add-blocker. Sorry, my bad. It is working now.

I should have seen that.

(Joffrey Jaffeux) #5

No worries, glad it’s working!

(Joffrey Jaffeux) #6