News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

ThorstenE

try
for SMF: /hermes/bosweb/web166/b1663/d5.XXXXXXX/public_html/smf
for phpBB: /hermes/bosweb/web166/b1663/d5.XXXXXXX/public_html/forum

GreySkull-1

Tried this...didn't work.

I actually have the phpBB forum under "phpBB" not "forum".

I've tried the combination
/home/users/web/b1663/d5.XXXXXXX/public_html/smf
/home/users/web/b1663/d5.XXXXXXX/public_html/phpBB

also, with no success.

At wits end here.



ThorstenE

place convert.php and phpbb2_to_smf.sql in your SMF directory, the path for SMF is automatically detected then. change the last part for phpbb ( to phpBB)
If this doesn't help please post a link to both forums (or PM me)

GreySkull-1

Got it going...only thing wrong was I needed to check utf-8 instead of the default that was checked.

Thanks for your help.

flamechica

QuoteConverting ranks... Unsuccessful!
This query:

    DELETE FROM `rsdlaugh_testing`.rsdlaugh_membergroups
    WHERE groupName LIKE 'phpBB %';

Caused the error:

    Unknown column 'groupName' in 'where clause'

This is the error I got when I ran the covert.php file. Please help!

ThorstenE

flamechica, our converters are for SMF 1.1.x only at this time. The error sounds like you are using SMF 2.0 Beta4 for the destination?

Tarzan1

Hi,

I'm trying to convert phpBB 2.0.23 to SMF 1.1.7 and ran the converter as directed (both specified files are in the SMF directory). The first time I ran the converter, it showed a very long list of error messages, but at the end it said that I had successfully transfered all my files and offered a link to my new forum. This all happened almost instantly... no waiting. When I went to the forum, it was unchanged and had only one user (me).

I tried once more to run the converter, and it said I had the wrong password and I should check some file. I did that and saw that special characters had been stripped off the password. ??? So I entered the new password and it ran again, giving me another long list of errors, but said the process was successful again! So I again went to look and now it says that there is a connection error and I should try again later as the server could be busy. SMF could not connect to the database! Is this because it is trying to access the database with an incorrect password (stripped of the special characters)? 

What do I do now?
When you change the way you look at things, the things you see are different.

ThorstenE

Quote from: Tarzan1 on January 24, 2009, 09:24:32 PM
Is this because it is trying to access the database with an incorrect password (stripped of the special characters)? 
This may be the reason. Are both forums installed in the same database? (same MySQL user and password)?

Tarzan1

Quote from: TE on January 25, 2009, 02:11:42 AM
Quote from: Tarzan1 on January 24, 2009, 09:24:32 PM
Is this because it is trying to access the database with an incorrect password (stripped of the special characters)? 
This may be the reason. Are both forums installed in the same database? (same MySQL user and password)?

Both databases use the same password and user name, are on the same server, but are not a combined database. I copied and pasted the complete report produced by the conversion script into a wordpad document (text file). I can send that to you if it would help.
And thanks so very much for your quick reply... I didn't expect one until tomorrow! This is great. I hope I can get this problem solved before the weekend is over.
When you change the way you look at things, the things you see are different.

ThorstenE

yes, the errors may help me in finding the issue.. can you upload the file and PM me the link to it?
Is there an html special char (sinle quote or quotes) inside your password? this may result in an error..

Tarzan1

Quote from: TE on January 25, 2009, 08:52:59 AM
yes, the errors may help me in finding the issue.. can you upload the file and PM me the link to it?
Is there an html special char (sinle quote or quotes) inside your password? this may result in an error..
I sent you a PM, but for the benefit of others, I will mention here that there are no quotes ( single or double) in the password.
Speaking of passwords: Is it not dangerous to have an un-encrypted password stored in a file on the server? Especially when there is a utility in SMF that allows one to easily change all files to permission 777?

viel Dank
When you change the way you look at things, the things you see are different.

ThorstenE

