[@sharingsunshine_wp Participant 9 years, 4 months ago]

thanks, that will be great

[@sharingsunshine_wp Participant 9 years, 4 months ago]

I have ran the conversion many times and this last time I created an all new smf install using a copy of the existing database. This causes the smf board I am converting from to be in a default condition with no mods or plugins. So I thought this could be the cleanest way to import the board.

However, I am still having the same issues many replies and topics are being left off. After the conversion I ran all the applicable repair tools in the importer but still no change.

Do you have any other suggestions?

[@sharingsunshine_wp Participant 9 years, 4 months ago]

I tried again and it did complete but I have the same problem in that there are replies missing and topics missing.

In this conversion I turned off all plugins except for the two bbPress plugins.

[@sharingsunshine_wp Participant 9 years, 4 months ago]

I meant on mods the mods on the smf forum. I am on a genesis framework and there is a plugin for bbPress and the genesis framework would that be necessary to activate when doing the import?

So to recap my questions do I need to any of the following before converting?

1. inactivate all but bbPress and bbPress genesis framework plugin

2. inactivate only bbPress plugin

3. remove all mods from the smf forum before converting

Thanks,

[@sharingsunshine_wp Participant 9 years, 4 months ago]

I deactivated all the plugins and now I am getting this error

WordPress database error: [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 'groups_table.forum_id = forums_table.forum_id LIMIT 0, 100' at line 1]
SELECT convert(forums_table.the_forum_id USING "utf8mb4") AS the_forum_id,convert(forums_table.the_parent_id USING "utf8mb4") AS the_parent_id,convert(forums_table.the_topic_count USING "utf8mb4") AS the_topic_count,convert(forums_table.the_reply_count USING "utf8mb4") AS the_reply_count,convert(forums_table.the_total_topic_count USING "utf8mb4") AS the_total_topic_count,convert(forums_table.the_total_reply_count USING "utf8mb4") AS the_total_reply_count,convert(forums_table.the_forum_title USING "utf8mb4") AS the_forum_title,convert(forums_table.the_forum_slug USING "utf8mb4") AS the_forum_slug,convert(forums_table.the_forum_description USING "utf8mb4") AS the_forum_description,convert(forums_table.the_forum_order USING "utf8mb4") AS the_forum_order,convert(groups_table.forum_id USING "utf8mb4") AS forum_id FROM smf_forums_table AS forums_table INNER JOIN smf_groups_table AS groups_table USING groups_table.forum_id = forums_table.forum_id LIMIT 0, 100

I made sure I am using your revision of code. I only have the bbPress plugin activated and I put the site in maintenance mode via .htaccess

Thanks for helping me with this.

Randal

[@sharingsunshine_wp Participant 9 years, 4 months ago]

So you are saying to deactivate the plugins that are in WordPress?

[@sharingsunshine_wp Participant 9 years, 4 months ago]

Thanks for the code. I ran through the converter and this time it shows the correct topics and reply count until you actually look into each topic. All the topics I have checked are missing replies.

The user count is still double even though I checked purge and it said no cleanup necessary.

Looks like we are much closer so thanks for getting us there.

Do I need to do anything to the forum to make it ready? I do have some mods on it do they need to be removed? I didn’t see anywhere saying to remove them so thought I would ask.

[@sharingsunshine_wp Participant 9 years, 4 months ago]

I tried to find the code to actually see what is wrong with the sql statement. I followed these directions thinking the smf importer would be close by.

************
You can also make your own custom importer using the included Example.php located in /bbpress/includes/admin/converters/Example.php to setup an import from any SQL database.

However, I don’t have a /bbpress folder at the root is it in another subfolder? Or, has it been changed since this page was created?

Thanks,

Randal

[@sharingsunshine_wp Participant 9 years, 4 months ago]

Thanks for approving the post and I certainly will heed the links minimum from now on. I upgraded the later version and now I am getting this error.

Repair any missing information: Continue

