http://bbpress.org/forums/ bbPress support forums Topic: A phpBB to bbPress database converter en Sat, 06 Sep 2008 05:39:35 +0000 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> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-7590 Tue, 22 May 2007 18:45:04 +0000 Asrye 7590@http://bbpress.org/forums/ <p>I know this topic is pretty old, but I have a problem ... I converted members and forums succesfully, but topics and posts didn't show up. I got these errors when converting:</p> <p>#<br /> Warning, there was an error with the following query</p> <p>#Exporting Topics: INSERT INTO bb_topics (topic_id, topic_title, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id, topic_status, topic_resolved, topic_open, topic_last_post_id, topic_sticky, topic_posts, tag_count) VALUES ( 4, 'Pravila!', 2, 'Zala', 2, 'Zala', '2007-02-13 16:13:01', '2007-02-13 16:13:01', 1, 0, 'no', 1, 765, 0, 2, 0)</p> <p> Unknown column 'topic_resolved' in 'field list'</p> <p>...</p> <p>And a lot more of them. I don't know much about php really, so I have no idea what is wrong. It's probably a stupid mistake I made, but I don't know what it is. Help me, please? </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-6739 Sun, 15 Apr 2007 20:43:39 +0000 GTim 6739@http://bbpress.org/forums/ <p>Thanks for this great script. Unfortunately I got myself suspended from one of my webhosts since it clogged up the MySQL queue :) But I have only myself to blame, and they did let it pass only giving me a final warning. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-5420 Mon, 12 Mar 2007 14:27:59 +0000 wittmania 5420@http://bbpress.org/forums/ <p>One problem I ran into was that I already had a few existing users on the wordpress side, which led to conflicting unique user IDs. I got the importer to work, but some of the posts were under the wrong user names b/c of conflicting unique user IDs between wordpress/bbpress and the old phpbb board I tried to import.</p> <p>I haven't been able to try it yet (phpbb.com is down), but they have <a href="http://www.phpbb.com/phpBB/viewtopic.php?t=388155&#38;sid=3d5e8f776a7086b6fec64c3e80c7cbca">a mod</a> called Change User ID that seems to do exactly what its name suggests. If so, I intend to use it to change the three user IDs that are conflicting from 2, 3, and 6 to 99992, 99993, and 99996 respectively. That way, when I import the phpbb tables there will just be "blanks" in the sequential unique user IDs for the existing wordpress IDs to fit into.</p> <p>Hope this is helpful... </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-4240 Fri, 09 Feb 2007 05:31:17 +0000 Trent 4240@http://bbpress.org/forums/ <p>Once again, don't think this is the case. </p> <p><a href="http://bbpress.org/forums/topic/47?replies=6#post-4238" rel="nofollow">http://bbpress.org/forums/topic/47?replies=6#post-4238</a></p> <p>Trent </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-4235 Fri, 09 Feb 2007 05:16:32 +0000 lingmiester 4235@http://bbpress.org/forums/ <p>I tried to contact the author of this list, and his email is dead. I would becareful as it seems this list sends all your forums members emails to spammers. Just to be safe DONT use this script! </p> <p>I'll have to suffer with the conciquences! </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-4127 Thu, 08 Feb 2007 13:04:29 +0000 lingmiester 4127@http://bbpress.org/forums/ <p>Ok i hope that last part:<br /> "Sending all your database e-mails to all major world-wide spam sending mafias..."</p> <p>Is a joke? I am moving from phpbb because of spam and this does not sit too lightly on me...ok i need to take a chill pill.</p> <p>Ok back to the task as hand. It totally does not work for me i get no databases installed? When i run it, I get all the exporting scripts, then point 8. about the mafia. And then I get a row of numbers "39816"<br /> I'm using 0.75. Is there a version conflict?</p> <p>Thanks. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-3351 Fri, 19 Jan 2007 02:17:19 +0000 ateale 3351@http://bbpress.org/forums/ <p>I forgot to give a big thankyou to jaim3! Thanks mate! Your script just made life a million times easier for me!<br /> Cheers! </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-3349 Fri, 19 Jan 2007 02:09:50 +0000 ateale 3349@http://bbpress.org/forums/ <p>kickass! yes our server was set by default to php4. The server guys said:</p> <blockquote><p>We have checked our server logs. The reason for the issue is not related to the memory limits for your account. </p> <p>The file_put_contents() function is only available in PHP 5.</p> <p>By default our servers handle any requests to .php file through the PHP 4 interpreter. By default the PHP 5 interpreter processes only files with .php5 extension.</p> <p>If you want to change this in a way that .php files are processed by the PHP 5 interpreter you should put the following line in your /www/blog/.htaccess file:</p> <p>AddHandler application/x-httpd-php5 .php"</p> </blockquote> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-3332 Thu, 18 Jan 2007 16:09:58 +0000 ateale 3332@http://bbpress.org/forums/ <p>i believe it is the latest version - i downloaded it today - .75 i think</p> <p>it would be so so so nice if this works!</p> <p>Cheers Trent </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-3329 Thu, 18 Jan 2007 16:05:32 +0000 Trent 3329@http://bbpress.org/forums/ <p>Hmm....maybe the function name changed? What version of bbPress? 0.75?</p> <p>Trent </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-3327 Thu, 18 Jan 2007 15:59:42 +0000 ateale 3327@http://bbpress.org/forums/ <p>hey guys,</p> <p>I seem to get the same error as Jaxxx:</p> <p>Fatal error: Call to undefined function: file_put_contents() in phpbb2bbpress.php on line 383<br /> anyone got any ideas?</p> <p>cheers<br /> Adam </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-3057 Tue, 09 Jan 2007 05:11:56 +0000 gewatkins 3057@http://bbpress.org/forums/ <p>I've gone through the import process successfully except that the text of the posts don't show up. The text is in the database, it just doesn't show up where it should. The titles are there, the forums are there, the topics are there but no post text.</p> <p>Ideas? </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2993 Sun, 07 Jan 2007 16:00:17 +0000 stuboo 2993@http://bbpress.org/forums/ <p>Thanks jaim3. I can't tell you how excited I am about going from a board with 86 tables to one with 8! Light and fast is what my members will appreciate. I think the simpler design will result in higher adsense revenues from my message board channels. </p> <p>I have integrated bbpress to match the <a href="http://www.zenphotothemes.com/category/wordpress-themes/">tech-o-crunch theme</a> and will be releasing it to the bbpress community once I have it like I want it.</p> <p>I'll also be posting a casestudy of the bbpress adsense theory I mentioned above on my blog. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2987 Sun, 07 Jan 2007 12:04:41 +0000 jaim3 2987@http://bbpress.org/forums/ <p>I can't promise anything since I'have never seen IPB database structure nor code, but I can give it a try. Drop me a line at jaime at iteisa dot c0m with the public URI and I'll have a look at it if you are still interested.</p> <p>Jaime. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2963 Sat, 06 Jan 2007 23:51:22 +0000 stuboo 2963@http://bbpress.org/forums/ <p>Any of you php/mySQL whizkids out there wanna see if you can make this script work with invision power board? I only know enough php to be dangerous and know my limits well enough to know that trying to do this (for me) would be a big, big timewaster.</p> <p>I'd be willing to dish out a bit of cash to anyone who wants to play.</p> <p>I'll supply the ipb db for you to play with. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2921 Fri, 05 Jan 2007 00:48:14 +0000 willdayble 2921@http://bbpress.org/forums/ <p>Yeah, I needed about 80 megs of memory for this particular script, luckily my host upped it while I ran it.</p> <p>jaim3, perhaps note that somewhere in a readme, for the not-so-smart users like myself. :) </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2828 Wed, 03 Jan 2007 04:02:24 +0000 Trent 2828@http://bbpress.org/forums/ <p>I would get your host to up the memory in php.ini to accomodate the script. How big is your phpbb2 database? I moved over a forum that was 1600 entries without too much hassle....(needed 16 megs in php.ini though)</p> <p>Trent </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2827 Wed, 03 Jan 2007 02:46:23 +0000 willdayble 2827@http://bbpress.org/forums/ <p>I'm getting an 'out of memory error' as so:</p> <blockquote><p>Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 5803 bytes) in /home/pith/domains/pithrecords.com/public_html/phpbb2bbpress.php on line 910</p></blockquote> <p>... is it just that my server sux? </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2468 Wed, 20 Dec 2006 17:54:40 +0000 implicated 2468@http://bbpress.org/forums/ <p>Your PHP version is rather old, use this:<br /> <code><br /> if (!function_exists('file_put_contents')) {<br /> function file_put_contents($filename, $content) {<br /> if ($fp = fopen($filename, 'w')) {<br /> $result = fwrite($fp, $content);<br /> fclose($fp);<br /> return $result;<br /> }<br /> else {<br /> return false;<br /> }<br /> }<br /> }<br /> </code> </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2440 Wed, 20 Dec 2006 02:32:43 +0000 willdayble 2440@http://bbpress.org/forums/ <p>Oh that's gorgeous </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2306 Fri, 15 Dec 2006 17:55:41 +0000 Jaxxx 2306@http://bbpress.org/forums/ <p>still no joy I'm afraid. this time it runs for a lot longer and I don't get any errors, but it doesn't update any of the tables. i'll try and take another look at the weekend. </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2248 Wed, 13 Dec 2006 08:06:54 +0000 jaim3 2248@http://bbpress.org/forums/ <p>Hi,</p> <p>Have you checked if FILENAME (line 85) is writeable by the server? If it is, try switching EXPORT_TO_FILE to <strong>false</strong> and AUTO_IMPORT_EXPORTED_DATA to <strong>true</strong>. As usual, please do always a database backup before.</p> <p>Hope it helps :-) </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2238 Tue, 12 Dec 2006 19:54:56 +0000 Jaxxx 2238@http://bbpress.org/forums/ <p>hmm. i tried this, but get this error after step 8:</p> <p>Fatal error: Call to undefined function: file_put_contents() in phpbb2bbpress.php on line 383</p> <p>any suggestions? </p> http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter#post-2168 Sun, 10 Dec 2006 16:08:13 +0000 Trent 2168@http://bbpress.org/forums/ <p>I have thought about this a was thinking that it really doesn't matter, but my preference would be to get the login integration with WP first if you are going to have it and this doesn't apply to everyone because not everyone is going to sync logins with WP. The reason is that seems to be the hardest part and you have to have your key admin being the one you want and associated with the right user in WP. </p> <p>Once you are ready to go, then test the import of phpBB becauase if it doesn't go according to plan, you can just empty tables in bbPress and the hardcoding part for integration is still done.</p> <p>Trent </p>