[bidhan.baruah]

Hi,

We had a custom forum created through a .NET application. Its a legacy application built in 2006.
Now client is migrating to wordpress / bbpress. For forum migration I have created a application to import data from .NET application (Sql Server database) in a format where I can use mingle importer to import.

The tables we have created are wp_forum_forums, wp_forum_threads; wp_forum_posts;

Table definition are
CREATE TABLE wp_forum_forums (
id bigint(20) NOT NULL AUTO_INCREMENT,
name varchar(4000) NOT NULL,
parent_id bigint(20) NOT NULL,
description text,
sort int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

CREATE TABLE wp_forum_posts (
id bigint(20) NOT NULL AUTO_INCREMENT,
parent_id bigint(20) NOT NULL,
subject varchar(2000) DEFAULT NULL,
author_id bigint(20) unsigned NOT NULL,
text mediumtext,
date datetime NOT NULL,
PRIMARY KEY (id),
KEY fk_wp_forum_posts_wp_forum_threads_idx (parent_id),
KEY fk_wp_forum_posts_wp_user (author_id),
CONSTRAINT fk_wp_forum_posts_wp_forum_threads FOREIGN KEY (parent_id) REFERENCES wp_forum_threads (id),
CONSTRAINT fk_wp_forum_posts_wp_user FOREIGN KEY (author_id) REFERENCES wp_users (ID) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=69731 DEFAULT CHARSET=latin1;

CREATE TABLE wp_forum_threads (
id bigint(20) NOT NULL AUTO_INCREMENT,
parent_id bigint(20) NOT NULL,
starter bigint(20) unsigned NOT NULL,
subject varchar(4000) DEFAULT NULL,
status varchar(100) NOT NULL,
date datetime NOT NULL,
last_post datetime NOT NULL,
closed varchar(50) NOT NULL,
PRIMARY KEY (id),
KEY fk_wp_forum_threads_wp_forum_forums_idx (parent_id),
KEY fk_wp_forum_threads_wp_users_idx (starter),
CONSTRAINT fk_wp_forum_threads_wp_forum_forums FOREIGN KEY (parent_id) REFERENCES wp_forum_forums (id),
CONSTRAINT fk_wp_forum_threads_wp_user FOREIGN KEY (starter) REFERENCES wp_users (ID) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=9303 DEFAULT CHARSET=latin1;

Through our custom code we populated these tables.

Everything works fine, but while importing the wp_forum_posts (which has got 69K records) the importer hangs between 35600 to 35699. I tried atleast 5 / 6 times but same result every time.

Can you kindly help us in this?

Thanks and Regards
Bidhan