phpbb3 -> bbpress converter « bbPress Support Forums

Posted 2 years ago #

First of all, thank you for a great script, I have run into a problem, it seems when I try to transfer the 60k posts it reads:

Data too long for column 'post_text' at row 1 [1406]

What can I do about this? Please help it is very urgent.

Also, in order for it to work, since I installed phpbb with a different table prefix, I had to define the prefix on the script file just under the bbPress prefix, then I worked:

$table_prefix = 'phpbb3_';

DennisH
Member

Posted 2 years ago #

@diegozaks: Sounds like you have a special character(s) in your db. You need to find and delete them. I had the same issue.

http://www.forlang.wsu.edu/help/keyboards.asp

Posted 2 years ago #

@DennisH: thanks for your reply, I am sorry, but I don't really understand, how do I delete them? do I have to go post by post and delete all the special characters? Perhaps there is a way to increase the maximum length of an SQL command?

Posted 2 years ago #

I have same issue and have over 25,000 posts, how do I delete all the special characters from the post or is their a way to have them imported through the SQL

af3
Member

Posted 2 years ago #

I have modified the original script to work with a bbpress integrated with wordpress. but the password is not working!

http://svn.adrianomelo.com/labs/Wenetus/phpbb3tobbpress.php

- uses the table wp_users instead bb_users
- the users in the wp_users are not lost!
- conficts resolved (user exists on wp database and phpbb database)

PROBLEM: the phpbb password is not working when imported to wp database

Same here -- all worked out fine, except password. The _phpbb3p_pass.php file was autoloaded in bb-plugins folder; seems to be not working. Anyone has a workaround this (other than asking users to reset their passwords) ?

Posted 2 years ago #

Does anyone have a copy of the files provided by the originator of this thread (wmnasef) and originally found here?

For some reason the file is no longer available from that link.

Failing that does anyone know of any working methods to convert from phpBB 3 to bbPress 1? I am really trying to get from an SMF 2RC1 install and have no problems moving to phpBB3 but stalled at now migrating to bbPress.

Posted 2 years ago #

Steve, it looks like the link in the original post is working again:
http://members.lycos.co.uk/wmnkhayal/files/phpbb3tobbpress%20converter.tar.gz

Posted 2 years ago #

Hello,

Really great script !!!but....
I tried the "addslashes" version but it doesn't work...there is the always same issue for French Forums version :

Erreur générale
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'abonner au Forum ?', 'Toutes les possibilités pour s'abonner sont expliquées i' at line 1 [1064]

Une erreur SQL est arrivée en chargeant cette page. Contactez l’administrateur du forum si ce problème persiste.

"s'abonner au Forum...." is the title of the first forum with a - ' - between - s - and - abonner -....

Did anybody find a solution for that ?

Thanks in advance...

David-
Member

Posted 1 year ago #

Hello,

I'm getting an error during the convert.

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 've bought in the past or intend to buy.', '51', '8', '3', '26')' at line 1 [1064]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

David-
Member

Posted 1 year ago #

I've fixed this error in the database file, and everything ran smoothly. Thanks a lot.

Posted 1 year ago #

Please share your solution David.

David-
Member

Posted 1 year ago #

There was an error in my converted phpbb sql file, the error clearly pointed me to the right direction. So all I did was download the phpbb database, then I traced the error down to the line that was being pointed out, I deleted what I thought could be causing it, saved it and exported it back to the database.

As soon as I ran the converter script, it worked like a charm.

Are you having any problem? It didn't take me more than 30mins to do all the conversions. I was initially on SMF, converted that to Phpbb, before finally converting to bbpress.

Posted 1 year ago #

I'd love to hear if anyone has found a way to successfully convert the format of the passwords from phpBB to bbPress.

Posted 1 year ago #

I was able to convert everything successfully! But when I login as the administrator I don't get the Admin link to access the "administration panel". Has anyone had this same issue and found a solution???

rspowers
Member

Posted 1 year ago #

my users are not converting over but everything else is. anyone have a similar problem? i am using phpbb3 version 7 and bbpress 1.0.

Posted 1 year ago #

For everyone having trouble with special characters in forum names and descriptions,

FIND (on or around lines 193 and 194 of the original script)
$forum_name = $row['forum_name']; $forum_desc = $row['forum_desc'];

CHANGE TO (adding the addslashes() function)
$forum_name = addslashes($row['forum_name']); $forum_desc = addslashes($row['forum_desc']);

And that should resolve most of the complaints I've seen here about the conversion failing.

Posted 1 year ago #

Fix Topic Slug phpBB Convert bbPress

add this to function.php in your template file

function fix_topicslug() {
global $bbdb;
$get_topics = $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE topic_slug='' ");
foreach( $get_topics as $get_topic ) {
$slug_fix = bb_slug_sanitize( wp_specialchars_decode($get_topic->topic_title));
$topic_id = $get_topic->topic_id;
$bbdb->query("UPDATE $bbdb->topics SET topic_slug= '$slug_fix' WHERE topic_id = '$topic_id' ;");
}
}

