News:

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

Main Menu

I need a little help to move to SMF ! (sql backup to smf)

Started by dawnrazor45, February 08, 2016, 11:42:24 AM

Previous topic - Next topic

dawnrazor45

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 !!



margarett

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 )
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

dawnrazor45

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



and then run the localhost/smf/convert.php  and fill the options in this way




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



Illori

you need to upload the database into phpmyadmin, without doing that the sql.gz file you have is worthless.

dawnrazor45

err ok, I created a database and imported the sql.gz file into the new database, so how I can continue now ?

margarett

Yup :)
Just remember to correct the database details in that file ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

dawnrazor45

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 ?

margarett

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.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

dawnrazor45

#8
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


margarett

Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

dawnrazor45

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 [nofollow]_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'

:(

margarett

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,
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

dawnrazor45

#12
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 [nofollow]_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 [nofollow]_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 [nofollow]_id' at line 6
Try again


which  is correctly edited?  the first one ?

dawnrazor45

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 ?

margarett

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)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

dawnrazor45

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  :-[ 

margarett

Well, we can try to go error by error until it eventually works. Eventually...

Dang, I really need to put that converter out :(
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

dawnrazor45

I will wait ! , my dear forum is 8 years old, I prefer to wait to do this thing the most correctly possible  :)

dawnrazor45

Hi, any news about converting from phpbb 3.1.7-pl1 to smf ??????
thanks


Advertisement: