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

XF 1.2 NULL issue with signature and other fields

#3
That is the usertextfield table from vB. vB allows null values for those fields. Is that creating a problem?
Yes, when imported it shows NULL written in all signatures. Is there a query i can fire to replace those NULL values to empty/nothing there. And then i will try again and see if that fixed the problem.

Please let me know how to empty Occupation and Location areas as well IF there is NULL.
 

Jake Bunce

XenForo moderator
Staff member
#6
Code:
UPDATE xf_user_profile
SET location = ''
WHERE location = 'NULL';
Code:
UPDATE xf_user_profile
SET occupation = ''
WHERE occupation = 'NULL';