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

XF 1.4 more importing woes

Discussion in 'Installation, Upgrade, and Import Support' started by Ian S, Sep 26, 2015.

  1. Ian S

    Ian S Active Member

    hi all im back again after a massive break, anywayz long story short is i had a complete clean backup saved in 1.4.4 ready for a import from vb3.7, this has always worked in the past, this time it done everything correctly but didnt import the threads and posts, everything imported apart from these

    any ideas greatly received thx
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    What happened with the "Import Threads and Posts" step?

    Was anything imported?
    Any errors?

    Presumably there is thread and post content in the VB database?
     
  3. Ian S

    Ian S Active Member

    it seemed to import by percentage, but once i rebuilt the caches no threads or posts and no errors either.

    i used your method as i did before a clean backup ready for the import, it worked a 100 times in the past now it wont import threads and posts

    it imports conversations, avatars, and everything else except the above very annoying lol

    yes there is loads of vb threads and posts as ive imported to xf loads before from same db
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Are you sure there are no threads and posts?
    Or is it just a permissions issue?

    Is there anything in the xf_post and xf_thread tables?
    You can use phpMyAdmin to check.
     
  5. Ian S

    Ian S Active Member

    ive just checked in phpMyAdmin xf_post = 0 and xf_thread = 0 so they have not imported at all
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    That suggests there may be no content in the source database.
     
  7. Ian S

    Ian S Active Member

    theres loads of source threads/posts in the vb database so not sure why everything is importing except threads and posts:cry::cry::cry::cry::cry:
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    Did all of the users and forums import OK?

    If they did and there is thread and post content in the source database and there were no errors, then offhand I can't think why the content wouldn't import.
     
  9. Ian S

    Ian S Active Member

    yep forums, avatars, users, private messages etc all imported fine
     
  10. Mike

    Mike XenForo Developer Staff Member

    As a baseline test, it may be worth doing a totally fresh install and then trying the import again. I don't believe I've ever heard of that step not importing anything.
     
  11. Ian S

    Ian S Active Member

    ill do this today but the funny thing is everytime ive used the clean db in the past its worked, ive tried the this 5 times now on the clean db and it aint working
     
  12. Ian S

    Ian S Active Member

    ok ive just copied the db over again and noticed this server error would this be why i cant import


    ErrorException: fopen(/var/www/vhosts/.org/httpdocs/test/internal_data/sitemaps/sitemap-1443351260-1.xml) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied - library/XenForo/Deferred/Sitemap.php:210
    Generated By: Unknown Account, 4 minutes ago
    Stack Trace
    #0 [internal function]: XenForo_Application::handlePhpError('/var/www/vhosts...', 'a')
    #1 /var/www/vhosts/.org/httpdocs/test/library/XenForo/Deferred/Sitemap.php(210): fopen()
    #2 /var/www/vhosts/.org/httpdocs/test/library/XenForo/Deferred/Sitemap.php(230): XenForo_Deferred_Sitemap->_openFile('?<url><loc>http...')
    #3 /var/www/vhosts/.org/httpdocs/test/library/XenForo/Deferred/Sitemap.php(202): XenForo_Deferred_Sitemap->_writeSitemapString(Array)
    #4 /var/www/vhosts/.org/httpdocs/test/library/XenForo/Deferred/Sitemap.php(165): XenForo_Deferred_Sitemap->_writeResult(Object(XenForo_SitemapHandler_Core), 0, 7.9777600765228)
    #5 /var/www/vhosts/.org/httpdocs/test/library/XenForo/Deferred/Sitemap.php(90): XenForo_Deferred_Sitemap->_buildSitemap(Array, Array, 7.9777600765228, '')
    #6 /var/www/vhosts/.org/httpdocs/test/library/XenForo/Model/Deferred.php(294): XenForo_Deferred_Sitemap->execute(Array, 7.9777600765228, '', false)
    #7 /var/www/vhosts/.org/httpdocs/test/library/XenForo/Model/Deferred.php(428): XenForo_Model_Deferred->runDeferred(Array, NULL, '', false)
    #8 /var/www/vhosts/.org/httpdocs/test/library/XenForo/Model/Deferred.php(373): XenForo_Model_Deferred->_runInternal(false)
    #9 /var/www/vhosts/.org/httpdocs/test/deferred.php(23): XenForo_Model_Deferred->run()
    #10 {main}
    Request State
    array(3) {
    ["url"] => string(38) "http://.org/test/deferred.php"
    ["_GET"] => array(0) {
    }
    ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(6) "/test/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
    }
    }
    Delete...Close
     
  13. Mike

    Mike XenForo Developer Staff Member

    That error is unrelated. It's caused by permissions not being set correctly on the internal_data directory (or sub-directories). You should recursively chmod them to 0777.
     
  14. Ian S

    Ian S Active Member

    ok tried a total fresh install of xf1.5 this works now the trouble ive got is the clean db i had from before had all the forums and permissions and loads of other things already setup but no users, conversations, threads or posts so had major work to get it to the stage so i could finish a import at any time im going to have another try and see what happens but im not hopefully the db always worked before, the one thing ive done to this master is change the password as i forgot it would this of made the db do this?? ive got a backup of the master before this is there a way of removing the password from the sql and using a converter to see the password so i can try on the clean db backup from before?
     
  15. Ian S

    Ian S Active Member

    ok just tried again still not working i get this next to the importer

    threads/posts Imported 0 items. (3 minutes 37.47 seconds)

    this is a major nightmare
     
  16. Brogan

    Brogan XenForo Moderator Staff Member

    I can't think of any reason why threads and posts would import into one XF installation but not into another, assuming you are using the same source database for both.
     
  17. Ian S

    Ian S Active Member

    i used the same vb database, and clean xf database about 15 times before with no problems in febuary, ive left it all this time come back now used the same method and files and its not working

    this is crazy, why work then and not now, a fresh full import works just not my clean database, i spent ages getting the database to the point its at now ready for a full import

    nothings changed it just wont import posts and threads, everything else imports
     
  18. Ian S

    Ian S Active Member

    ok just relised the server is php 5.2.17

    the hosts changed for me to 5.4 but because the dev site got accidentally deleted its now 5.2.17 for the xf site would this be why there not importing??
     
  19. 0ptima

    0ptima Well-Known Member

    I have imported successfully on a lower version of PHP.
     
  20. Brogan

    Brogan XenForo Moderator Staff Member

    XF works with PHP 5.2.11+

    Are you saying that the clean XF installation which works is on a different server to the backup installation which doesn't work?

    Which server is the VB installation on?
     

Share This Page