This should probably be a comment in a thread but i couldn’t find the correct one. The cool scripts one seems to be locked now. The script is designed to pull user_id, username, name, email, custom_field1, custom_field2, trust_level, visits and a few more stats. Here’s the code SELECT pr.user…

I think it’s been adapted from this post: [이미지] User participation Data & reporting User participation Shows the following columns over a specified time range (in days): user_id, username, name, email, visits, topics…

The problem is that none of those tables exist. FROM pr means to select rows from the table pr but there is no table pr in Discourse. Maybe you meant posts or topics ? Ditto for every other join, none of those tables exist.

Thank you @Falco and @JammyDodger . Looks like i skipped a big chunk of this. I’ll have another go :slight_smile:

스크립트를 만들었는데 오류 메시지가 나옵니다. 피드백이나 조언을 구합니다

커뮤니티 구축 데이터 및 보고

JammyDodger 1월 15, 2023, 6:55오후 3

이 게시글에서 가져온 것 같습니다:

하지만 @Drew-ART님, 일부만 골라 쓰는 것이 아니라 누락된 부분을 보완하도록 수정한 전체 쿼리를 사용해야 합니다.

글		댓글	조회수
Attempting to create Monthly Leaderboard query - head exploding Data & reporting sql-query	18	2020	10월 8, 2018
Add "named group" as a scope for the "User Participation Statistics" script in data explorer Marketplace	0	728	4월 15, 2019
Helpful Data Explorer messages Praise	0	874	10월 31, 2022
Relation "selected" does not exist with external Postgres Self-hosting	5	1157	7월 24, 2019
How to troubleshoot database errors in an outdated plugin? Development	5	491	2월 29, 2024

스크립트를 만들었는데 오류 메시지가 나옵니다. 피드백이나 조언을 구합니다

Related topics