(2011-03-18, 07:46 PM)bigoliver Wrote: ...set all users automatically to Undisclosed unless they have selected otherwise.
Run this in phpMyAdmin, replacing X with the actual custom field ID:
UPDATE `mybb_userfields` SET `fidX` = 'Undisclosed' WHERE `fidX` = '';
[/quote]Hi, thanks for taking the time to reply.
I believe I did this correctly, I went to phpmyadmin, clicked SQL pasted your code (replacing the fid"x" to the correct fid number) but after clicking "Go" it came back with...
0 row(s) affected. ( Query took 0.0005 sec )
I tried changing your code to this...
UPDATE
mybb_userfields
SET fidX
= 'Undisclosed' WHERE fidX
= 'N/A';But that didn't work either.
Any ideas?
Cheers,
Oliver
Hi again,
I did a little more searching and found this code...
UPDATE mybb_userfields SET fidx = 'Undisclosed' WHERE fidx IS NULL
changing the x to my fid number.
It worked for me
Hope this helps others