Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: just211 on May 09, 2018, 05:46:23 AM

Title: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 09, 2018, 05:46:23 AM
Hi,

after reading tons of infos related to the issues that I am faced with it's still the case that I fail converting my running phpBB3.0.x - Board to SMF 2.0.15.
Does anyone of of you experts can make it happen?

I have the following situation:


The first problem that I am running into by calling the convert.php is this "Unknown system variable 'SQL_MAX_JOIN_SIZE'"-Topic.
I understood that modifications to the convert.php needs to be done, and I've already tried some other convert.phps getting other error-messages.

-> How can I be sure to use the right file?


Juergen
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: vbgamer45 on May 09, 2018, 12:00:27 PM
I find the most success installing SMF 2.0.12 use that to convert the phpBB then upgrade your SMF version
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 09, 2018, 12:20:42 PM
Thanks, I will give it a try.
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 09, 2018, 12:43:06 PM
Is there a special 2.0.12 converter available, or should I use the 2.0.15 one?
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: vbgamer45 on May 09, 2018, 12:44:42 PM
Use the 2.0.15 one
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 09, 2018, 01:19:32 PM
Received the same error: " Unknown system variable 'SQL_MAX_JOIN_SIZE' "

Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 09, 2018, 03:10:09 PM
Just tried a different convert.php that has been offered in a different post.

The initial error hasn't appeared, now this one occured:

Converting...
Converting posts...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)...The database value you're trying to insert does not exist: from_name

Any idea how to proceed?

Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: vbgamer45 on May 09, 2018, 03:17:16 PM
You may have to add a column in your personal message table called "from_name" and make it varchar.
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 10, 2018, 08:14:45 AM
Quote from: vbgamer45 on May 09, 2018, 03:17:16 PM
...add a column in your personal message table called "from_name" and make it varchar.

"from_name" exists in the smf-table.

(http://up.picr.de/32644470dq.jpg)


Or do you mean in the db which I want to convert (the phpbb one)?
I phpbb there are 4 of them:


In which should I add the column?

BTW: I would not be sad if users loose just some private messages.
Most important is to get the posts.
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: vbgamer45 on May 10, 2018, 10:04:49 AM
Try to run it manually
You might have to add the database name in front of each phpbb_ or smf_ to get the query to work

Insert into smf_personal_messages (id_pm,id_member_from, msgtime, from_name,subject,body)

SELECT
pm.msg_id AS id_pm, pm.author_id AS id_member_from, pm.message_time AS msgtime,
SUBSTRING(uf.username, 1, 255) AS from_name, SUBSTRING(pm.message_subject, 1, 255) AS subject,
SUBSTRING(REPLACE(IF(pm.bbcode_uid = '', pm.message_text, REPLACE(REPLACE(pm.message_text, CONCAT(':1:', pm.bbcode_uid), ''), CONCAT(':', pm.bbcode_uid), '')), '\n', '<br />'), 1, 65534) AS body
FROM phpbb_privmsgs AS pm
LEFT JOIN phpbb_users AS uf ON (uf.user_id = pm.author_id);
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 10, 2018, 02:01:52 PM
Okay, thanks a lot. Going to try it manually tonight.

If it works, how can I pursade the converter to go on after stopping with the mentioned error message?
Do I need to extract the private message conversion (step1) out of the sql-file?
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: vbgamer45 on May 10, 2018, 02:16:44 PM
Yes exactly just edit .sql file and remove that part.
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 11, 2018, 05:11:47 AM
Thanks.

Here's what I did:

- Converter did his job until mentioned error with converting PM (step1)
- Was able to run your SQL manually without error. It integrated 20.509 rows.
- Deleted the sql-conversion codes until PM (step2) out of the sql-file.
- Converter ran to the end without error message and deleted itself.

I was not able to enter the board using the password and set a new one via "forgotten password function".
Unfortunately I do not have admin-rights with my major admin-account.
Seems that there are some posts missing.

Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 11, 2018, 06:47:06 AM
Udate:

Seems that the converter has issues with subforums.
I've reorganized the phpbb board so that there are just categories and forums left and done the procedure again. Think that all posts have been taken...

I also was able to login with my main admin account using may password, but I am still not an administrator.
I'm sure that this can be fixed direct in the table, will use the search again...

Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 11, 2018, 07:05:24 AM
Update II:

Used the php-script offered in this topic (http://www.simplemachines.org/community/index.php?topic=425480) to make me an admin again. Worked well!

Recounted the statistics:

- Number of posts is correct.
- Number of topics is 28 less than in phpbb. Need to check. (?)
- Number of users is 44 more than in phpbb. Need to check. (?)

Need to update to 2.0.15 now.
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: vbgamer45 on May 11, 2018, 09:14:38 AM
Nice. Do you have it working now.
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: just211 on May 11, 2018, 09:25:00 AM
Yes, I think it is working now.

I'll proceed with some testing and will then finally replace the old and dilapidated phpbb.

Thumbs up for your patient help. This is much appreciated!

Juergen 
Title: Re: Issues with converting from phpBB3.0.x to SMF 2.0.15
Post by: gloups on May 24, 2018, 04:08:29 PM
Quote from: just211 on May 09, 2018, 01:19:32 PM
Received the same error: " Unknown system variable 'SQL_MAX_JOIN_SIZE' "

Same error me too.  (SQL_MAX_JOIN_SIZE at step1).