Ok, received your PM.. it looks like a broken php session (host related error) for me..
look here: http://www.simplemachines.org/community/index.php?topic=276243.msg1811393#msg1811393 (your error is very similar)

Can you PM me a link to both forums and your MySQL password? I would like to try this myself.

Tarzan1

#612
Thanks to TE, who pointed me in the right direction, I discovered that the username and password that I thought was being used for phpBB was in fact not the correct ones. The phpBB database has several 'users' and I incorrectly assumed the MAIN user was the one that phpBB would be using. This was NOT the case, so of course the conversion failed!
LESSON TO BE LEARNED: Don't assume. CHECK to be sure. Find out where to look for your information in your particular forum software. (It will be in a settings or configuration file).

Now I have created a new problem where I get a duplicate key error. When that gets resolved, I will post my discoveries for others to learn from my mistakes.
:-[
I wonder if the problem (linked to) in the post above (who got similar error messages to mine) might be a similar situation?
When you change the way you look at things, the things you see are different.

Tarzan1

It seems the duplicate key entry was from clicking on the CONTINUE button.
Even though the instructions on the page say to click the button, TE told me NOT TO (THAT IT WOULD CONTINUE ON ITS OWN IN A FEW SECONDS). It did, and the transfer seems to have taken place. Woo hoo! I think I have myself a new forum!

Many thanks to TE.

:D :D :D :D :D :D :D
When you change the way you look at things, the things you see are different.

ThorstenE


NyorexDC

OMG... it worked just fine =D , thanx

jhorland

I've recently converted an phpBB to an SMF forum (1.1.8), eerything translated except the smilies and attachments...

is there some way for me to go back and re-attach old attachments with MySQL? is there a step anyone suspects I skipped?


Jeremy

ThorstenE

attachments isn't a default phpBB2 feature, so our converter doesn't convert attachments.
this should help you:

http://www.simplemachines.org/community/index.php?topic=258735.msg1686035#msg1686035
this is an attachments only converter and can be used with convert.php.
delete your old phpbb2_to_smf.sql and upload this file and convert.php.

then start the conversion.

digitalbh

Hi folks,
Im new to SMF to, trying to convert my phpbb2 to SMF but I get this error,
--------------------------------------------
Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
    SUBSTRING(u.username, 1, 255) AS realName,
    SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
    u.user_regdate AS dateRegistered,
    SUBSTRING(u.user_from, 1, 255) AS location,
    u.user_posts AS posts, IF(u.user_level = 1, 1, hxxp:mg.id [nonactive]_GROUP) AS ID_GROUP,
    u.user_new_privmsg AS instantMessages,
    SUBSTRING(u.user_email, 1, 255) AS emailAddress,
    u.user_unread_privmsg AS unreadMessages,
    SUBSTRING(u.user_msnm, 1, 255) AS MSN,
    SUBSTRING(u.user_aim, 1, 16) AS AIM,
    SUBSTRING(u.user_icq, 1, 255) AS ICQ,
    SUBSTRING(u.user_yim, 1, 32) AS YIM,
    SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
    SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
    u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
    IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
    REPLACE(u.user_sig, '\n', '<br />') AS signature,
    u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
    u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS usertitle,
    '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
    '' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
    '' AS memberIP, '' AS memberIP2
    FROM `denish_optibox`.phpbb_users AS u
    LEFT JOIN `denish_optibox`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `denish_forumbaza23`.smf_membergroups AS mg ON (mg.groupName = CONCAT('phpBB ', r.rank_title))
    WHERE u.user_id != -1
    GROUP BY u.user_id
    LIMIT 0, 500;

Caused the error:

    Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
---------------------------------------------

and what should i do with this file: phpbb2_to_smf.sql, no clue?

ThorstenE

both forums use diffrerent table collations ins MySQL
Please try this:
Re-Install SMF and enable the checkbox for UTF-8 during install. then in convert.php you should also use "UTF-8" as the character set. Convert.php is our general converter file, the phpbb2_to_smf.sql contains all commands for a phpbb2 conversion and is used from convert.php.

Advertisement: