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

vb 4 import: 504 Gateway Time-out on "profile comments" and "threads/posts"

Discussion in 'Installation, Upgrade, and Import Support' started by Marcus, Sep 18, 2011.

  1. Marcus

    Marcus Well-Known Member

    I use the third party vbulletin 4 importer. I have successfully imported the usergroups, forums, users, avatars, private messages (1/4 million!) and now whenever I import either
    • "profile comments" or
    • "threads/posts" which are the only options for me now,
    I get a "504 Gateway Time-out". I am not redirected to any page - as I think, as my board is rather large. Do you have any idea how to resolve this issue?
  2. Floris

    Floris Guest

    you have a table called xf_error_log, and if so, does it have the error logged?
  3. Marcus

    Marcus Well-Known Member

    Yes, this is my log:

    I had dozens of problems during today importing all the stuff.

    It seems this is about the forum import, I had there problems, too.
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Marcus likes this.
  5. Marcus

    Marcus Well-Known Member

    Thanks! I use a direct normal internet connection, my server is nginx not apache. Maybe it is because of this? I can remember problems with attachments and having the same error.
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    The connection to the server is failing for some reason. Some one isn't responding. If it's not your internet connection then it must be your web server.
  7. Marcus

    Marcus Well-Known Member

    I have the same error message when using phpmyadmin and a query takes too long ( over 40 seconds or so).

    It is most likely because xenforo takes too long to process something.
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    It's possible. You can try adjusting the batch sizes on the import modules:


    Marcus likes this.
  9. Marcus

    Marcus Well-Known Member

    Thanks Jake! I have found the problem. I try to import the old vb 4 ids without changing these IDs.


    Therefore I have hugely changed my database to insert fake IDs where there were no IDs in the old vb 4 install. In this process I removed the userid primary index. This made the queries take ages to finish. With the new primary keys (where I got another "504 Gateway Time-out" messages from phpmyadmin as adding these keys take so long) everything runs fine :)

Share This Page