1. 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

Discussion in 'Installation, Upgrade, and Import Support' started by eagle eyes, Oct 20, 2013.

  1. eagle eyes

    eagle eyes Active Member

    I am getting NULL in test imports in Signatures, Occupation, and Interests field for those users who have nothing in them.

    Those who have something it imports fine.

    I am importing from vb 4.2.


    http://img707.imageshack.us/img707/6439/p6fs.jpg
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That is the usertextfield table from vB. vB allows null values for those fields. Is that creating a problem?
     
  3. eagle eyes

    eagle eyes Active Member

    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.
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    eagle eyes likes this.
  5. eagle eyes

    eagle eyes Active Member

    Thanks so much. I will fire that, i know it will work. :)

    Any query for Location and Occupation fields?
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Code:
    UPDATE xf_user_profile
    SET location = ''
    WHERE location = 'NULL';
    
    Code:
    UPDATE xf_user_profile
    SET occupation = ''
    WHERE occupation = 'NULL';
    
     

Share This Page