XF 1.4 more importing woes

[Ian S]

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

 

[Paul B]

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?

 

[Ian S]

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?

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

 

[Paul B]

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.

 

[Ian S]

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

 

[Paul B]

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

 

[Ian S]

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

 

[Paul B]

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.

 

[Ian S]

yep forums, avatars, users, private messages etc all imported fine

 

[Mike]

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.

 

[Ian S]

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.

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

 

[Ian S]

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

 

[Mike]

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.

 

[Ian S]

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?

 

[Ian S]

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

 

[Paul B]

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.

 

[Ian S]

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

 

[Ian S]

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??

 

[0ptima]

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??

I have imported successfully on a lower version of PHP.

 

[Paul B]

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?