Out of memory / 500 Internal Server Error

[sluggy]

I have a VPS w/WiredTree, root access, and IonCube is working fine.

However, when I use the wget method to import the posts, it imports about 800 and then returns an "Out of memory" error.

And when I use the cron_no-wget.php method, it imports about 1,200 posts before returning an "500 Internal Server Error."

I've set all the posts to have the same date as I saw suggested elsewhere and that still hasn't fixed it.

[sluggy]

Now both methods are returning a 500 Internal Server error.

I've increased my memory limit to 124M and still no dice.

All plugins are deactivated except for WFReview.

[sluggy]

I'm seeing the following error repeat a lot while importing, I think this is causing my problem:

<div id='error'>
<p class='wpdberror'><strong>WordPress database error:</strong> [Duplicate entry '9969-27433' for key 'PRIMARY']<br />
<code>INSERT INTO `wp_term_relationships` (`object_id`,`term_taxonomy_id`,`term_order`) VALUES ('9969','27433','0')</code></p>
</div>

Any ideas?

[WFReviewAdmin]

Try setting the autosplit option to 1000 posts. If that does not work, try 100 at a time.

[sluggy]

I set the autosplit to 100 and it failed at just over 4000:

<b>Fatal error</b>: Out of memory (allocated 25165824) (tried to allocate 63 bytes)

[WFReviewAdmin]

can you send the csv to support@reviewpluginforwordpress.com thank you!

[sluggy]

No problem. Sent

[WPDude]

Very interested in the solution to this memory issue - we're having the same error messages appear in wordpress on Wiredtree.

[WFReviewAdmin]

WPDude, did you set the autosplit lower?

[sluggy]

WPDude, the problem in my case was that I had over 200,000 tags and Wordpress couldn't handle it. I tried re-importing without tags and it worked fine. Hope this helps.