Entering a value in profile field across ALL users?
 

Hello,

I've just recently setup a new user profile field on my forum called 'Points'. This field is not editable by any registered user and isn't required on registration, but has a default value on registration.

The problem is, for all current users there is no data in the field and so it looks like this;

https://vborg.vbsupport.ru/external/2013/07/3.png

It's fine however when data is in the field as shown below;

https://vborg.vbsupport.ru/external/2013/07/4.png

So basically I'm just trying to find a way of entering the value of '0' across ALL registered users so that this field looks fine for everyone on the forum.

Thanks for any help!

Run this query

UPDATE userfield
SET fieldX = 0

where X is that field number.

Thanks for the help mokujin.

Where do I need to run that query? I'm assuming its on the database, so I've tried it within phpMyAdmin but it says I need to 'choose at least one column to display'.

I'm not exactly sure what I need to put in here;

https://vborg.vbsupport.ru/external/2013/07/2.png

in Phpmyadmin go to the database where your vbulletin is installed, then click to table "userfield"

then run that sql make sure you have entered your table prefix before table userfield if you have one.

Thanks a lot mokujin. That's worked brilliantly.

Great help, cheers!

Update on this;

I just tried running this sql again and now I get an error message for some reason.

https://vborg.vbsupport.ru/external/2013/08/42.png
https://vborg.vbsupport.ru/external/2013/08/43.png

Why would it work fine before and not now? Nothing has been changed.

Any ideas? Thanks in advance for any help.

--------------- Added [DATE]1375561645[/DATE] at [TIME]1375561645[/TIME] ---------------

Managed to fix it for myself. It was because the fields already had the '0' data in them from the query I ran before. (silly me)

Therefore it needed a WHERE in the sql.

e.g.

UPDATE userfield SET fieldX = '100' WHERE fieldX = '0'

[hope this helps anyone else who's as silly as me]