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

XF 1.1 Server Error Undefined index: field5_title

Discussion in 'Installation, Upgrade, and Import Support' started by snoopy5, Oct 7, 2012.

  1. snoopy5

    snoopy5 Well-Known Member


    I just try to test the import of a vb forum into XF. The plan is to import around 9 different vb 3.8x forums into 1 XF forum.

    Now I just tried to import the first forum and get this error as soon as I hit the import custom user fields:

    What does this mean and how can I fix it?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  3. snoopy5

    snoopy5 Well-Known Member


    I do not want to delete it. I tried now several times to change the title within the ACP of vb and saved it. After that, I tried to continue the import. But the error stays the same.

    Then I went into phpmyadmin and looked in the table profilefield. But there is no field for the title. How that? See screenshot:


    In case this is important: this is version vb 3.8.0
  4. Insy

    Insy Well-Known Member

    A dirty fix that should work:

    Open library/XenForo/Importer/vBulletin.php and go on line 532 ({) and adds below:
    isset($phrases["field$profileField[profilefieldid]_title"]) || $phrases["field$profileField[profilefieldid]_title"] = '';
    $phrases["field$profileField[profilefieldid]_desc"]) || $phrases["field$profileField[profilefieldid]_desc"] = '';
    This will define an empty title and description if they do not exist.
    Jake Bunce likes this.
  5. snoopy5

    snoopy5 Well-Known Member

    What I do not understand is that the title does exist in my ACP and if I go to the userprofile, but it does not exist a field for the title in the vb database. So where is vb storing this information of the title of profilefield #5?

    Or shall I delete the XF database and make first a totally fresh import again after I changed the title?
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    In the phrase table.
  7. snoopy5

    snoopy5 Well-Known Member


    This is what I see with phpmyadmin in the phrase table for profilefield #5. Seems to be correct. See screenshot. So why does the importer does not recognize it?

  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    It looks correct. I would have to debug it. snoopy's fix should work.
  9. Adam Howard

    Adam Howard Well-Known Member


    Do the following on the full database (not just that table)

    Repeat repair until you have ZERO errors from within phymyadmin

    Next optimize, but do not optimize until the above is done.

    Proceed from there.

    Most common fix for import is that.
  10. snoopy5

    snoopy5 Well-Known Member

    Do you mean Insy's fix?

  11. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Oh yeah. You're snoopy. And I'm sleepy. :sleep:
  12. snoopy5

    snoopy5 Well-Known Member

    If you are so fast in responding, when you are sleepy, how fast are you then if you are awake? Is there not a speed limit in the posting restrictions? I can not read as fast as you all answer here... (y)
  13. snoopy5

    snoopy5 Well-Known Member

    o.k., I applied the code change suggested by Isny and the error is gone.

            foreach ($profileFields AS $profileField)
    // ab hier 2 Zeilen code einfuegen, um den Error mit title profilefield nummer 5 zu korrigieren beim import
    isset($phrases["field$profileField[profilefieldid]_title"]) || $phrases["field$profileField[profilefieldid]_title"] = '';
    isset($phrases["field$profileField[profilefieldid]_desc"]) || $phrases["field$profileField[profilefieldid]_desc"] = '';
    // ende codeaenderung profilefield5
                $title = $this->_convertToUtf8($phrases["field$profileField[profilefieldid]_title"]);
                $description = $this->_convertToUtf8($phrases["field$profileField[profilefieldid]_desc"]);
    I got in the importer screen the message
    Sound not logical, since there are profile fields in vb, but will check this later once I was gone through the whole process of testimporting and check than afterwards.

    Another error came now when I try to import in the next stepthe users, but I will open an extra thread for this, so that it is easier for others to find if they have similar problems...
  14. Adam Howard

    Adam Howard Well-Known Member

  15. snoopy5

    snoopy5 Well-Known Member

  16. Adam Howard

    Adam Howard Well-Known Member

    I misunderstood ....

    I thought your copy of vBulletin was still running on a MySQL 4 server. If it was... You'd need to import it or upgrade it into a MySQL 5 server.

    That would not be strange, that would be the accepted norm and standard. MySQL 4 was discontinued over 8 years ago and is very insecure (and unstable) compared to today's standards.
  17. snoopy5

    snoopy5 Well-Known Member


    no you were right then. all my old vb forums are running still with mysql4 :oops:

    If I chnage to Mysql5, what do I have to pay attention to?
  18. Insy

    Insy Well-Known Member

    Adam Howard likes this.
  19. Adam Howard

    Adam Howard Well-Known Member

    BACK UP.
    Back up.
    Back up again.....

    You sound like you're trying to do this remotely... I would suggest trying to do this on the same server (or localhost).

    I believe on import (if I recall correctly) it will convert it to mysql5 structure. It's been years since I recall anyone using mysql4 (almost 10 years).

    You really do not need the forum working per say, just the database and your attachments for the import.
    Insy likes this.
  20. snoopy5

    snoopy5 Well-Known Member

    mmmhhhh, that sems not to be as easy as I hoped it would be....

    1. All installations are on the same server
    2. I created an empty fresh new mysql5 db
    3. I backed up my vb mysql4 db
    4. I imported the vb-backup into the empty mysql5 db
    5. I changed in ./includes/config.php the settings for the db name, username and host to the new mysql5 settings
    6. I went to my vb forum to check whether everything is working, but get errors:

    I googled and in the vb support forum, they advice with this error to

    7. I did that and the errors went away. BUT...

    If login now into my ACP of vb, not all informations & buttons are visible. Strange stars are shown on the left etc. Weired....

    I will try again...

    Is there a way to disable with one click all plugins & add-ons in vb? I want to make sure, that they do not interfere with this.

Share This Page