bbPress

Info

• 132 posts
• 63 voices
• Started 3 years ago by wmnasef
• Latest reply from shooo
• This topic is not resolved

Tags

• addslashes
• admin
• attachment
• bbcode
• bbPress
• canoe
• conversion
• convert
• converter
• database
• escape
• French
• long data
• panel
• password
• perfect
• phpBB
• phpbb convertor
• phpbb to bbpress
• phpbb3
• phpmyadmin
• problem
• quotation
• single quote
• solution
• thread nice

• Posts in this topic

phpbb3 -> bbpress converter

1. • 
   • chrishajer
   • Moderator

   • Posted 2 years ago #

   Have you tried dumping all the cookies to be sure there is nothing left over fouling things up?
2. • 
   • helgetry
   • Member

   • Posted 2 years ago #

   I figured it out. There were two records for my capabilitues in the database. I don't know why. When I changed both of them to keymaster, I got admin rights.
3. • 
   • gadgets
   • Member

   • Posted 2 years ago #

   It's work good thank you.
4. • 
   • gavinj77
   • Member

   • Posted 2 years ago #

   When I tried to convert my forum, I got this error:

   General Error
   SQL ERROR [ mysqli ]

   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 's workouts logs)', '18', '2', '9', '162')' at line 1 [1064]

   SQL

   INSERT INTO bb_forums (forum_id , forum_name, forum_desc, forum_parent, forum_order, topics, posts) VALUES ('19', 'Workout Logs', 'Place to log the workouts you do, times, & weights used. (Please do not post on other people's workouts logs)', '18', '2', '9', '162')

   BACKTRACE

   FILE: includes/db/mysqli.php
   LINE: 163
   CALL: dbal->sql_error()

   FILE: phpbb3tobbpress.php
   LINE: 201
   CALL: dbal_mysqli->sql_query()

   "

   Do you know what the problem might be? Maybe it's an easy fix, but I'm a novice. Thank you.
5. • 
   • matiaspunx
   • Member

   • Posted 2 years ago #

   yeah you need to use the addslash function to insert data in your db...
   I think you need to edit the phpbbtobbpress.php ;)
6. • 
   • gavinj77
   • Member

   • Posted 2 years ago #

   Okay....let's imagine for a minute that I'm 10 years old.

   LOL Can you explain how I would do that? Where do I place addslashes? In phpbbtobbpress.php? If so where? I'm really not good at this. It's completely Greek to me.
7. • 
   • matiaspunx
   • Member

   • Posted 2 years ago #

   Ok, i will send you my edited file, use it under your own risk, it's works like a charm but, nobody knows...
   Examine the file and see the changes made by me :)

   PD: PLEASE, back up your db first!
   DOWNLOAD: http://www.mediafire.com/?nmmymgg0z0j

   Hope this works for you!

   Best regards!
8. • 
   • gavinj77
   • Member

   • Posted 2 years ago #

   Thank you for the file. I used the file, (did not edit it at all because I have no idea what I'm doing). I get this error when I try to access the forum

   bbPress database error: [Table 'db279681361.bb_topicmeta' doesn't exist]
   SELECT meta_value FROM bb_topicmeta WHERE topic_id = 0 AND meta_key = 'uri'

   Warning: Cannot modify header information - headers already sent by (output started at /homepages/34/d279666578/htdocs/forums/bb-includes/db-mysql.php:130) in /homepages/34/d279666578/htdocs/forums/bb-includes/functions.php on line 2271

   Is this a simple error to fix? If not, I'm going to have resolve myself to using phpbb3, (which I don't want to do of course). Thank you again. I appreciate it.
9. • 
   • chrishajer
   • Moderator

   • Posted 2 years ago #

   Are you using bb_ as your bbPress table prefix? Maybe the bb_ table prefix is hard coded and it does not match up with your installation.
10. • 
    • gavinj77
    • Member

    • Posted 2 years ago #

    I checked via phpMyAdmin and all my bbPress files start with bb_ . I didn't change any files from the install. The phpbb3 files all begin with phpbb_
11. • 
    • matiaspunx
    • Member

    • Posted 2 years ago #

    oh! what version for bbpress are you trying to convert?
    this file just works with a new fresh install of "0.9.x"

    the converter finished without problems?
12. • 
    • gavinj77
    • Member

    • Posted 2 years ago #

    It worked! Thank you guys for your help! I realized I forgot to delete the bb_ files via phpMyAdmin, (from the first time I tried the conversion without the edited file from matiaspunx. I had removed the files via FTP only.

    Thanks again!
13. • 
    • webrulon
    • Member

    • Posted 2 years ago #

    matiaspunx I am receiving the same error as gavinj77, I tried to download your fix at http://www.mediafire.com/?nmmymgg0z0j but the file was no longer available. Could you kindly repost the updated file?

    Thanks,
    Russell
14. • 
    • webrulon
    • Member

    • Posted 2 years ago #

    Can someone please help me out with this, I'm willing to pay anyone who can solve my issue.

    Thanks,
    Russell
15. • 
    • Loader
    • Member

    • Posted 2 years ago #

    bbpress 0.9.0.5 and phpbb 3.0.5 at localhost:

    when i click on "converting users data"

    i have:

    SQL ERROR [ mysqli ]

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

    to small? how to fix and convers users data properly?

    updated: fixed!
    ALTER TABLE bb_users CHANGE user_url user_url VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
16. • 
    • JLeuze
    • Member

    • Posted 2 years ago #

    I got pretty close with wmnasef's script, but I think I am having a problem similar to gavinj77's.

    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 'opinions on current political questions.', '0', '2', '48', '235')' at line 1 [1064]

    I'm trying to convert an install of phpBB 3.0.4 to bbPress 0.9.0.5, a small amount of data did transfer over to bbPress before I received the error.

    I tried to download matiaspunx's edited file and I was also unable to.

    Does anyone know exactly what I have to edit to "use the addslash function", or happen to have a copy of this file they would be kind enough to share with me?
17. • 
    • JLeuze
    • Member

    • Posted 2 years ago #

    I got it to work, the converter did a great job, thanks wmnasef!

    I was trying to do the conversion on fairly standard VPS with a typical LAMP stack, I'm not really sure why it didn't work on there.

    But after that I tried the conversion on my Media Temple Grid Service account and it worked fine. (The forum is quite small, 7000 posts) So if someone else runs into a similar problem, try a different web host or a local web server, maybe you'll have better luck too!
18. • 
    • AndrewRH
    • Member

    • Posted 2 years ago #

    Any word on whether this converter works for phpBB3 v3.0.5 and bbpress v1.0? (asking before trying!)

    Thanks,

    ~Andrew~
19. • 
    • JLeuze
    • Member

    • Posted 2 years ago #

    Andrew, I just converted a test install of phpBB 3.05 to bbPress 1.0.1 without any problems.
20. • 
    • MrPresident
    • Member

    • Posted 2 years ago #

    Just done this myself on a live phpBB3 forum, worked like a dream, no issues. Thanks very much! =)
