• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Why field_id is all numeric in xf_user_field_value

abdfahim

Active member
#1
Why my xf_user_field_value table is showing all numeric field_id whereas I have defined alphanumeric value in custom user field? Where can I find the actual Field ID I defined so that I can run a query in the database to get all the values of "team" for all users?

I plan to try this query
Code:
SELECT u.username, ufv.field_value FROM xf_user AS u
                INNER JOIN xf_user_field_value AS ufv ON (u.user_id = ufv.user_id)
                where ufv.field_id = 'team'
I am using XF 1.5.14.

upload_2017-7-19_20-34-56.png

upload_2017-7-19_20-35-19.png
 
Last edited:

Chris D

XenForo developer
Staff member
#2
It's because they are stored in varbinary format, and that's how PhpMyAdmin chooses to display them.

There are options within PhpMyAdmin to display them properly, but it depends on which version of PhpMyAdmin you're using. Try some of the options under the +Options link you can see in the PhpMyAdmin screenshot.