Advertisement:

Author Topic: I need a little help to move to SMF ! (sql backup to smf)  (Read 11022 times)

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
I need a little help to move to SMF ! (sql backup to smf)
« on: February 08, 2016, 11:42:24 AM »
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 !!



Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #1 on: February 08, 2016, 12:17:57 PM »
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:
Code: [Select]
<?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

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

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #2 on: February 08, 2016, 02:04:37 PM »
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



Quote
Sorry, 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



Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,084
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #3 on: February 08, 2016, 02:18:38 PM »
you need to upload the database into phpmyadmin, without doing that the sql.gz file you have is worthless.

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #4 on: February 08, 2016, 02:59:24 PM »
err ok, I created a database and imported the sql.gz file into the new database, so how I can continue now ?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #5 on: February 08, 2016, 05:40:39 PM »
Yup :)
Just remember to correct the database details in that file ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #6 on: February 08, 2016, 06:03:23 PM »
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 ?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #7 on: February 08, 2016, 08:17:16 PM »
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

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

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #8 on: February 09, 2016, 03:04:41 AM »
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,,,,,,,

Quote
Unknown system variable 'SQL_MAX_JOIN_SIZE'

 :(

now which can be the problem ???

thanks

« Last Edit: February 09, 2016, 03:38:03 AM by dawnrazor45 »

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #9 on: February 09, 2016, 07:24:52 AM »
Use the attached instead
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #10 on: February 09, 2016, 07:58:11 AM »
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'

 :(

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #11 on: February 09, 2016, 09:02:16 AM »
Well, that should be the "Location" field in phpBB's database... You can just ignore that field...
Edit the .sql file, find:
Code: [Select]
SUBSTRING(u.user_from, 1, 255) AS location,Replace with
Code: [Select]
'' AS location,
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #12 on: February 09, 2016, 09:28:24 AM »
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 ?
« Last Edit: February 09, 2016, 10:05:18 AM by dawnrazor45 »

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #13 on: February 09, 2016, 11:12:49 PM »
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 ?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #14 on: February 10, 2016, 04:15:28 AM »
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
Code: [Select]
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

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

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #15 on: February 10, 2016, 04:51:44 AM »
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  :-[ 

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #16 on: February 10, 2016, 04:54:13 AM »
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

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

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #17 on: February 10, 2016, 04:58:45 AM »
I will wait ! , my dear forum is 8 years old, I prefer to wait to do this thing the most correctly possible  :)

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #18 on: May 27, 2016, 02:46:21 AM »
Hi, any news about converting from phpbb 3.1.7-pl1 to smf ??????
thanks

Offline dawnrazor45

  • Semi-Newbie
  • *
  • Posts: 13
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #19 on: June 10, 2016, 02:17:29 AM »
err... no news?  :(

Offline bpratt

  • Semi-Newbie
  • *
  • Posts: 40
Re: I need a little help to move to SMF ! (sql backup to smf)
« Reply #20 on: November 06, 2016, 01:55:37 AM »
any news on this conversion to smf ?