Hi ! well, im a user of phpbb 2, but the free server where I had my forum now is closed, so I move to my own server and install the forum again but this time with phpbb3..... but I´m not satisfied with phpbb3, and the support is bad for newbies like me , then I install SMF in my wamp server and really like it, but I need to try it more time, so question is , can I make a backup and use this sql file to install a copy of my forum in smf (installed in my wamp server for testing)?
I have downloading a converter from phpbb3, but someone can tell me if there is a guide to do this or explain me the steps to do this?
thanks !!
Hi and welcome ;)
Yes, you can. Just import your phpBB3 database to WAMP and then create a "dummy" config.php that contains the database info (mainly db name and tables prefix), eg:
<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '3306';
$dbname = 'phpbb';
$dbuser = 'root';
$dbpasswd = '';
$table_prefix = 'phpbb_';
?>
Then point the converter to the location of this file and it should work. Of course you won't get any files (because you don't have them :P )
well, It doesn't work, I tell you what I have done:
download and install smf_2-0-11_install.zip with smf_2-0-11_spanish_latin.zip , this works well.
then in same folder than I installed SMF I extract smf_2-0_phpbb3_converter.zip
now in another folder (folder "y") I put the sql.gz (backup from cpanel) and the file created according to your explication
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fs22.postimg.org%2Fy2s47ro81%2F111.jpg&hash=62f35e9d677272dbf9b29da614fb7bbb798598ee)
and then run the localhost/smf/convert.php and fill the options in this way
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fs15.postimg.org%2Fei85ztx3f%2FScreen_00003.jpg&hash=8b5e0967f6367246974c481e7f8ce95f66afcc2c)
when I push "continue".... this message error appear
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB3. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: Table 'kalkin_kalkin.kalk3_users' doesn't exist
you need to upload the database into phpmyadmin, without doing that the sql.gz file you have is worthless.
err ok, I created a database and imported the sql.gz file into the new database, so how I can continue now ?
Yup :)
Just remember to correct the database details in that file ;)
please can tell me what details should I Correct , because i'm a bit confused now.. I import the sql file to a database, its ok ?
You import the sql file to a database in your phpmyadmin. Right. Let's say you named that database "phpbb"
So you need to go to the file you created before (c:\wamp\www\y\config.php) and adapt the database name accordingly.
yes, I have used bigdump.php and import my sql to a new database
and in config.php I have edited the file, with the database name than I created, the table prefix , the user and the password than I created in phpmyadmin , but when I run convert.php,,,,,,,
QuoteUnknown system variable 'SQL_MAX_JOIN_SIZE'
:(
now which can be the problem ???
thanks
Use the attached instead
this is the error now:
Converting...
Converting members...
Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.username, 1, 80) AS member_name,
SUBSTRING(u.username, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
u.user_regdate AS date_registered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts,
CASE
WHEN (u.group_id = 15 OR u.group_id = 8) THEN 1
WHEN (u.group_id = 10) THEN 2
ELSE 0
END AS id_group,
u.user_new_privmsg AS instant_messages,
SUBSTRING(u.user_email, 1, 255) AS email_address,
u.user_unread_privmsg AS unread_messages,
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 website_title,
SUBSTRING(u.user_website, 1, 255) AS website_url,
u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
IF(u.user_allow_viewemail = 1, 0, 1) AS hide_email, 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,
CASE u.user_inactive_reason WHEN 0 THEN 1 ELSE 0 END AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle, u.user_ip AS member_ip,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS password_salt,
u.user_ip AS member_ip2
FROM `kalkin`.kalk3_users AS u
ORDER BY u.user_id
LIMIT 0, 500;
Caused the error:
Unknown column 'u.user_from' in 'field list'
:(
Well, that should be the "Location" field in phpBB's database... You can just ignore that field...
Edit the .sql file, find:
SUBSTRING(u.user_from, 1, 255) AS location,
Replace with
'' AS location,
I edited phpbb3_to_smf.sql ,now the error is :
replace SUBSTRING(u.user_from, 1, 255) AS location, with '' AS location,
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.username, 1, 80) AS member_name,
SUBSTRING(u.username, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
u.user_regdate AS date_registered,
'' AS location,
u.user_posts AS posts,
CASE
WHEN (u.group_id = 15 OR u.group_id = 8) THEN 1
WHEN (u.group_id = 10) THEN 2
ELSE 0
END AS id_group,
u.user_new_privmsg AS instant_messages,
SUBSTRING(u.user_email, 1, 255) AS email_address,
u.user_unread_privmsg AS unread_messages,
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 website_title,
SUBSTRING(u.user_website, 1, 255) AS website_url,
u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
IF(u.user_allow_viewemail = 1, 0, 1) AS hide_email, 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,
CASE u.user_inactive_reason WHEN 0 THEN 1 ELSE 0 END AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle, u.user_ip AS member_ip,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS password_salt,
u.user_ip AS member_ip2
FROM `kalkin`.kalk3_users AS u
ORDER BY u.user_id
LIMIT 0, 500;
Caused the error:
Unknown column 'u.user_msnm' in 'field list'
Try again
and second SUBSTRING(u.user_from, 1, 255) AS location, replace with SUBSTRING '' AS location,
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.username, 1, 80) AS member_name,
SUBSTRING(u.username, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
u.user_regdate AS date_registered,
SUBSTRING '' AS location,
u.user_posts AS posts,
CASE
WHEN (u.group_id = 15 OR u.group_id = 8) THEN 1
WHEN (u.group_id = 10) THEN 2
ELSE 0
END AS id_group,
u.user_new_privmsg AS instant_messages,
SUBSTRING(u.user_email, 1, 255) AS email_address,
u.user_unread_privmsg AS unread_messages,
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 website_title,
SUBSTRING(u.user_website, 1, 255) AS website_url,
u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
IF(u.user_allow_viewemail = 1, 0, 1) AS hide_email, 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,
CASE u.user_inactive_reason WHEN 0 THEN 1 ELSE 0 END AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle, u.user_ip AS member_ip,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS password_salt,
u.user_ip AS member_ip2
FROM `kalkin`.kalk3_users AS u
ORDER BY u.user_id
LIMIT 0, 500;
Caused the 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 'AS location,
u.user_posts AS posts,
CASE
WHEN (u.group_id = 15 OR u.group_id' at line 6
Try again
which is correctly edited? the first one ?
I see, in the second case a syntax error is displayed, so the first one must be correct.
the problem is something about my forum database or is a issue with the converter ?
No, you should use the first one. The error it triggers becomes different, which means that's another field in trouble.
Your database it's kinda odd... It doesn't have fields which are expected in the members table of phpBB
Delete the line
SUBSTRING(u.user_msnm, 1, 255) AS msn,
That should allow you to skip that error.
Did you use phpBB 3.1? Because the converter is not ready for that version yet (which might explain the errors we're seeing)
Hi margarett
oh sorry, I forgot to tell you the version, yes..... is phpbb 3.1.7-pl1... so I must wait then for a proper converter ? :(
when I saw Phpbb3 to SMF 2.0 I assumed then 3.1 can be converted too :-[ (https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Favatars.simplemachinesweb.com%2Fsmf%2Favatar_41895_1262098631.png&hash=c8d0220b411fcdd4186ac26904a526014abce52b)
Well, we can try to go error by error until it eventually works. Eventually...
Dang, I really need to put that converter out :(
I will wait ! , my dear forum is 8 years old, I prefer to wait to do this thing the most correctly possible :)
Hi, any news about converting from phpbb 3.1.7-pl1 to smf ??????
thanks
err... no news? :(
any news on this conversion to smf ?