Simple Machines Community Forum

SMF Support => Converting to SMF => MyBB => Topic started by: purity on October 23, 2009, 02:34:31 PM

Title: Need help With Moving from MYBB to SMF
Post by: purity on October 23, 2009, 02:34:31 PM
hi evryone i want to move software from, myBB  1.4.9 to the latest version of SMF, my primery reason for wanting to move is i have an sql error in mybb-sent messages script which the myBB comunity are refusing to help me fix the problem, so i want to convert to smf can some one guide me thought the proccess of convertion as i couldent seem to find a converter that would convert the mybb forum soft.

also i need the final finished forum to point to the root of my url insted of /forum how do i do that
Title: Re: Need help With Moving from MYBB to SMF
Post by: Dragooon on October 23, 2009, 02:44:16 PM
Hello and thanks for choosing SMF for your community software.

Please read : Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject) and MyBB converter can be found at [SMF Converter] MyBB 1.4 (http://www.simplemachines.org/community/index.php?topic=256073.0). Also see Looking to convert to SMF? (http://www.simplemachines.org/community/index.php?topic=273509.0) in order to know more.

Also, in order to have the forum at root you just have to upload SMF's files at the root, not at a folder called forum in your public HTML/www root folder
Title: Re: Need help With Moving from MYBB to SMF
Post by: purity on October 23, 2009, 02:47:15 PM
i thought that in order for me to convert i had to keep the my bb files on the server
Title: Re: Need help With Moving from MYBB to SMF
Post by: Norv on October 23, 2009, 03:29:59 PM
It's not really necessary to have all the files from MyBB still on server (but it doesn't hurt either). What you need is to still have the entire MyBB database, and also some configuration file (and all attachments, avatars etc, don't delete them). It might seem easier if you keep the MyBB files for now, anyway. The converter will ask you where MyBB is installed, and also where SMF is installed.

Why are you wondering about removing MyBB anyway?
Title: Re: Need help With Moving from MYBB to SMF
Post by: purity on October 23, 2009, 03:57:52 PM
which config files do i need to keep?, im removing mybb because it wil nolonger be needed
Title: Re: Need help With Moving from MYBB to SMF
Post by: Norv on October 23, 2009, 04:14:01 PM
You can also remove them after the conversion is finished successfully and you're sure nothing is needed.
I strongly advice to make a backup of all the files before removing them anyway.

In any case, the converter needs the file your_MyBB_directory/inc/config.php. In case your attachments, avatars, any other personal files are on disk, you need to keep them too, otherwise they would be lost.
Title: Re: Need help With Moving from MYBB to SMF
Post by: purity on October 24, 2009, 06:52:25 AM
ok i got evrything installed but i get the following errors when converting


Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting topic view logs... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1256381293),
    ("conversion_from", "mybb14x_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1256381293)' at line 1


Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1256381301),
    ("conversion_from", "mybb14x_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1256381301)' at line 1


Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1256381397),
    ("conversion_from", "mybb14x_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1256381397)' at line 1


it seems to have copied some of the data but not all of it i tried the .sql file without the binary but it refused to work for me so i am using the .sql file with binary

is there a fix for this?
Title: Re: Need help With Moving from MYBB to SMF
Post by: Norv on October 24, 2009, 08:23:52 AM
Please ignore that error, it is actually caused by a bug in a converter itself. It will disappear next time the converters are updated on the Downloads page.

Your conversion has actually succeeded, the last step that matters was :
Quote
Recalculating forum statistics... Successful.

Quote from: purity on October 24, 2009, 06:52:25 AM
it seems to have copied some of the data but not all of it i tried the .sql file without the binary but it refused to work for me so i am using the .sql file with binary
What do you mean by "trying the .sql file without the binary"?
Title: Re: Need help With Moving from MYBB to SMF
Post by: purity on October 24, 2009, 08:50:29 AM
in this thread
http://www.simplemachines.org/community/index.php?topic=256073.0

sleepy posted this
Quote

Try the file I attached above in my previous post. It doesn't have the BINARY in the query that sometimes causes this.

so the convertion sucseeded thats good news i can just delete the convert.php file now?
Title: Re: Need help With Moving from MYBB to SMF
Post by: Norv on October 24, 2009, 09:16:19 AM
Quote from: purity on October 24, 2009, 08:50:29 AM
so the convertion sucseeded thats good news i can just delete the convert.php file now?

Sure thing. You can surely browse around and see if everything is converted, like attachments are in place, or topics work. Please feel free to let us know in case of problems.
Title: Re: Need help With Moving from MYBB to SMF
Post by: purity on October 24, 2009, 09:52:25 AM
i cant seem to change my comunity name from the default one i did change it when i ran the installer script
Title: Re: Need help With Moving from MYBB to SMF
Post by: Dragooon on October 24, 2009, 09:55:15 AM
It should be under Admin -> Server settings > General(Default area).
Title: Re: Need help With Moving from MYBB to SMF
Post by: Norv on October 24, 2009, 10:19:53 AM
Marking this topic as solved, however please feel free to reopen it anytime in case there are more conversion issues.

For the rest, enjoy your new forum software, and if you may need assistance, please see the Support forums (http://www.simplemachines.org/community/index.php?board=9.0) as well. Welcome to SMF! :)