Using this query: SELECT id, username, email FROM users The following is returned [pixelized] All those NULL results are people who have signed up using Google OAuth2 The emails are in the system correctly, I can see them in their profiles. What am I doing wrong? :slight_smile:

We no longer use the email column on the users table. You need to join the users table with the user_emails table with the primary = true condition :wink:

SELECT u.id, u.username, u.email, ue.email FROM users u INNER JOIN user_emails ue ON u.id = ue.id WHERE ue.primary = true That worked :slight_smile: I was thrown off by the one email that was there; but I guess that’s a remnant of running cd /var/discourse ./launcher enter app rake admin:create w…

البريد الإلكتروني OAuth مفقود في مستكشف البيانات

الدعم

zogstrip 10 أغسطس 2017، 9:30ص 4

The column is in readonly mode. We’ll completely remove it when we’re 100% it’s safe to do so.

الموضوع		الردود	مرات العرض
Data explorer doesn't show email address with a where clause Bug	4	859	20 سبتمبر 2017
Pulling Emails via API Support rest-api	6	223	2 سبتمبر 2025
New Reporting: Email vs. Social Signups Data & reporting	1	363	10 مارس 2021
Query on the database to find email Development	2	574	24 يناير 2019
Is there a way to get all emails of users with the API? Development rest-api	5	2211	15 أكتوبر 2019

البريد الإلكتروني OAuth مفقود في مستكشف البيانات

الموضوعات ذات الصلة