XMB 1.9.1 to vB 3.6.0

[Jenni_Kitten]

Hi,

I've been running test imports for the above systems on my Windows machine; all goes fine until around the 76,000th post. I did a check on the database through phpmyadmin, and got an error for the table with the posts in:

Problems with indexes of table `xmb_threads`
PRIMARY and INDEX keys should not both be set for column `tid`

I don't know if this is what is causing it; if it is, how do I fix it? I've tried running impex standalone and with vB, tried increasing the limits on script execution etc. to no avail. Doing post imports in smaller batches also failed.

The database in question has around 200,000 posts, 4000 members. Heavily modified, but impex just finds the irregular tables and excludes them, so I'm sure thats not an issue.

Thanks
Jenni

[Jerry]

Can you run a repair on the source table, or just delete the index's ?

[Jenni_Kitten]

Ran a repair, did not fix it. Delete the indexes...?

[Jerry]

Does ImpEx actually give any error, or just stops ?

Anything in the PHP or web server logs about what happened ?

[Jenni_Kitten]

It hangs. Basically brings the entire setup to a halt... sometimes crashes Apache. Have to restart everything to get it working again.

Had a quick look through the apache error logs, couldn't see anything that stood out...

[Jerry]

Possiably a post that is too big for max_packet_allowed in MySQL.

Whats your PHP memory limit and time out ?

Also what is the max_packet_allowed in MySQL ?

[Jenni_Kitten]

MySQL:

max allowed packet 1,047,552

PHP:

max execution time: 60

What variable in phpinfo defines memory limit?

[Jerry]

If you have any post that is over a meg, that will crash.



memory_limit = 512M ; Maximum amount of memory a script may consume (8MB)


memory_limit is the memory limit for the scripts.

[Jenni_Kitten]

memory_limit = 16M

Do you suggest editing these then? I can't find a MySQL config file...

[Jerry]

16M should be fine for default per page, though you could lower your per page as there may be a few gargantuan posts in a row that could go over 16M.

MySQL config file is my.cnf, usually, /etc/mysql/my.cnf on *nix.

[Jenni_Kitten]

I increased all the default values to big limits, didn't make a difference.

[Jerry]

Then its probably ImpEx, start a support ticket and ask for me.

[Jenni_Kitten]

Done. :)