Info
- 132 posts
- 63 voices
- Started 3 years ago by wmnasef
- Latest reply from shooo
- This topic is not resolved
phpbb3 -> bbpress converter
-
- Posted 2 years ago #
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 'em', '0', '1', '646', '6973')' at line 1 [1064]
I'm using phpBB 3.0.4 and bbpress 1.0.2, MySQL 4.1.22
Am I going to have to upgrade MySQL to complete this?
-
- Posted 2 years ago #
Bleh, I found the cause, it was the previously mentioned ' in the forum name or description.
-
- Posted 2 years ago #
I am getting the following 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 's bike', '5', '8', '0', '0')' at line 1 [1064]
SQL
INSERT INTO bb_forums (forum_id , forum_name, forum_desc, forum_parent, forum_order, topics, posts) VALUES ('6', 'Bike of the Month', 'Each month we will showcase a different member's bike', '5', '8', '0', '0')
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()FILE: phpbb3tobbpress.php
LINE: 201
CALL: dbal_mysql->sql_query() -
- Posted 2 years ago #
@willscootforfood - looks like the apostrophe (single quote) was not escaped before trying to insert. Can you explain what you're trying to convert and what script you're using? And what version of bbPress are you going to use?
-
- Posted 2 years ago #
@chrishajer I was converting a PHPBB 3.04 install to a bbPress 1.0 install. I am using the original script in the first post of this topic. Should I be using a different script?
Sorry for the lack of details in my first post. I was trying to keep my 17 month old girl alive another day LOL.
-
You, sir, are a godsend.
I was having so many problems with my modded phpbb3. I had started off with a modded version (NEVER EVER DO THIS!), and it proved to be very unstable and equally insecure (extensive spam). Cookies also failed to work properly. In short, it was a disaster. I tried to revert to a clean install, and I was unable to. Ghost db tables kept breaking the clean installs (the forums can't find x element, or y table, or z style), and so no one new could register, and there were broken links and tabs all over the place. It was a nightmare (which ironically enough kept me from having any because I've hardly had time to sleep trying endlessly to fix these broken forums).
After days and days of trying to transfer the database to a fresh install of phpbb3 (repeating the process over and over and over again), I realized that at the heart of the problem was a horrible architecture (phpbb3), and an utterly failed modification concept (an epic fail - basically the opposite of WP/bbPress plugins). If only there were a way to transfer the database from phpbb3 to bbPress! Maybe bbPress would snuff out all the corrupted db tables that were giving me such grief and corrupting each clean install of phpbb3! Turns out, that is exactly what happened. And it's all thanks to your plugin - which literally saved my site.
The only "problem" area with was with forums that had ' in them (I "" problem because it was so fantastically easy it literally took about 2 minutes). I just renamed each forum to 1, 2, 3, 4 etc, and then changed them back in bbPress! Also, users password were not transferred, but that hardly matters!
Thank you so much! Do you have a PayPal account so I can donate?
-
Hi once again,
could you please give us a hint on non-working passwords? Is it a real issue, or did we do something wrong?
As I see, we dont need to do anything with md5 insecurity for bbpress plugin - its already integrated?
phpbb3 password plugin is autoloaded.
Could it be problems with mysql version? Mine is 4.1.22Thanks in advance,
Justas -
For what it's worth, I don't think the non-working password "issue" is such an issue at all.
All that one has to do is inform their members that they will need to prompt the board for a password reset, and then they can reset their password to whatever they like (including their old password).
It takes all of two minutes for each member to reset their password. Of all the inconveniences associated with switching forums from one architecture to another, this one seems to me to be so minor it is hardly worth mentioning.
-
Sorry, cannot agree.
1. Ive done a little survey, and it showed that often people dont participate in forums only because they have to register, and they don`t like it.
2. Most of my users are not very computer-literate.
3. Also you have to keep an ugly technical sticky post for as long as the last user changes password.
Not so nice imho. -
I suppose. In my case, I'm developing (or rather, redeveloping) a forum for a club, so I don't have to worry about people not re-registering (or just prompting the system for a new password), because their participation in the club (which they pay for) hinges on their forum experience. In your case, I suppose it might be more concerning.
-
It looks like the original poster's link still works Adam:
http://members.lycos.co.uk/wmnkhayal/files/phpbb3tobbpress%20converter.tar.gzMaybe it was a temporary outage?
-
- Posted 2 years ago #
The very, very first link in this thread (where it says download 'here') works:
http://members.lycos.co.uk/wmnkhayal/files/phpbb3tobbpress%20converter.tar.gz
but that's the version without any fixes -
Whoops, my bad - I missed it. The link in the first post still works - reposting it here just in case. (You should still read that first post, though, for the directions...)
-
(Tried to convert phpbb 3.0.5 to bbpress 1.0.2 and got this error:
SQL ERROR [ mysqli ]
Table 'xxx_phpbb.bb_forums' doesn't exist [1146]
An SQL error occurred while fetching this page.
Any way I can fix this? Thanks in advance for any help. )Hi all,
that'swhat i was looking,too. Thank you.
But:
I got the same error as above. I solved it.
I made a new table which i named like the missing file. So it seems to work. But the database has been deleted by half after excecuting the script. I have no idea what to do anymore. Help is needed.
Thank you -
Now, of course, the Big Question is: is it possible to take this newly-converted bbPress forum and get it to integrate nicely w/ a WordPress install? From the poking around that I've done, it seems that people have only had success integrating a brand-new bbPress install, not one with data/history in it.
I'd love to be proven wrong, though... any ideas?
-
- Posted 2 years ago #
Most integration issues I tend to see are related to deep integration, rather than straight forward user integration. I guess it boils down to, does bbPress transfer over existing users to WP's user tables cleanly (or at all) if you integrate it post-install. It would be possible to do manually anyway, since their respective user tables are essentially identical in structure, but bbPress users would have no WordPress meta whatsoever.
-
Thanks, Kawauso... so, any guidelines/instructions about getting bbPress to use the WordPress user tables on a post-install integration? And am I right in assuming that the issues stem from having two databases (since you've got existing forum data, you can't merge the two, right?) ? Sorry if these are newb questions.
Do you know if the ideas on this post would do it? http://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101 — The reason I ask is because it seems like there's a lot of info circulating about how it worked, or might work, under earlier versions of WP & bbP... but it often changes. Now that we're up to 2.8.4 and 1.0.2, is it any different, or more viable? Is it as easy as pointing bbP at WP's user tables, in addition to the "normal" integration steps? (I'm hoping to save myself a few hours of reading, that's all... )
-
adamkayce - It's absolutely possible. :-) I've done it a few times now.
These links are hugely helpful:
http://bbpress.org/forums/topic/integration-of-established-wp-and-bbpress-installations
http://bbpress.org/forums/topic/successful-reverse-integration-stepsThe hardest part of the integration is how to handle "name collisions"... i.e. what do you do when two users share the same usernames in bbPress (from phpbb3) and WordPress. That's discussed nicely in the above links.
Good luck!
-
Thanks @johnhiler - definitely fills in the puzzle a little.
A couple questions:
- Any thoughts about using more recent builds than 2.7.1 & 0.9?
- One difference I'm seeing with my situation is that it's WP's users we need to bring into bbPress, not the other way around. The WP setup is a membership site, handled with the Wishlist Member plugin, so they'll be logging in there first.
Ugh... I'm realizing I've got a bucket full of ugliness here... from the fact that there are going to be bbPress users (old, inactive ones) who aren't in WP, trying to match up the WP users with the bbPress users, and the whole "logged into WP/logged out of bbPress" issue, since it looks like I may not be able to have shared cookies since I'm working with new versions of both software packages...
... this may be more than is possible right now. I'll keep trying to figure it out, though. Thanks for your help, everyone.
-
No, but I wouldn't recommend using more recent builds of bbPress... since a lot of plugins aren't supported in 1.0 yet. Unless of course, you don't plan on using many plugins... then ymmv.
You can get user integration (complete with cookie support) between just about any two versions of bbPress and WordPress. Start a new thread with your questions around that, and we can all chip in and advise!
-
Wow, I've been at this for like 12 hours straight now...
The conversion of phpBB3 › bbPress seems to work, but it leaves me with no users in the bb_users tables. Is that normal?
Problem is, I have no idea what to do about it. I've tried importing into 0.9, and while it looked like it worked, I can't get admin access, since it didn't make me a user. I also tried importing into 1.0, but that looks even worse - on the forum index page, it doesn't even show author's names for the posts.
Either way, I can't get Admin access to the forum, which makes the rest of anything (integrating, upgrading, etc.) impossible.
Help?
-
A little clarification: it seems like the converter is working, because when I go to the forum index, I see a whole ton of posts. But when I try to click into a topic, there are no posts in it.
When I run the converter, it goes through a few steps, but on the screen where it's processing posts, it ends with a blank screen. No "success" message. Is that normal, or is it getting hung up somewhere?
(I've seen error messages, and I rectified those, so I recognize that difference, at least.)
-
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