and echo fix_topicslug in header. cek your database, and dont forget to remove the above code if you already finish.
my problem now the post_position is broken after convert to bbpress (all post is position 1) any fix ?

Posted 1 year ago #

fix post position

function fix_post_position() {
global $bbdb;
$get_topics = $bbdb->get_results("SELECT * FROM $bbdb->topics ORDER BY topic_start_time ASC");
foreach( $get_topics as $get_topic ) {
$get_posttopic = $get_topic->topic_id;
$postorder = 1;
$get_posts = $bbdb->get_results("SELECT * FROM $bbdb->posts WHERE topic_id = '$get_posttopic' AND post_position = '1' ORDER BY post_time ASC");
foreach( $get_posts as $get_post ) {
echo "UPDATE bb_posts SET post_position = ";
echo $postorder++;
echo " WHERE topic_id = ";
echo $get_post->topic_id;
echo " AND post_id = ";
echo $get_post->post_id;
echo " ;";
echo '<br/>';
}
} }

echo fix_post_position in your template file and copy the sql query to your database

Josh
Member

Posted 1 year ago #

Ok i just moved everything over using this but my users are missing, including both admins so we can't login to bbpress, does anyone know how to fix this? If so please email me on how to fix this! The tables for users are there, but nothing to browse when i go to phpmyadmin

Posted 1 year ago #

hmm you can copy the user db from phpbb to bbpress but your website user need to reset password because phpbb use md5 hash

Posted 1 year ago #

I got all my users over, but the system never sends me an email when I try to to reset the password. Has anyone encountered that problem?

Also, how may one copy users from the phpbb_users database to the bb_users database manually?

Thanks for all help.

ch8rt
Member

Posted 1 year ago #

Just gone through this process, and for the most part it was painless (I had to go through and remove those offending characters).

But I can't get my head around the password situation, the documentation with the plugin seems to suggest that the users password will be converted upon login, but they can't log in because their password has changed.

Link to plugin http://bbpress.org/plugins/topic/md5-insecurity-for-bbpress/

What exactly is this plugin doing then? am I just stuck with everyone needing to reset? In which case do I need this plugin installed?

Posted 1 year ago #

I updated the current code and hosted it under google code at http://code.google.com/p/phpbb3-to-bbpress1-converter/
now it works with bbpress 1.0.2 and phpbb 3.0.7

have fun! and thanx original poster: wmnasef

Posted 1 year ago #

Hi numediaweb,

first of all thank you for the script: it does everything it promises and it's easy to use :-)

Non surprisingly it still seems to lack a few feature which are probably very hard to develop: it doesn't parse the bbcode inside posts (meaning that all the links inside the posts are gone) and it doesn't convert the attachments...

I hope someone will find the time to implement those, as I believe they're necessary to properly move a forum from one software to another.

Our forum is here

But thanks again anyway :-)

Posted 1 year ago #

that's true: this converter doesn't deal with attachements, for my forum, i didn't need attachements that's why I did'nt try to fix this probeleme, anyway, if I have time, i'll check this.. another think is the way phpbb3 stores attachements; it crypts file names so instead of "myimage.gif" it stores the file encrypted like "55_5230d911b6e6212b7a55075668053db2" but there will be a way just needs time!

Posted 1 year ago #

it doesn't parse the bbcode inside posts (meaning that all the links inside the posts are gone)

Is the bbcode still present in the bbPress database?

if so, then there are a few bbCode parsers for bbPress availible. I know Matt doesn't like it, and therefore we are the only forum that won't support it, but i think it only slows adoption

Posted 1 year ago #

Kevin: like this one -> http://bbpress.org/plugins/topic/bbcode-lite/faq/
are you aware of a way to handle the attachments?

Numediaweb: thanks a lot for your effort, much appreciated! :-)

I've been fighting with phpbb for a few days now, it's leaking everywhere now and I can't wait to get rid of it :-|

Thanks everybody!

A.

Posted 1 year ago #

I'm clueless about attatchements from anything to bbPress sadly; but that bbCode plugin works a treat :)

Posted 1 year ago #

I think this is great. I mean, I installed phpbb3 in my site and have been regreting it since users became more and more active.

I have a question, though. I've spent three days looking for some info (at google, wordpress, etc) and I think this is the right place.

Do I have to upload the bbpress files into the same directory where the phpbb files are right now or the new bbpress files can be anywhere? I've read that the database must be the same. My guess is that the files can be anywhere but I just want to make sure.

work
Member

Posted 1 year ago #

Hi Frank. Only should have installed bbpress in the same dbase which contain phpbb content. Place for files is not matter.

Remember! Make backup!

bbPress

Info

Tags

phpbb3 -> bbpress converter

See also: