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

XF 1.4 Phpbb import questions and error

Discussion in 'Installation, Upgrade, and Import Support' started by herocus, Nov 23, 2014.

  1. herocus

    herocus Member

    Just bought xenforo today. Installed it with no problem.

    I tried to import the existing phpbb forum from my other site: http://cgpixol.com/

    From xenforo tool > Import External Data
    I put the info for username, password, database and the rest I leave it as default.

    I got an error: The source database connection details are not correct: Access denied for user 'cgpixolc'@'localhost' (using password: YES)

    any idea or help to get this work

    thanks in advance
    Last edited: Nov 23, 2014
  2. Mike

    Mike XenForo Developer Staff Member

    Is the site you're importing from on the same server? If not, it's unlikely that you will be able to access the MySQL server. You'll need to import the data to the same server as where you're importing from.
  3. herocus

    herocus Member

    Hi Mike
    You are right.
    It is not from the same server.

    So, should I actually import mysql database to the new server first?
    How do I go about ti?

    Thanks for your help
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Dump the database and restore it.
    Also copy the avatar and attachment directories.
  5. herocus

    herocus Member

    Hi Brogan
    Thanks for the prompt reply.
    I will try it first then.

  6. herocus

    herocus Member

    Hi Brogan
    Just a quick questions, where should I copy the avatar and attachment directories?
    which directory?

    thanks for your help
  7. Brogan

    Brogan XenForo Moderator Staff Member

    To the server XenForo is installed on.
    Just put them in the web root.
  8. herocus

    herocus Member

    Ok, I have up to this point. Manage to get the hosting provider upload the database from old server to the new one.
    I went to Tools -> Import External Data
    Fill the necessary username, database name and password and the prefix, and the rest leave as default.

    I have a screenshot looks like as per attachment.
    It looks like I cannot import most of them except the first two.

    Perhaps I did something wrong? any idea what's going on?
    Thanks for your help

    Attached Files:

  9. Mike

    Mike XenForo Developer Staff Member

    You need to import those before you can import anything else.
  10. herocus

    herocus Member

    Hi Mike
    thanks for the heads up.
    Ok , I did import it. there are two messages appear.
    1) about making sure for the permission for user, admin and moderator
    2) Rebuild index

    For point 1, I dont see any members/users in the forum
    for point 2, in Tools I only find Rebuild Cache -- is this the same thing for Rebuild index?

    Or should I re-import again?

  11. Brogan

    Brogan XenForo Moderator Staff Member

    Do any members exist in the ACP member list - admin.php?users/list ?

    Yes, rebuild the search index.
  12. herocus

    herocus Member

    No member list in ACP, only myself as admin
  13. Brogan

    Brogan XenForo Moderator Staff Member

    Something has gone wrong then, assuming you actually clicked on the [Import Users] button?

    It may have something do with the source data.
    Did anything get imported?
  14. herocus

    herocus Member

    aah at last I manage to get this work... I went to re import the data and import one by one.
    Thanks for your help to this far Brogan and Mike.
  15. herocus

    herocus Member

    quick question, in the old sever with my phpbb, the attachment picture shows up in the forum.

    When I check in xenforo forum, it only shows the links of but not the embeded pictures, for example this thread:

    it used to be shown as a pictures in the post, now it only shows
    Artstation : http://www.artstation.com/artist/paprika

    Is there a way to actually perhaps rebuild all the links posted or the attchment so it shows up as a picture or video depend on the link posted?

  16. Brogan

    Brogan XenForo Moderator Staff Member

    You have attachments blocked to guests so I can't check.
    What is the resolution of that image?

    Files uploaded to posts can be embedded using the attach tags.
  17. herocus

    herocus Member

    Hi Brogan
    sorry... i try to find the option to unblock the attachemnt to guests, but cannot find it.
    Where can I change this option?

    Resolution of image is quite small, it shows up in the old forum.

    Correction, what I mean is the attachment does not show up on the forum .
    But, I just tried to click the attachment, It seems it cannot find the file... it gives a broken picture.

    mmm, looks like all the attachment has broken pictures... it cannot find the attachment pictures.
    Perhaps it points to different directory?
  18. Brogan

    Brogan XenForo Moderator Staff Member

    Do you have jpeg support on the server?

    Navigate to admin.php?tools/phpinfo and look for this block (or similar):

  19. herocus

    herocus Member

    Hi Brogan
    I believe it has jpg enable since I actually try to attach JPG picture and it shows up in the forum post.

    the problem is now, it seems every attachment does not find the attachment pictures (this is from the imported database from old server)

    (Permission for guests to view attachments is set in the unregistered user group.)
  20. Brogan

    Brogan XenForo Moderator Staff Member

    Do the images actually appear in the file system if you check using an FTP application?
    They will be in the internal_data directory and the thumbnails will be in the data directory.

    If not then they haven't been imported.
    If they have and you can't view them from the forum then it could be a server config issue.

Share This Page