[@neilj Participant 11 years, 4 months ago]

Yeah I am looking at how to import them myself. I was trying the following just to even get the categories into the database but it does nothing:

$this->field_map[] = array(
	'from_tablename'  => 'categories',
	'from_fieldname'  => 'id_cat',
	'to_type'         => 'category',
	'to_fieldname'    => '_bbp_forum_type'
);

Not that the forum I am importing has a lot of categories but it would be nice if we could import these as well.

[@neilj Participant 11 years, 4 months ago]

Quick update: I decided to do the import on an actual dev server rather than on my local machine and it completed. It did the conversion a lot faster than running locally. It does, however, look like it has not converted over the categories and I am not confident that all of the topics have converted either. If am not too hungover tomorrow I will look into it more 🙂

[@neilj Participant 11 years, 4 months ago]

Yeah there is something up with Apache. Reverted to the old script and I am getting the same thing happening:

View post on imgur.com

I’ll have a look and see what is causing it because it wasn’t happening yesterday.

[@neilj Participant 11 years, 4 months ago]

Now having an issue where Apache on Windows 7 appears to crash and the conversion process stops when processing the replies with latest script. I’ll need to get a SS of the dialogs that appear which I will attach when I get the chance. It stops/crashes at around 1370 replies. Funny thing is apache and all the other services such as mysql etc. are still running.

Also noticed that we still seem to have the issue where the count is out by the same amount we set to process i.e. it says we are processing 100 – 200 rows when in fact we are processing 200 – 300. This goes for both topics and replies.

Going to run the previous script to see if this causes the same issue.

Neil.

[@neilj Participant 11 years, 4 months ago]

Good stuff. Will give it a test out. Thanks.

Neil.

[@neilj Participant 11 years, 4 months ago]

Hmmm something odd going on and I beginning to think it is to do with the number rows being processed for the replies. Running a test where I have set processing of 100 rows at a time it is showing in the status box as the following:

Converting replies (1500 - 1599)

Looking at the number of wp_posts where the post_type is equal to reply it shows 1652:

mysql> select count(*) from wp_posts where post_type = "reply";
+----------+
| count(*) |
+----------+
|     1652 |
+----------+
1 row in set (0.00 sec)

I was checking the processlist whilst the import was running and the inserts just completely stopped with no errors.

[@neilj Participant 11 years, 4 months ago]

Been giving this a try today and yeah there seems to be a problem with importing replies (which we know is not working yet). So to help out the OP I give an example of replies not importing. For instance, this is the total number of SMF messages on SMF database I wish to convert to BBPress:

mysql> select count(*) from smf_messages;
+----------+
| count(*) |
+----------+
|     2663 |
+----------+
1 row in set (0.00 sec)

Running the importer it seems to get stuck and stops importing:

mysql> select count(*) from wp_posts where post_type = "reply";
+----------+
| count(*) |
+----------+
|     2252 |
+----------+
1 row in set (0.00 sec)

I am doing this on my own machine and looking at the apache logs I don’t see any errors related to the import. I also checked if there was a query stuck so I checked the process list and it was empty.

Going to debug the relevant scripts and see what I can find.