http://bbpress.org/forums/ bbPress Support Forums Tag: converter en Fri, 09 Jan 2009 04:07:15 +0000 http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22816 Fri, 09 Jan 2009 02:55:58 +0000 Sheer Progress 22816@http://bbpress.org/forums/ <p>I know all about databases, I've been working with MySQL for years, have had 3 different sites, all with autonomous forums. I've had occasions to uninstall and reinstall after removing database tables. Plug-ins shouldn't leave hidden files like that. Once you remove the tables, they should all be gone, and that's not the case here. There are still items in my tables that have %bb in them and I'm afraid to delete them because they are so integrated with word-press. I switched to Simple Press and have found it much more user friendly and their support outstanding. I'm having a couple little issues and I'm convinced they have to do with the installation of this plug-in.</p> <p>I appreciate what goes into development, so please don't get me wrong. I just think people should heed the warning before proceeding. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22788 Thu, 08 Jan 2009 19:50:39 +0000 chrishajer 22788@http://bbpress.org/forums/ <p>Hopefully, with an active blog, you have a good database backup.</p> <p>I'm confused on tThis point:</p> <p><code>my bbpress tables are inside of wordpress (obviously)</code></p> <p>That's not obvious to me, at all. Do you mean the bbPress tables are inside the same <strong>database</strong> where your WordPress tables are? That's OK. You can put as much stuff as you want into a database, so long as you use different table prefixes for the different applications. For example:</p> <p><code><br /> WordPress: wp_<br /> bbPress: bb_<br /> Joomla!: jos_<br /> etc<br /> </code></p> <p>You can call your database whatever you want, then just keep loading tables into it for different application, like WordPress and bbPress.</p> <p>If you integrated WordPress and bbPress, then your bbPress installation used two existing WordPress tables: wp_users and wp_usermeta. That's to allow integrated logins.</p> <p>Regarding where you put bbPress files, you said you put them into the phpbb directory. Does it look like this?</p> <p>/var/www/htdocs/website/phpbb3/<br /> /var/www/htdocs/website/phpbb3/bbpress/</p> <p>If so, <a href="http://bbpress.org/forums/topic/old-configphp-detection-broken#post-22194">someone else recently found</a> that bbPress finds an existing config.php (the one for phpbb3) and won't go any further. In that case, just rename the phpbb3 config.php to something else for just a minute, so installation can continue.</p> <p>There is some confusion about database names, table names and folders, for me anyway. Any information you can post to help clarify will help. Thanks. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22787 Thu, 08 Jan 2009 19:48:18 +0000 wmnasef 22787@http://bbpress.org/forums/ <p>am talking about database tables. both phpbb3 and bbpress should use the same database.<br /> first, get a backup of all of your files, so you can restore everything back if anything went wrong.<br /> now install a new copy of bbpress, make sure you use the same database as the current phpbb3 installation is using.<br /> finish the installation then run the converter, and there should be no problems. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22779 Thu, 08 Jan 2009 18:13:02 +0000 Sheer Progress 22779@http://bbpress.org/forums/ <p>I see there are a bunch of bb_files hidden inside the database and I don't know what to remove and what to keep. Please, please tell me what to do to remove them all. I have an extremely active blog and this is making me quite nervous. Thank you. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22777 Thu, 08 Jan 2009 17:03:17 +0000 Sheer Progress 22777@http://bbpress.org/forums/ <p>Great. I removed all the bbpress database files from mySQL and all related bbpress files from my control panel. I reuploaded bbpress into the phpbb3 directory and it won't let me install, says there is an old config.php file. Now I can't use bbpress at all. Any suggestions? </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22769 Thu, 08 Jan 2009 16:00:35 +0000 Sheer Progress 22769@http://bbpress.org/forums/ <p>OK, before I go and mess with this whole thing, are you telling me I should install bbpress inside of phpbb3? I want the tables to be inside wordpress, not phpbb3...I will eventually remove phpbb3. Please confirm that I should be uninstalling the other copy and putting the new one inside of the phpbb3 database and then tell me how that will affect my integration into wordpress and the removing of phpbb3. Thank you. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22768 Thu, 08 Jan 2009 15:33:39 +0000 wmnasef 22768@http://bbpress.org/forums/ <p>bbpress and phpbb3 tables must use the same database for the convertor to work! </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22764 Thu, 08 Jan 2009 14:33:23 +0000 Sheer Progress 22764@http://bbpress.org/forums/ <p>I am looking at mySQL and my bbpress tables are inside of wordpress (obviously) but with the bb_ prefix, so what would I be changing it to? There are no bb_ tables inside of phpbb3, which is what that error code indicates, or am I thinking of this wrong? </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22761 Thu, 08 Jan 2009 14:18:32 +0000 wmnasef 22761@http://bbpress.org/forums/ <p>i think you are using different prefix for your bbpress tables. if thats it, just modify line 17 in phpbb3tobbress.php into the prefix you used.<br /> again, i wrote that converter assuming the conversion is done on a new empty bbpress installation, not even integrated to wp. integration can be done after conversion according to <a href="http://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101#post-17411">this post</a>. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22758 Thu, 08 Jan 2009 13:53:13 +0000 Sheer Progress 22758@http://bbpress.org/forums/ <p>Everything went fine until I went to truncate and then got this message:<br /> Table 'robpr3_phpBB3.bb_forums' doesn't exist <a href="http://trac.bbpress.org/changeset/1146">[1146]</a><br /> I had all ready installed and integrated bbpress with WP. Does this mean I have to start from scratch? :-(<br /> Thanks. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22236 Thu, 25 Dec 2008 14:02:12 +0000 wmnasef 22236@http://bbpress.org/forums/ <p>i wrote it assuming the conversion is done on a new empty bbpress installation. then integrating it later with WP. they call it reverse integration on this post <a href="http://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101#post-17411" rel="nofollow">http://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101#post-17411</a> </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22216 Wed, 24 Dec 2008 23:13:52 +0000 johnjamesjacoby 22216@http://bbpress.org/forums/ <p>How nicely does this play with WP integration in regards to the users and existing WP accounts? I'm assuming that it would take another dump and update to merge the bb_ table this makes with the wp_ table necessary for user integration. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22214 Wed, 24 Dec 2008 22:25:25 +0000 bryan868 22214@http://bbpress.org/forums/ <p>Worked perfectly. Thank you! </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22207 Wed, 24 Dec 2008 17:57:55 +0000 wmnasef 22207@http://bbpress.org/forums/ <p>yes, after conversion. and you don't have to install it, just copy the file as is and it will be loaded automatically. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22184 Wed, 24 Dec 2008 00:35:42 +0000 bryan868 22184@http://bbpress.org/forums/ <p>I'm about to run this script. THANK YOU! So for the md5 hashing plugin, do we need to install that after we convert? Or? </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-22099 Sun, 21 Dec 2008 22:36:35 +0000 adamhdv04 22099@http://bbpress.org/forums/ <p>I ran this script perfectly. I was running phpbb3 3.0.3 I think, with phpbb-se0 advanced installed. Worked perfect, thanks!</p> <p>:) </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-21489 Thu, 11 Dec 2008 14:53:54 +0000 lyrics 21489@http://bbpress.org/forums/ <p>Its great idea to have sub forums. I agree that bbpress does not have an option for hidden forums, but the discussions can be locked and pinned up for limited conversations. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-21452 Wed, 10 Dec 2008 19:24:21 +0000 wmnasef 21452@http://bbpress.org/forums/ <p>no worries about subforums, they will appear as with phpbb3, but bbpress doesn't have the hidden forum option so they will be viewable to everyone after conversion.<br /> maybe you can use <a href="http://bbpress.org/plugins/topic/hidden-forums/">that plugin</a> to hide them again after conversion. </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-21448 Wed, 10 Dec 2008 17:14:39 +0000 hhberthelsen 21448@http://bbpress.org/forums/ <p>Sounds awesome, will test it one of the next days. We have nearly 200.000 posts - will be interesting to test, and surely on my own dedicated server :-o</p> <p>Any concerns regarding subforums or "hidden" forums, that i should be warned about? </p> http://bbpress.org/forums/topic/phpbb3-gt-bbpress-converter-beta-release#post-21404 Tue, 09 Dec 2008 21:23:46 +0000 wmnasef 21404@http://bbpress.org/forums/ <p>hi !</p> <p>am working on moving my site from phpbb3 to bbpress, of course there is no converters out there for that purpose, so i decided to write my own.</p> <p>am still testing it and trying to improve the code a little bit. right now it can convert the following :</p> <p>1- forums<br /> 2- topics, completely with topic types and status.. announcements and glopal announcements are stickied to front page.<br /> 3- posts, all bbcode is converted into html, smiles are changed into img tags, so you might want to install <a href="http://bbpress.org/plugins/topic/allow-images/">allow images plugin</a>.<br /> 4- users, including permissions .. notice that bbpress doesn't support per forum permissions as phpbb3, so it only convert users as following :<br /> founder -&gt; key master<br /> inactive -&gt; inactive<br /> banned -&gt; blocked<br /> moderators and admins are converted into normal users, so you have to assign them again</p> <p>because phpbb3 doesn't use md5 hashing anymore, the script copies passwords as it is. to solve that problem i modified the <a href="http://bbpress.org/plugins/topic/md5-insecurity-for-bbpress/">md5 insecurity for bbpress plugin</a> to first check the passwords the phpbb3 way, if it matches, it will rehash it using bbpress functions.</p> <p>the script converts all the table rows at once, so it's very heavy and consumes too much cpu depending on your forum size, i strongly suggest that you do the conversion on your own machine, not on a shared hosting account. you might also want to increase the php max execution time on your machine before starting the script cause it takes lots of time converting posts.</p> <p>here is the steps for converting your phpbb3 board :<br /> 1- make a backup from your database and files.<br /> 2- install bbpress anywhere, just use the same database of phpbb3. this is important cause the script assumes that all tables are in the same database.<br /> 3- download the script from <a href="http://members.lycos.co.uk/wmnkhayal/files/phpbb3tobbpress%20converter.tar.gz">here</a>. extract it, and you'll get 2 files.<br /> 4- copy the file phpbb3tobbpress.php to phpbb3 directory.<br /> 5- copy the file _phpbb3_pass.php to bb-plugins directory.<br /> 6- go to <a href="http://path-to-phpbb3/phpbb3tobbpress.php" rel="nofollow">http://path-to-phpbb3/phpbb3tobbpress.php</a> and start converting your board.<br /> 7- voila .. all your data is converted to bbpress tables, go to your bbpress installation and login. don't forget to visit admin-&gt;manage-&gt;recount to make sure your converted board is updated.</p> <p>i can't stress enough on how consuming is the process of converting posts, my board has 25,000 posts, and it takes nearly 15 minutes to convert them on my local machine, so again : i don't recommend using this converter on shared hosting.</p> <p>ciao ! </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-20667 Thu, 13 Nov 2008 12:36:30 +0000 eslavin83 20667@http://bbpress.org/forums/ <p>can anyone help?</p> <p>after the script runs, isn't there an sql file that's supposed to be generated from the old board &#38; saved into a /tmp/ folder? </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-20632 Wed, 12 Nov 2008 02:55:00 +0000 eslavin83 20632@http://bbpress.org/forums/ <p>i'm also getting this warning message: </p> <p>Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/public_html/bbs08/phpbb2bbpress.php on line 922 </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-20631 Wed, 12 Nov 2008 02:43:26 +0000 eslavin83 20631@http://bbpress.org/forums/ <p>can anyone answer the question regarding the "39816" error? i get up to step 8 and then that string of numbers shows up. i checked the new database and nothing has been pushed into it. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-19968 Thu, 16 Oct 2008 15:34:01 +0000 Grenoli-dk 19968@http://bbpress.org/forums/ <p>I am having problems with the phpbb2bbpress converter (http://www.iteisa.com/phpbb2bbpress/). </p> <p>When I run the file I just get this message. There isnt a sql-file to download or a file created on my server. </p> <p>1: I downloaded the file from: <a href="http://www.iteisa.com/phpbb2bbpress/" rel="nofollow">http://www.iteisa.com/phpbb2bbpress/</a></p> <p>2: I edited the lines I have written in bold.</p> <p>[code]<br /> define('DB_PHPBB_USERNAME', '[strong]databasename[/strong]');<br /> define('DB_PHPBB_PASSWORD', '[b]databasepassword[/b]');<br /> define('DB_PHPBB_DATABASE', '[b]databasename[/b]');<br /> define('DB_PHPBB_TABLEPREFIX', 'phpbb_');</p> <p>define('DB_BBPRESS_HOSTNAME', 'localhost');<br /> define('DB_BBPRESS_USERNAME', '[b]databasename[/b]');<br /> define('DB_BBPRESS_PASSWORD', '[b]databasepassword[/b]');<br /> define('DB_BBPRESS_DATABASE', '[b]databasename[/b]');<br /> define('DB_BBPRESS_TABLEPREFIX', 'bb_');[/code]</p> <p>I only have one database on my server, so the databasename and password is the same on the phpbb and bbpress part</p> <p>[code]define('EXPORT_TO_FILE', true); // Should the converted DB be exported to a file ?<br /> define('FILENAME', '/tmp/phpbb_imported.sql'); // Which one ? (Ensure this path is writeable by the server)<br /> define('AUTO_IMPORT_EXPORTED_DATA', false); // Should the script automagically import the converted DB ?[/code]</p> <p>3: I created the folder tmp at the root and used chmod on it.</p> <p>4: I uploaded the file to the root and tried to open it but I couldnt. So I removed the s in .phps and it worked. But i only got this message - but nothing really happened. I cant download a file, and there is nothing on my server. What am I doing wrong?</p> <p>[quote="Q!"]phpBB to bbPress database converter</p> <p>This script can convert a PhpBB 2.0.X (www.phpbb.com) forum database to bbPress "Bix" 0.73 (www.bbpress.org) format.</p> <p>Developed by Jaime GÓMEZ OBREGÓN from ITEISA, based on the previous work of Bruno Torres and The phpBB Group.</p> <p>The latest version of this file can be found on <a href="http://www.iteisa.com/phpbb2bbpress/." rel="nofollow">http://www.iteisa.com/phpbb2bbpress/.</a><br /> Starting conversion</p> <p> 1.<br /> Connected to the phpBB database host<br /> 2.<br /> Selected the phpBB database<br /> 3.<br /> Exporting forums...<br /> 4.<br /> Exporting users...<br /> 5.<br /> Exporting user metadata...<br /> 6.<br /> Exporting topics...<br /> 7.<br /> Exporting posts...<br /> 8.<br /> Sending all your database e-mails to all major world-wide spam sending mafias...[/quote]</p> <p>'strong'dsfgds'strong' </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-13109 Sat, 12 Jan 2008 04:44:32 +0000 citizenkeith 13109@http://bbpress.org/forums/ <p>I removed "topic_resolved" from the script. A fresh install later, and I get this error: "Column count doesn't match value count at row 1" </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-13093 Thu, 10 Jan 2008 21:59:35 +0000 citizenkeith 13093@http://bbpress.org/forums/ <p>I just reinstalled bbPress and did NOT utilize WP integration. I also tried using the forum support plugin, as recommended by fel64. </p> <p>Now I'm getting this error:<br /> Unknown column 'topic_resolved' in 'field list' </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-13092 Thu, 10 Jan 2008 21:40:19 +0000 citizenkeith 13092@http://bbpress.org/forums/ <p>I just tried this using phpBB 2.012 and bbPress 0.8.3.</p> <p>This is the error I get:<br /> Table 'khanlon_db3.henskebb_users' doesn't exist</p> <p>And that makes sense, since I already set up bbPress to integrate with WordPress. Since bbPress is using the wp_users table, the script doesn't know where to put the phpbb users.</p> <p>As it stands now, bbPress shows all the topic counts for each forum, but when you click on the forum, none of the threads are listed.</p> <p>I tried exporting all the users using phpMyAdmin and importing into the WP table, but the threads are still missing. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-8788 Mon, 09 Jul 2007 17:04:51 +0000 statusquo 8788@http://bbpress.org/forums/ <p>ok I've even tried version 0.73 but still encountering errors. Can anyone help? </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-8781 Sun, 08 Jul 2007 19:22:17 +0000 statusquo 8781@http://bbpress.org/forums/ <p>Hi all I also get an error on like the one experienced above:</p> <p>Fatal error: Call to undefined function: file_put_contents() in phpbb2bbpress.php on line 383</p> <p>Can anyone tell me how I can resolve this.</p> <p>I also notice that this converter has not been updated, is it going to be anytime soon?</p> <p>AND whilst converting WHY does it STATE that all emails are being forwarded to SPAMMERS? (Can't remember the exact words). Is this meant to be a joke?</p> <p>Thanks in advance. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2#post-7593 Tue, 22 May 2007 19:36:29 +0000 fel64 7593@http://bbpress.org/forums/ <p>The topic resolved thing is probably because that was written for an older version of bb which had that in it by default. I think installing the forum support plugin will add that column, worth a shot anyway?</p> <p><a href="http://bbpress.org/plugins/topic/16?replies=7" rel="nofollow">http://bbpress.org/plugins/topic/16?replies=7</a></p> <p>Otherwise you could edit the php file and remove the bits about the topic_resolved column (remember to back up the original file in case it doesn't work!). </p>