Damn, I just realized phpmyadmin’s browsing interface was confusing me and I was giving netweb the wrong topic! Now I have sent him the correct one + the first post.
Yes, I’m trying to locate some blocking replies to send to netweb for testing.
JJJ: does this logic mean it skips the first post in topic: LEFT JOIN phpbb_topics AS topics USING (topic_id) WHERE posts.post_id != topics.topic_first_post_id LIMIT 470, 1
I think if this is true, I can’t just look at my phpbb_post row 470 in phpmyadmin, but would have to run a modified query to display the exact offending post.
Thanks for checking into this. Will be nice to get this figured out.
I’ve looked at the data you sent me and each value for each field is a valid field value/type!
I can import that data into a phpBB install, I can then import that data to bbPress!
I got nothing at the moment as to what is causing the import to stop, Ill try and gather some more sample data/databases to debug the issue.
For now if you get stuck try ‘bbp_converter_start by 1’
Ok restarting my web server did the trick and now it continues with the replies.
Sent you an email. The next stop was with replies, LIMIT 470. Managed to skip it. Left it running over night. When I came to check it, it had stalled at LIMIT 6874 and had outputted a huge line of dashes. I pressed stop and went to bump the bbp_converter_start. “Starting conversion” it said and started to output more dashes without actually doing anything.
If you can give me confirmation that 470 and 6874 mean row numbers in phpbb_posts, I will send those rows to you. But then I will wait for an update to bbPress with better debugging, because I can’t go doing conversions 1 row at a time for weeks on end hoping it won’t crash.
Drop me an email the data and your contact info and I will look at it and get back to.
Can you contact me privately?
To add to my debugging wish, would be nice to have the specific info even when running with more than 1 row at a time.
Can you post a copy of that posts SQL data please so we can have a look at that data to improve the bbPress phpBB importer.
660 does not imply the topic_id, but the row number. I finally managed to pinpoint the correct offending topic. Having to have to deal with row numbers, I was a bit confused about which topic I have to skip. There really should be some debugging feature that would display the exact topic_id or any first (=most important) field in a given table.
First I deleted a couple of topics (not the right ones) in phpBB. Then when it got stuck again, I realized which of them was the offender. Then I used the trick of bumping the value in bbp_converter_start by 1 and pressing Start to restart the conversion from where it left off.
The topic as I see it does not contain anything out of the ordinary: it’s by an admin, so his name is colored red. But otherwise the fields are fine.
- Open phpMyAdmin
- Open you phpBB database
- Click ‘browse’ on the ‘_topics’ table
- In the ‘topic_id’ field you will see the topic_id
- Navigate to page xyz where you will see a topic_id of 660
Have a good look at all the fields (horizontal list) of the data around that range and compare it to the previous 10 and next 10 topic_ids (i.e. topic_id 650-670)
Is there any major differences between the rows and fields of the posts besides topic title etc, is a particular topic_id row missing data that is in every other topic_id but not in that particular topic_id
I forgot to include that revision in 2.1.1. It will be in 2.1.2 later this week. 🙁
Thanks guys. I’ve updated the phpBB.php file as suggested, wiped out the Forums again, did the conversion from phpBB3 – it went through beautifully – and promptly received the same error when trying to login as a non-admin user that got ported from phpBB, only now it complained about phpBB.php vs. Phpbb.php.
So still no-go for me. 🙁
nick
Warning: require_once(converters/phpBB.php) [function.require-once]: failed to open stream: No such file or directory in /home/[ … ]/wp-content/plugins/bbpress/bbp-includes/bbp-user-functions.php on line 1467
Fatal error: require_once() [function.require]: Failed opening required ‘converters/phpBB.php’ (include_path=’.:/usr/lib/php:/usr/local/lib/php’) in
/home/[ … ]/wp-content/plugins/bbpress/bbp-includes/bbp-user-functions.php on line 1467
This should be fixed in 2.1.1 actually. The problem is each user has a meta value stored with ‘Phpbb’ when it should be ‘phpBB’. Updating the old meta keys should fix it, and I’ll add that bit into the next bbPress update.
This has now been fixed and will be in the next update v2.12
As a workaround you can download the updated phpBB.php file here.
Seeing as you wiped bbPress and tried the import from phpBB again, if you do the same again with this update users no longer need to reset their password 😉
I had successfully converted a phpBB3 (3.0.10) Forum to bbPress Plugin 2.1, under WP 3.4.1 with bbPress’ built-in converter. phpBB usernames were converted, but passwords had to be reset and users were prompted to enter either their emails or usernames. Everything worked fine.
Then the other day, I upgraded to bbPress 2.1.1 (plugin), and now when a user tries to log in and supplies a password, instead of being redirected to an alert, I get this error (full path is truncated) – see below. Line 1467 is simply an instruction to process scripts in the “converters/” directory. I tried wiping out the Forum database and converted from phpBB again – same difference… Any idea?
Thanks,
nick
Warning: require_once(converters/Phpbb.php) [function.require-once]: failed to open stream: No such file or directory in /[…]/wp-content/plugins/bbpress/bbp-includes/bbp-user-functions.php on line 1467
Fatal error: require_once() [function.require]: Failed opening required ‘converters/Phpbb.php’ (include_path=’.:/usr/lib/php:/usr/local/lib/php’) in /[…]/wp-content/plugins/bbpress/bbp-includes/bbp-user-functions.php on line 1467
Did those and it still gets stuck. Can you confirm that the topic is on the row 660?
Can you try going into the phpBB Admin and run the following:-
-
Resynchronise statistics
Recalculates the total number of posts, topics, users and files.
-
Resynchronise post counts
Only existing posts will be taken into consideration. Pruned posts will not be counted.
-
Resynchronise dotted topics
First unmarks all topics and then correctly marks topics that have seen any activity during the past six months.
It is a clean WP install on my local machine. Phpbb is 3.0.9.
I finally ran it 1 row at a time and this is the content of bbp_converter_query:
> SELECT convert(topics.topic_id USING “utf8”) AS
> topic_id,convert(topics.forum_id USING “utf8”) AS
> forum_id,convert(topics.topic_poster USING “utf8”) AS
> topic_poster,convert(posts.post_text USING “utf8”) AS
> post_text,convert(topics.topic_title USING “utf8”) AS
> topic_title,convert(topics.topic_time USING “utf8”) AS topic_time FROM
> phpbb_topics AS topics INNER JOIN phpbb_posts AS posts USING
> (topic_id) WHERE posts.post_id = topics.topic_first_post_id LIMIT 660,
> 1
How can I determine the correct id in phpmyadmin? Is it row 660? Like if I have Show 30 rows starting from 660, will it show the correct topic id as the first one? The topic in question doesn’t seem to have anything out of the ordinary in it.
Also have a read of the following thread and try some of the suggestions by JJJ here and here.
Can you try with a clean WordPress install on a different webhost or setup a local environment?
Try the import using the remote SQL server address rather than ‘localhost’
Can you narrow down the if it is an exact post that the importer fails on? eg. Is there some weird strings in the database for topic #xyz that is causing the importer to stop.
bbPress 2.1.1 was released and the notes said “Fixed Invision, phpBB, and vBulletin importers”.
Didn’t help with my problem!
Is there any way I can debug this?
Tried with 10 rows, 1 sec and 5 sec delay both result in a crash:
Converting topics (650 – 659)
I’m starting to suspect there is something fishy about this certain group of topics: Converting topics (500 – 599) – crashes every time. I had a delay of 5 seconds and could see in the monitor the disk use drop to zero for a good while.
Thanks, I’ll try decreasing the rows, increasing delay time and observing my disk in the Resource Monitor. Already had memory_limit = 1000M.
