Importing users. Memory size error


Active member

I copied our live forum into a secondary database, and have been trying to import from that (vb 3.8)
At first I hit the snag of the 'lock' error when importing users.
I got through it with a refresh every time it failed, which was about every 200 users. I made the js timeout changes as suggested in another thread (from 2k to 30k) but this didn't fix it. So after 32000 users (and alot of refreshes), it got to the last 200 or so.....and threw up this :

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1 bytes) in /...{snip}.../library/Zend/Db/Statement/Mysqli.php on line 294
I downloaded the package again, reuploaded fresh files and started the import again. This time it imported all the users successfully, but when it got to the end again, same memory size error.

Any ideas?

Jake Bunce

XenForo moderator
Staff member
That is a PHP limit. Ask your host to increase PHP's memory_limit.

You can also try adding this to your library/config.php file:

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

php_value memory_limit -1