Ogmuk
Mon 16th Jul '07, 5:51pm
When using using ImpEx once I'm at the stage "import user" when using the 2000 default imports per cycle it will freeze up, basically. It shows "Using includes/config.php for target config." and will not do anything afterwards, no matter how long I wait. I've restored the MySQL database at least 50 times through putty (to find out what the highest number is I could use) and it's definitely not client side, nor a html timeout. This is what I found out during all these tests:
When importing users, the highest number I can use at "imports per cycle" is 290. When "291" is used it will show some data being imported but freeze up after 176 users on the first page. With "292" the same happens after 89 users. "293" after 44 users. "294" after 26 users. "295" after 10 users. With "296" (and 297, 298) it shows just the top of the page: "Importing 296 Users" on the next line "From : 0 :: To : 296" and do nothing. From "299" and higher it will not show anything, just: "Using includes/config.php for target config." and not do anything.
At "import thread" the number that the importer will allow to work is somewhere between 750 - 1000 but still not anywhere near the default 2000.
I've not tried any of the following modules yet but I expect they will do the same.
To me it looks like it could be because of PHP or SQL packet/memory limitations but if this is true then it should not give such a high default value.
Server details:
Web Server: Apache v2.0.40
PHP: 5.0.4
PHP Max Post Size: 8.00 MB
PHP Maximum Upload Size: 2.00 MB
PHP Memory Limit: 8.00 MB MB
MySQL: 4.1.21
MySQL Packet Size: 1.00 MB
ImpEx details:
Importing from "75. vBulletin (3.6.x)" to "vBulletin 3.6.7pl1". The actual source version is 3.6.4.
If it's not caused by a bug and the high default imports per cycle isn't considered an error/bug either then I'd still appreciate help how to raise the numbers per cycle as it's going to take a long time importing 500,000 posts when it can only import so few each page reload.
EDIT: I forgot to mention that an actual error should be returned to keep people from waiting while nothing is happening.