21. • 
    • michele83
    • Member

    • Posted 2 years ago #

    I have this problem on the second step:

    SQL ERROR [ mysqli ]

    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 'uso, critiche e suggerimenti', 'Aiutaci a migliorare la community!', '142', '11'' at line 1 [1064]

    SQL

    INSERT INTO bb_forums (forum_id , forum_name, forum_desc, forum_parent, forum_order, topics, posts) VALUES ('2', 'istruzioni per l'uso, critiche e suggerimenti', 'Aiutaci a migliorare la community!', '142', '11', '47', '1129')

    BACKTRACE

    FILE: includes/db/mysqli.php
    LINE: 163
    CALL: dbal->sql_error()

    FILE: phpbb3tobbpress.php
    LINE: 201
    CALL: dbal_mysqli->sql_query()
22. • 
    • JLeuze
    • Member

    • Posted 2 years ago #

    I was converting another forum tonight and ran into a MySQL error while running the converter.

    The error had the name of one of the forums in it, and that forum happened to have a contraction in it. I'm not sure how one could edit the script to accommodate apostrophes, but I simply renamed the forum and removed the apostrophe.

    I reran the converter without the apostrophe, and it worked just fine. So if anyone else runs into an error, pay attention to what it is choking on, maybe you can remove some funky characters and sneak around it!
23. • 
    • DennisH
    • Member

    • Posted 2 years ago #

    I got the following error when converting:

    General Error
    SQL ERROR [ mysql4 ]

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

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

    • Posted 2 years ago #

    Also, do all passwords need to be reset afterwards?
25. • 
    • AndrewRH
    • Member

    • Posted 2 years ago #

    Where is the conversion tool these days? The link to the fileserver, in a message just above no longer works. Is the original script (here) still the best one to use, then? Its folder has _phpbb3_pass.php and phpbb3tobbpress.php files in it dated 09/12/2008

    Thanks,

    ~Andrew~
26. • 
    • chandersbs
    • Member

    • Posted 2 years ago #

    I managed to convert from phpbb3.0.5 to bbpress 1.0.1, but user's can't login, their password isn't working anymore. I tried the md5 thingy, but it doesn't seem to help.
27. • 
    • DennisH
    • Member

    • Posted 2 years ago #

    I got the following error when converting:

    General Error
    SQL ERROR [ mysql4 ]

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

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

    I solved this issue. It was the © symbol in some of the posts causing the error.

    Another question: any ideas on redirecting perm links from the old phpbb to bbpress?
28. • 
    • dudenas
    • Member

    • Posted 2 years ago #

    I confirm that after converting from phpbb 3.0.4 to bbpres 1.0.1 the user passwords don`t work anymore..
29. • 
    • unholyfruitbat
    • Member

    • Posted 2 years ago #

    cloo, were there any errors during your conversion?

    I was going to attempt 3.0.4 > bbpress 1.0.2 until I saw this :D
30. • 
    • dudenas
    • Member

    • Posted 2 years ago #

    No errors.
    Everything seemed OK, except passwords didn`t work.