XF 1.2 NULL issue with signature and other fields

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
UPDATE xf_user_profile
SET location = ''
WHERE location = 'NULL';
UPDATE xf_user_profile
SET occupation = ''
WHERE occupation = 'NULL';