WordPress database error: [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 'users_profile_table.the_user_id = users_table.the_user_id WHERE users_table.the_' at line 1]
SELECT convert(users_table.the_users_id USING "utf8mb4") AS the_users_id,convert(users_table.the_users_password USING "utf8mb4") AS the_users_password,convert(users_table.the_users_password_salt USING "utf8mb4") AS the_users_password_salt,convert(users_table.the_users_username USING "utf8mb4") AS the_users_username,convert(users_table.the_users_nicename USING "utf8mb4") AS the_users_nicename,convert(users_table.the_users_email_address USING "utf8mb4") AS the_users_email_address,convert(users_table.the_users_homepage_url USING "utf8mb4") AS the_users_homepage_url,convert(users_table.the_users_registration_date USING "utf8mb4") AS the_users_registration_date,convert(users_table.the_users_status USING "utf8mb4") AS the_users_status,convert(users_table.the_users_display_name USING "utf8mb4") AS the_users_display_name,convert(users_table.the_users_aim USING "utf8mb4") AS the_users_aim,convert(users_table.the_users_yahoo USING "utf8mb4") AS the_users_yahoo,convert(users_table.the_users_jabber USING "utf8mb4") AS the_users_jabber,convert(users_profile_table.the_users_id USING "utf8mb4") AS the_users_id FROM smf_users_table AS users_table INNER JOIN smf_users_profile_table AS users_profile_table USING users_profile_table.the_user_id = users_table.the_user_id WHERE users_table.the_user_id != -1 LIMIT 0, 100

[@sharingsunshine_wp Participant 9 years, 4 months ago]

Hello,

I have been wanting to switch to bbPress from SMF 2.0.9. I ran the importer and all looked well until I compared the number of topics in various forums and found the bbPress import is about 1/2.

Here is a screenshot of the smf url and the topics and posts in the first 3 forums on the smf installation.
https://gyazo.com/674a5fac9b459cd9a111fce3fb37fdda

Here is a screenshot of the topics and replies on the bbPress forum conversion I just did.
https://gyazo.com/a1356951215c6e98659895499ee4283a

It also seems to have doubled the users – here is a screenshot from the smf forum
https://gyazo.com/0fd7722d0f632dc4bc1a843be09893a1

Here is a screenshot from the bbPress convert
https://gyazo.com/c88588a0d4ee4095d6f6eafe5310925b

I did a complete reset of the forum before the convert. If you need to see the bbPress forum it can be found at http://www.thefrugallife.com/forums

Please tell me how to fix these issues so I can start using the bbPress forum instead of smf.

Thanks,

Randal

[@sharingsunshine_wp Participant 9 years, 4 months ago]

I went through the topic link you gave me and Stephen never mentioned anything that I wasn’t doing.

My last trial that I mentioned in the post that had too many links was with smf to bbPress direct and it still failed.

Should I post two messages to divide up the links so Stephen can try to help me on this? Considering that the topic that never got posted had 4 links.

Thanks for being a big help to me on at least having some contact.

[@sharingsunshine_wp Participant 9 years, 4 months ago]

Thankyou, that would be great initially I was just going to change the subject to “My Topic Isn’t Showing In The Installation Forum.” Because after reading my initial subject it sounded like I was talking about my own forum having this problem.

Now that you have answered the topic it doesn’t matter anymore.

However, is there some way you can edit my smf post so I can get some help with the problem? I need to get this switched over.

Thanks,

Randal

[@sharingsunshine_wp Participant 9 years, 4 months ago]

Yes, that is the link. I tried to edit another post and it said I couldn’t. So what should I do?

[@sharingsunshine_wp Participant 9 years, 7 months ago]

I found the problem and it was really my fault.

1. I had a password that included a character that needed to be escaped. In my case I had a ‘ in a similar manner as this. Not a real password that we use aVgt’67A. Wnen I changed it to a password that was characters and numbers it worked fine.

2. When it asked for the table name I left off the underscore. So I put down phpbb instead of phpbb_.

I hope this will help someone else if they have a similar problem.

[@sharingsunshine_wp Participant 9 years, 7 months ago]

can this be done with an interim phpBB 3 step? Please tell me something I can try.

Thanks,

[@sharingsunshine_wp Participant 9 years, 7 months ago]

Is there anyplace I can see an error message that might help me to diagnose the problem?

[@sharingsunshine_wp Participant 9 years, 7 months ago]

I am not sure if this will help or not since nothing was imported but the url is http://www.thefrugallife.com and the smf forum is located at http://www.thefrugallife.com/smf