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

Unable to complete import

steven s

Well-known member
#1
Installed a clean copy of XF.
debug OFF.

Closed my live forum.
Repaired and Optimized all vB3 tables through the vB Admin CP.

Import User Groups - Imported 18 items. (2.79 seconds)
Import Users - Imported 10,014 items. (6 minutes 51.75 seconds)
Import Customer Avatars - Imported 825 items. (25.50 seconds)

Import Private Messages
Waits then I get a page that says,
Error Page not found.

Import Visitor Messages, OK
Import Forums
Error Page not found.

When I view my node list I can see my forums listed, may not be all of them.

Previously I clicked on Import Messages and started to import then stopped.
Clicked Import Messages again and it seemed to begin where it left off.

Then there was the time I tried to delete the default main forum
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 3145728 bytes) in /home/x/public_html/library/Zend/Db/Profiler.php on line 282

I tried to copy my live database to a backup version to work with using bigdump.
[08-Oct-2010 20:20:30] PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 8940996 bytes) in /home/x/public_html/bigdump.php on line 634

Bottom line, the only consistent problem is the failure to completely import PMs and Forums.
I have intermittent other failure messages.

I wonder if my forum is just too big for what my php settings will allow.
Threads: 26,030, Posts: 275,933, Members: 10,014
 
#2
Having a similar problem:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1024 bytes) in /../xf/library/Zend/Db/Statement/Mysqli.php on line 304

I cannot find any info on the server logs.
Any better way to import the forum POSTS
 

Jake Bunce

XenForo moderator
Staff member
#3
Having a similar problem:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1024 bytes) in /../xf/library/Zend/Db/Statement/Mysqli.php on line 304

I cannot find any info on the server logs.
Any better way to import the forum POSTS
That is a PHP memory_limit error. Ask your host to increase or disable PHP's memory_limit.

You can also try changing the memory_limit yourself. These methods don't always work, but try adding this to your library/config.php file:

Code:
 ini_set('memory_limit', -1);
Or add this to a .htaccess file on your server (only works on Apache servers):

Code:
 php_value memory_limit -1
 

yoghurtfarmer

Well-known member
#4
I'm just wondering if you tried doing the import locally via XAMPP and then just importing the local database into your server? My forum is tiny and even I ran into issues importing things, couldn't imagine doing it with a medium sized board. (I'm on shared hosting though)