Simple Machines Community Forum

SMF Support => Converting to SMF => MyBB => Topic started by: Nibogo on October 10, 2010, 11:43:34 AM

Title: [SMF Converter] MyBB 1.6
Post by: Nibogo on October 10, 2010, 11:43:34 AM
Software: MyBB
Version: 1.6

This is the official support topic for MyBB 1.6 converter.  Use this topic to ask for support for this converter.

Note: This was tested on MyBB 1.6, but should in theory work on newer versions of MyBB if the database changes have not been to great.

Changelog

convert.php
The convert.php is attached in each package.
Title: Re: [SMF Converter] MyBB 1.6
Post by: chaitu_cheat on October 27, 2010, 05:44:04 AM
I am getting following error while converting:

Code: [Select]
Converting moderators...
Unsuccessful!
This query:

    SELECT id AS id_member, fid AS id_board
    FROM `asliind1_mybb`.mybb_moderators
    WHERE isgroup = 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'id' in 'field list'
Title: Re: [SMF Converter] MyBB 1.6
Post by: Nibogo on October 27, 2010, 08:13:06 AM
Try opening the .sql file and search for:

Code: [Select]
SELECT id AS id_member, fid AS id_board
Replace with:

Code: [Select]
SELECT uid AS id_member, fid AS id_board
Title: Re: [SMF Converter] MyBB 1.6
Post by: chaitu_cheat on October 27, 2010, 12:15:09 PM
Thanks mayte..Now the following error:  :-[

Code: [Select]
Converting moderators...
Unsuccessful!
This query:

    SELECT uid AS id_member, fid AS id_board
    FROM `asliind1_mybb`.mybb_moderators
    WHERE isgroup = 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'isgroup' in 'where clause'
Title: Re: [SMF Converter] MyBB 1.6
Post by: Nibogo on October 27, 2010, 12:47:49 PM
Are you sure you're using MyBB 1.6? Those rows were added in that version. Please try to upgrade.
Title: Re: [SMF Converter] MyBB 1.6
Post by: chaitu_cheat on October 27, 2010, 12:52:27 PM
Sorry Red...!! I As you rightly mentioned..I was using the wrong sql file...Now I got it all right..converted everything successfully but only one thing not working.

FYI,

www.asli-indian.com is my old forum it has around 87 members.

www.asli-indian.com/forum is my converted forum but not showing stats properly. Though all the members are there in the member list of admin panel.

Code: [Select]
Forum Stats Forum Stats

1 Posts in 1 Topics by 1 Members. Latest Member: chaitanya_gk
Latest Post: "RE: Forum Badge Suggesti..." ( Today at 10:28:07 AM )
View the most recent posts on the forum.
[More Stats]
Title: Re: [SMF Converter] MyBB 1.6
Post by: Nibogo on October 27, 2010, 12:54:00 PM
Try recalculating all the stats from your admin panel, that should do it.
Title: Re: [SMF Converter] MyBB 1.6
Post by: chaitu_cheat on October 27, 2010, 11:45:13 PM
Thanks Red...fixed it !!  :D

One last doubt...now the converted forum is under /forum as I have mentioned in my last post. Is it better to keep it as is and point my old domain www.asli-indian.com to www.asli-indian.com/forum or is there any way I can move the files and delete mybb. ?

Sorry if my english is bad..I hope you got what I am trying to say.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Nibogo on October 28, 2010, 10:51:51 AM
You need to move the files of SMF to the other directory, and use the repair_settings to change all the paths, if you can't you can ask for support in the Support Boards as that isn't related anymore with the converter :)
Title: Re: [SMF Converter] MyBB 1.6
Post by: chaitu_cheat on October 28, 2010, 11:32:27 PM
ok no problem Devil  ;D thanks for your fantastic support...
Title: Re: [SMF Converter] MyBB 1.6
Post by: CommanderMadi on November 03, 2010, 12:18:19 PM
Hey mate
I tried to do the convert but it gave me this error:-
Code: [Select]
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
What shall I do?
Title: Re: [SMF Converter] MyBB 1.6
Post by: wh4yer0 on November 06, 2010, 01:14:42 PM
Hey mate
I tried to do the convert but it gave me this error:-
Code: [Select]
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
What shall I do?

I have the same error, anybody could help fast? It is very important for me.
Title: Re: [SMF Converter] MyBB 1.6
Post by: AndrewS on November 08, 2010, 01:35:46 PM
I got an error here but not sure why, anyone know how to fix it pls?

Converting moderators... Unsuccessful!
This query:
SELECT uid AS ID_MEMBER, fid AS ID_BOARD
FROM `pshacksc_home`.mybb_moderators
LIMIT 0, 500;
Caused the error:
Unknown column 'uid' in 'field list'
Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on November 08, 2010, 01:45:21 PM
EDIT: Sorry you already had it that way.

Probably you are not using the correct files or myBB version.
Title: Re: [SMF Converter] MyBB 1.6
Post by: AndrewS on November 08, 2010, 01:50:54 PM
EDIT: Sorry you already had it that way.

Probably you are not using the correct files or myBB version.

Hi thank you, but I still have the same error when doing that?
Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on November 08, 2010, 01:57:32 PM
EDIT: Sorry you already had it that way.

Probably you are not using the correct files or myBB version.

Hi thank you, but I still have the same error when doing that?
Then I'm lost.

Maybe the other convertor package will work...then you can use the upgrade files from the 1.1 series or the 2.0 series to upgrade to the result you want.
Title: Re: [SMF Converter] MyBB 1.6
Post by: AndrewS on November 08, 2010, 02:05:06 PM
I'm using MyBB 1.6 forums then the MyBB 1,6 sql file n converter.php

Could you link me to one that would work with MyBB 1.6 forums.. I tried so many. not sure which is the right n wrong.
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on November 08, 2010, 05:18:30 PM
I got an error here but not sure why, anyone know how to fix it pls?

Converting moderators... Unsuccessful!
This query:
SELECT uid AS ID_MEMBER, fid AS ID_BOARD
FROM `pshacksc_home`.mybb_moderators
LIMIT 0, 500;
Caused the error:
Unknown column 'uid' in 'field list'
this one seems to be a bug in mybb16_to_smf.sql...
search in mybb16_to_smf.sql for:
Code: [Select]
SELECT uid AS ID_MEMBER, fid AS ID_BOARDreplace it with
Code: [Select]
SELECT id AS ID_MEMBER, fid AS ID_BOARDthe restart the conversion process.
Title: Re: [SMF Converter] MyBB 1.6
Post by: AndrewS on November 08, 2010, 05:45:19 PM
I got an error here but not sure why, anyone know how to fix it pls?

Converting moderators... Unsuccessful!
This query:
SELECT uid AS ID_MEMBER, fid AS ID_BOARD
FROM `pshacksc_home`.mybb_moderators
LIMIT 0, 500;
Caused the error:
Unknown column 'uid' in 'field list'
this one seems to be a bug in mybb16_to_smf.sql...
search in mybb16_to_smf.sql for:
Code: [Select]
SELECT uid AS ID_MEMBER, fid AS ID_BOARDreplace it with
Code: [Select]
SELECT id AS ID_MEMBER, fid AS ID_BOARDthe restart the conversion process.


Thanks but I fixed it myself, suprised :)
Title: Re: [SMF Converter] MyBB 1.6
Post by: Pete50 on November 09, 2010, 05:53:47 PM
Am I missing something? Where can I find the MyBB 1.6 convert.php + sql files?
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on November 23, 2010, 03:36:59 AM
Find them attached in the first post please. I will add them to the site's downloads as well.
Title: Re: [SMF Converter] MyBB 1.6
Post by: .Vapor on November 28, 2010, 05:54:51 PM
Hey mate
I tried to do the convert but it gave me this error:-
Code: [Select]
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
What shall I do?

I am also receiving this error converting:
mybb 1.6
to
smf 2.0 rc4
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on November 29, 2010, 10:49:20 AM
hello!
same error

Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on November 30, 2010, 03:28:36 AM
About:
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Can you please login in phpmyadmin, and run the following query:
Code: [Select]
SELECT birthday from [your_mybb_tables_prefix]users;
(please replace with your actual MyBB tables prefix.)

And attach the result here, or send to me in a PM?

Please note that it will display all the birth dates stored in your MyBB database (with no other user data or anything, only birth dates). If you are not comfortable with that, feel free not to.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on November 30, 2010, 03:31:49 AM
Code: [Select]
SELECT birthday
FROM mybb_users;

LIMIT 0 , 30
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on November 30, 2010, 04:18:05 AM
When you executed that query, below it, on the page, phpmyadmin must have displayed the result. Could you please tell which are they?
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on November 30, 2010, 05:59:50 AM
#1064 - 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 '[mybb_users]users LIMIT 0, 30' at line 1
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on November 30, 2010, 06:06:11 AM
If your prefix is "mybb_", then please replace in the query "mybb_users", that is, please run:
Code: [Select]
SELECT birthday
FROM mybb_users;

It depends on what your actual prefix is - if you really have a table named "mybb_users" or it is named something else ending with "users".
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on November 30, 2010, 06:20:45 AM
yes my table is mybb_users
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on November 30, 2010, 06:24:31 AM
Then please use the query:
Code: [Select]
SELECT birthday
FROM mybb_users;
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on November 30, 2010, 06:27:10 AM
there are too many records to display
Affichage des enregistrements 0 - 29 (2 473 total, Traitement en 0.0002 sec.)
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on November 30, 2010, 08:06:55 AM
Please, use the attached mybb16_to_smf.sql file instead.

Also, please upload the attached file in your Sources/Subs-Db-mysql.php. It would be best if you made a copy of your current Sources/Subs-Db-mysql.php file, and keep it. Then replace your file with the attached one.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on November 30, 2010, 08:49:20 AM
Converting members...Wrong value type sent to the database. Date expected. (birthdate)  O:)
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on November 30, 2010, 08:51:17 AM
Oops.
Are you sure the new files are in the right directories? mybb16_to_smf.sql should be uploaded to SMF main directory, overwriting your previous file, and Subs-Db-mysql.php should be uploaded in your Sources directory.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on November 30, 2010, 08:55:21 AM
Yes
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on November 30, 2010, 09:02:19 AM
I can't replicate it anymore. I used your dates in my test forum, got the same error, and have it fixed using these changes.

Can you please make sure that the file Subs-Db-mysql.php was indeed overwritten by your FTP client? Sometimes they may not overwrite all existing files. Same for the other.
Maybe it would be useful if you download them to check.

Also, can you please make sure you restart the conversion process completely, from running convert.php without any parameter in the URL, just http://your_smf_address/convert.php
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on November 30, 2010, 09:22:09 AM
Yes

Directory smf

Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on November 30, 2010, 10:08:26 AM
Yes

Directory smf
I can sees you has new mailz.

Anyways, I'm gonna try converting my test myBB forum.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 08, 2010, 04:38:35 AM
I still hold to the conversion
I stuck at the first step.  :-\
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on December 08, 2010, 05:21:34 AM
Can you please try using this file instead then?
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 08, 2010, 05:27:38 AM
always block with the same message
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on December 08, 2010, 05:42:26 AM
The cause is a stray date in the MyBB database, which is "1-1-" instead of "" or "1-1-1980" or whatever other proper date. But these changes in the files should address it... :(
Could you eventually try this:
- backup your MyBB database
- then run the following SQL statement on it:
Code: [Select]
UPDATE `mybb_users`
SET `birthday` = ""
WHERE LENGTH(birthday) < 8
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 08, 2010, 05:55:01 AM
still not working
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on December 11, 2010, 01:53:58 AM
Bruno36,
in mybb16_to_smf.sql find:
Code: [Select]
---* {$to_prefix}members
add after:
Code: [Select]
---{
/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';
---}
then restart the conversion.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 11, 2010, 03:51:28 AM
thank you its works  ;)
I have another problem I have a new error message

Converting topics... Incomplete.
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on December 11, 2010, 03:55:01 AM
Any specific errors? on boards with many topics the converter stops sometimes to avoid a server overload and should continue automatically after a few seconds.. maybe you need to wait a little bit more?!?
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 11, 2010, 04:09:32 AM
yes thank you I'll wait
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 11, 2010, 04:16:34 AM
Converting...
Converting topics...
Successful.
Converting posts (this may take some time)...The database value you're trying to insert does not
exist: modified_name
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on December 11, 2010, 04:45:28 AM
ok, next trial..
in mybb16_to_smf.sql
find:
Code: [Select]
SUBSTRING(IF(p.edituid > 0, edit_u.username, ''), 1, 255) AS modified_name,replace with:
Code: [Select]
SUBSTRING(IF(p.edituid > 0, edit_u.username, 0), 1, 255) AS modified_name,this solution is far away from perfect but it should work and we could fix it later with a simple SQL statement
Code: [Select]
UPDATE smf_messages SET modified_name = '' WHERE modified_name = 0;
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 11, 2010, 06:18:41 AM
Converting topics...
Successful.
Converting posts (this may take some time)...The database value you're trying to insert does not exist: modified_name
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on December 11, 2010, 08:19:15 AM
mhh, that's really weird.. ok, let's try the following:
find
Code: [Select]
---* {$to_prefix}messages 200
---{
$ignore_slashes = true;
---}
replace with:
Code: [Select]
---* {$to_prefix}messages 200
---{
$ignore_slashes = true;
/* yet another fix for empty rows ... */
if(empty($row['modified_name']))
$row['modified_name'] = 0;
---}
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 11, 2010, 09:45:45 AM
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)...The database value you're trying to insert does not exist: from_name
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on December 11, 2010, 02:09:01 PM
find:
Code: [Select]
---* {$to_prefix}personal_messagesadd after:
Code: [Select]
---{
if(empty($row['from_name']))
$row['from_name'] = 'Guest';
---}
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 12, 2010, 06:11:28 AM
Converting...
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... Duplicate key name 'ip_index'
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on December 12, 2010, 08:18:20 AM
good news at all, this last one is already known and should be fixed soon, a solution is available:
http://www.simplemachines.org/community/index.php?topic=242961.msg2867944#msg2867944
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 12, 2010, 11:00:48 AM
thank you very much all works
Title: Re: [SMF Converter] MyBB 1.6
Post by: Bruno36 on December 12, 2010, 11:01:39 AM
Avatars and BBcode are not converted
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on December 12, 2010, 01:32:06 PM
Avatars and BBcode are not converted
that's right, both are not part of mybb16_to_smf.sql.. Maybe a current team member can help here?

Title: Re: [SMF Converter] MyBB 1.6
Post by: Nibogo on December 15, 2010, 03:25:01 PM
Those aren't part of the converter at the moment, sorry about that, I'll try to do it.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Chrisburgin2 on December 20, 2010, 11:45:43 AM
I could have used this about a month ago lol. But thanks for the converter i have some freinds that are reluctanct to swich to smf from mybb without a converter now they have no reason to stay on mybb.
Title: Re: [SMF Converter] MyBB 1.6
Post by: •Ash• on December 26, 2010, 04:47:55 PM
Is there a converter for SMF2.0 RC4?
Thanks.
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on December 27, 2010, 01:51:04 PM
please use the attached files..
Title: Re: [SMF Converter] MyBB 1.6
Post by: kaju666 on January 03, 2011, 06:07:11 PM
always i have an error
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on January 04, 2011, 02:23:15 AM
please check:
http://www.simplemachines.org/community/index.php?topic=404303.msg2877724#msg2877724
Title: Re: [SMF Converter] MyBB 1.6
Post by: mizwizzy on January 04, 2011, 06:57:52 PM
Is there a missing attachment on the first post because I can't seem to find any converter for mybb 1.6 and none on the downloads page either! :-[
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on January 05, 2011, 02:17:23 AM
direct link to the 1.1 Converter:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=404303.0;attach=158899
Title: Re: [SMF Converter] MyBB 1.6
Post by: mizwizzy on January 05, 2011, 07:58:12 AM
Brilliant, thanks so much for helping me out (and pointing me in the right direction)  :)
Title: Re: [SMF Converter] MyBB 1.6
Post by: TheRealCod3r on January 05, 2011, 08:01:32 PM
Holy sh... Cow. Worked at first try, amazing. Converted everything, topics, members, posts, just as it should. Thank you, so much.

Also, wouldn't make it without Norv's idea for installing both SMF and MyBB in the same database. [I was getting the user table error]

Happy 2011 people.
Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on January 07, 2011, 12:18:41 PM
Glad that it worked at your first try, TheRealCod3r! Not many converters have managed to do that ;)
Title: Re: [SMF Converter] MyBB 1.6
Post by: kptkorg on January 18, 2011, 12:49:48 AM
Hello,
How do I resolve this error?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg534.imageshack.us%2Fimg534%2F6725%2Fpishata.png&hash=ee27b4addcb69980ef770c15ec07dd8a)
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on January 18, 2011, 09:27:37 AM
in mybb16_to_smf.sql find:
Code: [Select]
---* {$to_prefix}topicsadd after
Code: [Select]
---{
$ignore = true;
---}

then restart the converter.
Title: Re: [SMF Converter] MyBB 1.6
Post by: sattarforum on January 21, 2011, 03:14:03 PM
Hi
Converter version 1.6.1, please also put
Regards
Sattar Forum
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThorstenE on January 22, 2011, 01:39:37 AM
Hi
Converter version 1.6.1, please also put
Regards
Sattar Forum
the MyBB 1.6 converter should work, have you tried converting?
Title: Re: [SMF Converter] MyBB 1.6
Post by: bettamaster100 on January 31, 2011, 09:01:26 AM
This page is going on forever and all is says is:
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Title: Re: [SMF Converter] MyBB 1.6
Post by: bettamaster100 on January 31, 2011, 09:12:43 AM
I am getting this error:
Code: [Select]
Converting polls...The database value you're trying to insert does not exist: id_member
Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on January 31, 2011, 11:12:37 AM
Please do not bump a topic within 24 hours. Your time between posts was +/- 12 minutes.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Hammer Bro. Mike on February 04, 2011, 04:05:04 PM
Converting poll votes... Unsuccessful!

This query:

    INSERT INTO `zeldaet_forums`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE)

Caused the error: Duplicate entry '12-74-1' for key 'PRIMARY'
Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on February 05, 2011, 10:22:41 AM
the two ` used in your prefix may cause a issue...?
Title: Re: [SMF Converter] MyBB 1.6
Post by: Hammer Bro. Mike on February 05, 2011, 03:05:00 PM
I'm not sure if I'm supposed to add, change or delete anything or not to the current code.

Code: [Select]
---* {$to_prefix}log_polls
SELECT pid AS ID_POLL, uid AS ID_MEMBER, voteoption AS ID_CHOICE
FROM {$from_prefix}pollvotes;
---*
Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on February 06, 2011, 09:31:10 AM
I'm not sure if I'm supposed to add, change or delete anything or not to the current code.

Code: [Select]
---* {$to_prefix}log_polls
SELECT pid AS ID_POLL, uid AS ID_MEMBER, voteoption AS ID_CHOICE
FROM {$from_prefix}pollvotes;
---*
Try adding this:

Code: [Select]
---{
$ignore = true;
---}
Title: Re: [SMF Converter] MyBB 1.6
Post by: Evollution on February 12, 2011, 09:27:30 AM
i dont understand why you are changing from mybb to smf
Title: Re: [SMF Converter] MyBB 1.6
Post by: patheticcockroach on February 13, 2011, 12:08:27 PM
I just tried the script posted in http://www.simplemachines.org/community/index.php?topic=404303.msg2893139#msg2893139 , and I quickly get stuck by that:
Code: [Select]
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
How frustrating, birth dates are so unimportant in my board... (most likely, almost all of them aren't filled in)

Trying to convert MyBB 1.6.0 to SMF 2.0RC5 (since the older version, 2.0RC4, can't be found).

Edit: Well, nevermind, I just deleted all birth dates from MyBB and then it worked ;)
Title: Re: [SMF Converter] MyBB 1.6
Post by: JanersM on March 30, 2011, 12:52:00 AM
Forgive me if this has already been addressed somewhere.  (I searched to see if this was listed somewhere else on the forum and I couldn't find it.)

I'm converting from MyBB 1.6.2 to SMF 2.0 RC5.  I got the birthdate error, which led to me deleting the birthdays to get past it.  That worked.  When it was importing the topics, it gave me this error:
Code: [Select]
Converting topics...
Duplicate entry '477' for key 'PRIMARY'

What do I do for it?
Title: Re: [SMF Converter] MyBB 1.6
Post by: Pnikosis on April 07, 2011, 07:48:23 AM
i dont understand why you are changing from mybb to smf

TAPATALK support among other things.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Sakacoco on April 18, 2011, 12:23:10 PM
Hello !
First, thanks you very much for this converter, but I'm having some problems using it. I had to fix the birthday bug though.

It's working, at first, because I can see all my members ( 4 659 ) in the member list and in the database, the passwords are working, I even get the Categories/Forum structures with the numbers of Posts and thread inside, but that's all, after letting the script running for one hour I stopped it.

Note: I have +20k of posts inside the forum to convert.

It's freezing at Converting topics.

Can you help me :) ?
Title: Re: [SMF Converter] MyBB 1.6
Post by: The 12th Doctor on May 01, 2011, 11:20:03 AM
On conversion this is what i get....

Quote
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... Duplicate column name 'id_member'

Anyway to fix this?

Thanks

Jon
Title: Re: [SMF Converter] MyBB 1.6
Post by: wascallywabbit on June 13, 2011, 01:39:33 AM
I am getting the following error when I run the script at the poll conversion:
Code: [Select]
Converting polls...Wrong value type sent to the database. Integer expected.anyone have a clue what's up?

Well, I managed to fix the above, but now I get this
Code: [Select]
Converting personal messages (step 1)...The database value you're trying to insert does not exist: from_nameany ideas
Title: Re: [SMF Converter] MyBB 1.6
Post by: Norv on June 16, 2011, 12:41:45 PM
A few bugs in the converter reported here should be solved. Please, find the corrected file attached.
Title: Re: [SMF Converter] MyBB 1.6
Post by: hamed.ramzi on July 16, 2011, 06:32:29 PM
hi friend my convert this error

Code: [Select]
Converting...
Converting members... Successful.
Converting categories...Duplicate entry '255' for key 1
Title: Re: [SMF Converter] MyBB 1.6
Post by: hamed.ramzi on July 17, 2011, 07:06:36 AM
Why does not anyone help
Title: Re: [SMF Converter] MyBB 1.6
Post by: Katana01 on August 05, 2011, 04:54:14 AM
That would interest me too. I try to SMF MyBB 1.6.3 to convert.
Title: Re: [SMF Converter] MyBB 1.6
Post by: cheif_asi on August 05, 2011, 07:15:05 AM
as i start the convertor i get this error

Quote
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. 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: SELECT command denied to user 'smf'@'localhost' for table 'users'

pls help me out
Title: Re: [SMF Converter] MyBB 1.6
Post by: David W on August 08, 2011, 05:46:39 PM
it should be on the converter page i agree
Title: Re: [SMF Converter] MyBB 1.6
Post by: MrD on August 11, 2011, 12:32:02 AM
Bruno36,
in mybb16_to_smf.sql find:
Code: [Select]
---* {$to_prefix}members
add after:
Code: [Select]
---{
/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';
---}
then restart the conversion.

hi.. when I try this fix,I get the following.. any help appreciated..

Converting members...
Unsuccessful!
This query:

    if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
    $row['birthdate'] = '0001-01-01'
    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 'if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
    $row['birthdate'] = '' at line 1
Title: Re: [SMF Converter] MyBB 1.6
Post by: algentar on August 18, 2011, 08:22:35 PM
Hello... How about avatar?
When i convert MyBB 1.6.4 to SMF 2.0, everything is OK. But avatar not shown, and also, in user profile, there is no avatar change options..

How to fix it?

Thanks
Title: Re: [SMF Converter] MyBB 1.6
Post by: webdo on September 01, 2011, 11:50:26 PM
Here is the correct, 100% working, file for converting mybb 1.6.x to SMF 2.0
If you have a problem like slash before quotes  ie: dog\'s in boards, Use that queries:
Code: [Select]
UPDATE smf_boards SET description = REPLACE(description, '\\', '') WHERE description LIKE "%\\\\%";
UPDATE smf_boards SET name = REPLACE(name, '\\', '') WHERE name LIKE "%\\\\%";
Title: Re: [SMF Converter] MyBB 1.6
Post by: patrixon78 on September 03, 2011, 02:29:47 PM
Hi guys. I have few questions about the MyBB to SMF convertion. My problem is that I've followed all the way this topic and digging all the info I was able to find here and with the uncle Google help. Still unable to do the conversion from MyBB 1.6.4a to SMF 2.0. I have already tried to convert even form 1.6.4a to 1.1.14.
No success. In both cases covertion freze doing the topics...
It finish with this:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...

and it freeze

You seems to have all that huge knowledge that I need :) in this case.
Would you be able to give me some hints how can I complete the conversion?
Thanks in advance.
Cheers

Title: Re: [SMF Converter] MyBB 1.6
Post by: katib on September 29, 2011, 10:17:40 AM
I run the converter
It stuck fro ever at converting topic .....

Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on October 02, 2011, 02:59:14 PM
I run the converter
It stuck fro ever at converting topic .....
How many topics do you have?
Title: Re: [SMF Converter] MyBB 1.6
Post by: katib on October 02, 2011, 04:30:47 PM
I run the converter
It stuck fro ever at converting topic .....
How many topics do you have?
Well
I have 8.777 Topics and 43.864 Posts
The problem is that the script converter deosnot show any progress bar so user can monitor progress
After filling informations (paths , BD password...) hitting Continue, it shows nothing for a while, then the above screenshot when it stuck forever
Title: Re: [SMF Converter] MyBB 1.6
Post by: Char Aznable on November 09, 2011, 01:33:53 AM
Here is the correct, 100% working, file for converting mybb 1.6.x to SMF 2.0
If you have a problem like slash before quotes  ie: dog\'s in boards, Use that queries:
Code: [Select]
UPDATE smf_boards SET description = REPLACE(description, '\\', '') WHERE description LIKE "%\\\\%";
UPDATE smf_boards SET name = REPLACE(name, '\\', '') WHERE name LIKE "%\\\\%";

If you ever have problems doing this, use this. It will work. Thanks a lot, guys. Great work.
Title: Re: [SMF Converter] MyBB 1.6
Post by: NerdGasm on November 10, 2011, 02:07:06 AM
I'm extremely frustrated at the moment.
I have been wanting to convert my MyBB 1.6 board to SMF 2.0.1.
Thought, neither converter will allow me.
All i keep receiving, even though the files ARE in the correct locations is;

Quote
This converter was unable to find SMF in the path you specified.
Please double check the path, and that it is already installed there.

Please help in any way possible! I need to get this done as soon as possible.
Title: Re: [SMF Converter] MyBB 1.6
Post by: HolyPhoenix on November 20, 2011, 01:56:17 AM
Hi, I am attempting to get this to work with mybb 1.6.3. 

I had a problem with the birthday, but was able to get past it.  But now I am getting this error:
Code: [Select]
Converting posts (this may take some time)...
Successful.
Converting polls...The database value you're trying to insert does not exist: id_member

I looked in the smf database for polls and poll votes.  Both had id_member.  Any clues as to where I should head with this?
Title: Re: [SMF Converter] MyBB 1.6
Post by: pcfreak30 on November 27, 2011, 03:18:08 PM
Hello, I am trying to convert to SMF for fun to see how it goes. There seems to be an issue with birthdays and the data-type. Not fully sure. I got around it by removing the sql statements, but its still a bug.

Code: [Select]
Wrong value type sent to the database. Date expected. (birthdate)
Now I am getting

 * Converting categories...
Duplicate entry '255' for key 'PRIMARY'

I tried adding

Code: [Select]
ORDER BY id_cat ASC
to

Code: [Select]
WHERE type = 'c' ORDER BY id_cat ASC;
But no dice.

I keep resetting the auto increase counter too.

Any help.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Kryten15 on December 10, 2011, 05:51:29 AM
Hello,

I've been trying to convert my forum as after a ton of issues from my last host and trying to get all the data I'm finally at the stage where I want to run the conversion tool. Unfortunately it keeps timing out after the initial page where it asks you for the information. It doesn't have a chance to get past step1.

At first I thought it was my firewall so I added some exceptions to see if that helped. It didn't and so I decided to use a USB modem which would bypass the firewall entirely (its built in the the network prior to my PC) but it still had the same problem.

At times it will come back saying that it had a Read Timeout.

Anyone able to help or give any suggestions?


EDIT: And or course, as soon as I post it gets past that part but times out when it pauses to stop it overloading. Now its timing out at the:

convert.php?step=1&substep=1&start=13500

section.
Title: Re: [SMF Converter] MyBB 1.6
Post by: InsaneMustang on December 13, 2011, 03:20:44 PM
I'm getting

Unknown column 'memberName' in 'field list'
Title: Re: [SMF Converter] MyBB 1.6
Post by: InsaneMustang on December 22, 2011, 10:48:28 AM
help?
Title: Re: [SMF Converter] MyBB 1.6
Post by: nck0099 on December 24, 2011, 04:07:34 AM
i m getting this error while converting

Code: [Select]
[b]Converting...
[/b]
Converting members...Duplicate entry '16777215' for key 'PRIMARY'
Title: Re: [SMF Converter] MyBB 1.6
Post by: alexandreperei on December 27, 2011, 06:39:45 PM
One simple question, i have to delete mybb files before use converter? And sql files?
Title: Re: [SMF Converter] MyBB 1.6
Post by: nck0099 on December 29, 2011, 04:44:54 AM
One simple question, i have to delete mybb files before use converter? And sql files?
no
Title: Re: [SMF Converter] MyBB 1.6
Post by: Firari55 on February 11, 2012, 07:03:33 PM
Birisi Şu Sistemin En Sağlamını Upload Etsin.
Title: Re: [SMF Converter] MyBB 1.6
Post by: eleweb on February 21, 2012, 10:36:01 AM
 :'( i have this mistake

Code: [Select]
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. 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: SELECT command denied to user 'prova_smf'@'localhost' for table 'mybb_users'

what does mean?
Title: Re: [SMF Converter] MyBB 1.6
Post by: Ashley S on February 25, 2012, 11:49:47 AM
No converter for SMF 2.0.2?
Title: Re: [SMF Converter] MyBB 1.6
Post by: Nibogo on February 25, 2012, 02:30:08 PM
No converter for SMF 2.0.2?

It should work just fine for 2.0.2, if not just convert to 2.0 and upgrade to 2.0.2
Title: Re: [SMF Converter] MyBB 1.6
Post by: iMadness on March 24, 2012, 02:20:49 PM
About:
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Can you please login in phpmyadmin, and run the following query:
Code: [Select]
SELECT birthday from [your_mybb_tables_prefix]users;
(please replace with your actual MyBB tables prefix.)

And attach the result here, or send to me in a PM?

Please note that it will display all the birth dates stored in your MyBB database (with no other user data or anything, only birth dates). If you are not comfortable with that, feel free not to.

I just ran a query, by the bottom in the top left.
Here's what I got (Same BDay issue)
http://i.imgur.com/waCHj.png
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThomasJ on March 26, 2012, 04:38:46 AM
I ran into the same BDay issue. Format was 1-1-1970 for all users with no bday explicitly set. Nulled out all bdays to get past that step. However that lead me directly into the next issue:

Code: [Select]
Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)
Title: Re: [SMF Converter] MyBB 1.6
Post by: NanoSector on March 26, 2012, 09:00:42 AM
Can you give me an example of a poll's expire_time value?
Probably it's not an UNIX timestamp which is all integer.

If it's something like "1-1-1970" I can do something about it.
Title: Re: [SMF Converter] MyBB 1.6
Post by: ThomasJ on March 31, 2012, 08:52:33 PM
From the sql
Code: [Select]
TRUNCATE {$to_prefix}polls;
TRUNCATE {$to_prefix}poll_choices;
TRUNCATE {$to_prefix}log_polls;

---* {$to_prefix}polls
SELECT
        p.pid AS id_poll, SUBSTRING(p.question, 1, 255) AS question, p.closed AS voting_locked,
        t.uid AS id_member,
        IF(p.timeout = 0, 0, p.dateline + p.timeout * 86400) AS expire_time,
        SUBSTRING(t.username, 1, 255) AS poster_name
FROM {$from_prefix}polls AS p
        LEFT JOIN {$from_prefix}threads AS t ON (t.tid = p.tid);
---*

So it's taking timeout and datline coloumns, which are bigint(30) and appear to be unix timestamps. I have no idea why it is failing as the entry's clearly are int's

example dateline
Code: [Select]
1094083328

example timeout
Code: [Select]
1094083328
Title: Re: [SMF Converter] MyBB 1.6
Post by: eleweb on April 14, 2012, 10:04:58 AM
HI, I'm use the suggerst of page 3 but I continue to have tis error

Code: [Select]
Converting posts (this may take some time)...The database value you're trying to insert does not exist: modified_name
how to fix it?
Title: Re: [SMF Converter] MyBB 1.6
Post by: serulin on June 12, 2012, 12:06:16 AM
Awesome thread guys, thanks for all the help! Had to go through and find each fix from people and add it to the sql, but in the end it worked! Just successfully converted mybb 1.6.7 to smf 2.0.2!!!
Title: Re: [SMF Converter] MyBB 1.6
Post by: Marshall007 on June 25, 2012, 05:33:05 AM
HI All, Getting this error when convertin.

Converting...
Converting moderators... Successful.
 Converting topic view logs... Successful.
 Converting attachments... Successful.
 Recalculating forum statistics... Duplicate column name 'id_member'
Title: Re: [SMF Converter] MyBB 1.6
Post by: DanThemes on August 05, 2012, 05:01:50 AM
I get this error when trying to convert MyBB 1.6.8 to SMF 2 RC3:

Image url: awesomescreenshot.com/0c0cbnb11
Title: Re: [SMF Converter] MyBB 1.6
Post by: xanenightwing on September 08, 2012, 08:51:42 PM
Hello. even with the updated .sql file, I keep getting the birthday error. what would the best fix be?

nevermind. everything is fixed.
Title: Re: [SMF Converter] MyBB 1.6
Post by: jaacobbi on September 29, 2012, 04:37:49 AM
When I go to convert.php it shows this:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2F7ESgH.png&hash=e7a337a54410ff79ad819a10a3867025)

And I picked 1.4 and this happend:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FkCA5q.png&hash=ce22ac998681f0d8f721cce0b7233ddb)

Now I can't go back and pick that other. So whats the problem?
Title: Re: [SMF Converter] MyBB 1.6
Post by: jaacobbi on September 29, 2012, 12:08:15 PM
Got new problem : http://www.simplemachines.org/community/index.php?topic=487390.msg3413633#msg3413633.
Title: Re: [SMF Converter] MyBB 1.6
Post by: zapex on December 18, 2012, 02:46:52 PM
Do i need to upload zip via package manager or? How to use it.
Title: Re: [SMF Converter] MyBB 1.6
Post by: gonss on January 03, 2013, 04:29:55 PM
And i have this error
Code: [Select]
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. 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: SELECT command denied to user 'lolserbi_stefan'@'localhost' for table 'mybb_users'
bump
Title: Re: [SMF Converter] MyBB 1.6
Post by: gonss on January 03, 2013, 05:58:47 PM
Okey I fix problem, now I have this:
Code: [Select]
Successful.
Recalculating forum statistics...
That mean I need to wait?
Title: Re: [SMF Converter] MyBB 1.6
Post by: rodelio.lagahit on January 04, 2013, 10:22:02 PM
is this the right mod where i'm going to upload myBB database to SMF database?

I have a myBB database and I wanted it merge to my existing SMF database. Can someone point me to the right direction? Thanks in advance
Title: Re: [SMF Converter] MyBB 1.6
Post by: KaJzEr 283 on January 25, 2013, 03:00:41 PM
I have this error

Unsuccessful!
 This query:
SELECT value
 FROM `hightech_mybb313`.mybb_settings
 WHERE variable = 'attachmentUploadDir'
 LIMIT 1;
 Caused the error:
Unknown column 'variable' in 'where clause'
Title: Re: [SMF Converter] MyBB 1.6
Post by: adbrad on May 22, 2013, 06:53:03 AM
I'm geting this error

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. 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: SELECT command denied to user 'web1-smf-1'@'localhost' for table 'mybb_users'

anyone know the fix, I have seen people post the same error but never get a reply.
Title: Re: [SMF Converter] MyBB 1.6
Post by: Arantor on May 22, 2013, 05:20:54 PM
Well, the error seems fairly clear: you've set up MyBB in a database and it has a username and a password. SMF has a username and a password but you've put it in a different database and the username and password SMF has can't get to the MyBB database... so there's no way SMF can import it.

Install SMF into the same database with the same user and password as MyBB is currently installed in (using smf_ as the prefix to avoid collision) and then it'll work.

This is the same error everyone else has and is the same error as the very first entry in http://www.simplemachines.org/community/index.php?topic=146192.0 and it's also mentioned in http://wiki.simplemachines.org/smf/Converting
Title: Re: [SMF Converter] MyBB 1.6
Post by: adbrad on May 23, 2013, 03:56:00 AM
Thanks arantor i sort of did that but did it the other way round and had to set the mybb database config to the smf data base but then i get the birthday error.
Title: Re: [SMF Converter] MyBB 1.6
Post by: lifesucks on June 11, 2013, 12:23:50 AM
Hi,

I am trying to convert from mybb 1.6 to smf and i am facing these issues. Can someone help me here

Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Then i did this

Code: [Select]
---* {$to_prefix}members

add after:
Code: [Select]
---{
/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
   $row['birthdate'] = '0001-01-01';
---}




Then also i am getting the same error message

Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Title: Re: [SMF Converter] MyBB 1.6
Post by: JCatalan55 on November 29, 2013, 02:02:07 PM
Hola, gracias por el aporte, pero no hay manera de ponerlo... Alguna ayuda? Gracias!
Title: Re: [SMF Converter] MyBB 1.6
Post by: Klevron on December 02, 2013, 02:31:59 AM
When im Converting

Code: [Select]
MyBulletinBoard 1.6 to SMF Converter
Converting...
Converting members... Unsuccessful!
This query:
ALTER TABLE `oldschoo_oldsc991_mybb123`.smf_members
CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';
Caused the error:
Unknown column 'passwordSalt' in 'smf_members'
Title: Re: [SMF Converter] MyBB 1.6
Post by: Klevron on December 02, 2013, 02:45:15 AM
Problem as Always :(

Code: [Select]
Converting...
Converting topics...
Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Unsuccessful!
This query:
SELECT
p.pid AS id_poll, SUBSTRING(p.question, 1, 255) AS question, p.closed AS voting_locked,
t.uid AS id_member,
IF(p.timeout = 0, 0, p.dateline + p.timeout * 86400) AS expire_time,
SUBSTRING(t.username, 1, 255) AS poster_name
FROM `oldschoo_oldsc991_mybb123`.mybb_polls AS p
LEFT JOIN `**************`.mybb_threads AS t ON (t.tid = p.tid)
LIMIT 0, 500;
Caused the error:
BIGINT value is out of range in '(`*******************`.`p`.`timeout` * 86400)'
Title: Re: [SMF Converter] MyBB 1.6
Post by: saosangmo on December 20, 2013, 06:20:13 AM
hi,
Does anyone convert mybb 1.6.7 to SMF 2.0.x?
thanks
Title: Re: [SMF Converter] MyBB 1.6
Post by: AllanD on December 20, 2013, 09:11:08 AM
If you go to mybb converters download the bottom one that says mybb to smf 2-0 
Here is the link  http://download.simplemachines.org/?converters;software=mybb

I have used this several times without errors.
Title: Re: [SMF Converter] MyBB 1.6
Post by: bobmail on April 24, 2014, 06:43:42 PM
Hi

I have the following error, trying to convert from Mybb 1.6.9:

Converting posts (this may take some time)...The database value you're trying to insert does not exist: poster_email

Is there an updated .sql file that would work better?

Thanks!

Title: Re: [SMF Converter] MyBB 1.6
Post by: margarett on April 24, 2014, 07:54:08 PM
Are you using the converter from the downloads page?
Title: Re: [SMF Converter] MyBB 1.6
Post by: bobmail on April 25, 2014, 02:25:02 AM
Hi

Thanks for your answer.

I'm using the third one (mybb to smf) - with the default .sql file it doesn't detect the database prefix and can't read any table, (error: Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.0. 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: SELECT command denied to user 'dev'@'localhost' for table 'users') - with the latest .sql file given in this thread everything goes fine until I have this error message. "The database value you're trying to insert does not exist: poster_email"...


If I change the .inc/config related line in the .sql file given on the download page, with "---~ from_prefix: "`{$config['database']['database']}`.{$config['database']['table_prefix']}"" I can start the script but then I have several mysql errors.




Title: Re: [SMF Converter] MyBB 1.6
Post by: bobmail on April 25, 2014, 02:44:08 AM
Attachment is the .sql file that did work for me.

Hope it can help someone :)

Title: Re: [SMF Converter] MyBB 1.6
Post by: Bogus on May 31, 2014, 04:17:40 AM
Thanks bobmail for the sharing from your mysql convert file ;D
Title: Re: [SMF Converter] MyBB 1.6
Post by: De$T_RoYeR on June 05, 2014, 08:33:38 AM
i am getting this error

Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

please help me
Title: Re: [SMF Converter] MyBB 1.6
Post by: margarett on June 05, 2014, 09:08:03 AM
Which converter are you using? The one from the downloads page or the one from this topic? You should use the one from the downloads page.
Is your MyBB 1.6?

Also, check this tip here:
http://www.simplemachines.org/community/index.php?topic=404303.msg2877724#msg2877724
Title: Re: [SMF Converter] MyBB 1.6
Post by: ariolander on June 20, 2014, 02:38:00 AM
I am having issues with the birthday field mainly because my myBB version I am converting from had bad birthdays because the conversion from the other board software to myBB botched the birthday data. While some users have them, a lot of users have the field totally blank.

Is there any way to get the conversion script to skip the b-day field or run some sort of SQL query to insert a valid date if the field is blank?
Title: Re: [SMF Converter] MyBB 1.6
Post by: margarett on June 20, 2014, 03:37:49 PM
Best way is really to just have no values inserted --> no one has birthdate.
Title: Re: [SMF Converter] MyBB 1.6
Post by: kj_ on July 01, 2014, 09:20:11 AM
It worked perfect for me :).

kj
Title: Re: [SMF Converter] MyBB 1.6
Post by: Ronald_1938 on November 30, 2014, 07:59:57 PM
I have a mybb 1.6.15 I no longer wish to update or upgrade.

I wish to convert over to smf, I am familiar with smf forums to begin with..

What is the first step, use a test board first then go for the real thing..

I am going to need help on this, because I am not the brainiest guy around..

Ron
Title: Re: [SMF Converter] MyBB 1.6
Post by: Antes on November 30, 2014, 08:02:03 PM
You can read: http://wiki.simplemachines.org/smf/Converting
Title: Re: [SMF Converter] MyBB 1.6
Post by: Ronald_1938 on November 30, 2014, 08:11:08 PM
You can read: http://wiki.simplemachines.org/smf/Converting (http://wiki.simplemachines.org/smf/Converting)

Thanks Antes, I opened and bookmark it. I will read it later tonight..

Is there help here with this, paid or other that you know of..

Ron..
Title: Re: [SMF Converter] MyBB 1.6
Post by: Antes on November 30, 2014, 08:14:48 PM
You can read: http://wiki.simplemachines.org/smf/Converting (http://wiki.simplemachines.org/smf/Converting)

Thanks Antes, I opened and bookmark it. I will read it later tonight..

Is there help here with this, paid or other that you know of..

Ron..

Hello, I'm glad to help

You can post in http://www.simplemachines.org/community/index.php?board=50.0 if you want to post a paid job (Please mind to give as much as detail possible about the job).
Title: Re: [SMF Converter] MyBB 1.6
Post by: Blodo on February 24, 2015, 07:45:07 PM
Hi guys,

While trying to convert a really big forum (1.5gb database size) I ran into issues during conversion of threads table. The particular select query in the sql file that was causing problems was this:

Code: [Select]
SELECT
t.tid AS id_topic, t.fid AS id_board, t.sticky AS is_sticky,
t.poll AS id_poll, t.views AS num_views, IFNULL(t.uid, 0) AS id_member_started,
IFNULL(ul.uid, 0) AS id_member_updated, t.replies AS num_replies,
CASE
WHEN (t.closed = '1') THEN 1
ELSE 0
END AS locked,
MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg
FROM {$from_prefix}threads AS t
INNER JOIN {$from_prefix}posts AS p
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)
WHERE p.tid = t.tid
GROUP BY t.tid
HAVING id_first_msg != 0
AND id_last_msg != 0;

Turns out the INNER JOIN in this absolutely chokes out on a big table to the point where it can't even return 1 row in a reasonable amount of time. I rewrote the select query for that particular conversion step to the following:

Code: [Select]
SELECT
    t.tid AS id_topic, t.fid AS id_board, t.sticky AS is_sticky,
    t.poll AS id_poll, t.views AS num_views, IFNULL(t.uid, 0) AS id_member_started,
    IFNULL(ul.uid, 0) AS id_member_updated, t.replies AS num_replies,
    IF(t.closed = '1', 1, 0) AS locked,
    (SELECT MIN(p.pid) FROM {$from_prefix}posts AS p WHERE p.tid = t.tid LIMIT 1) AS id_first_msg,
    (SELECT MAX(p.pid) FROM {$from_prefix}posts AS p WHERE p.tid = t.tid LIMIT 1) AS id_last_msg
FROM {$from_prefix}threads AS t
    LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)
HAVING id_first_msg != 0 AND id_last_msg != 0;

Time taken to complete this query is reduced by orders of magnitude due to MySQL optimiser now not ignoring the indexes. The BINARY statement on the ul.username made indexes not be used on the users table (which was a big problem), and the INNER JOIN with GROUP BY clause on the posts table ignored indexes as well (which was an even bigger problem). Hope it helps somebody.
Title: Re: [SMF Converter] MyBB 1.6
Post by: benny3041 on December 20, 2015, 05:23:52 PM
Hey,

is there an importer for MyBB 1.8 ?

greets
Title: Re: [SMF Converter] MyBB 1.6
Post by: margarett on December 20, 2015, 07:20:22 PM
Not a dedicated one no. But, as far as we know, the 1.6 converter works fine with minor tweaks. You should get an error like this:
Code: [Select]
Unknown column 'msn' in 'field list'You should just remove the mentioned field from the conversion and it should work for the remaining parts ;)
Title: Re: [SMF Converter] MyBB 1.6
Post by: benny3041 on December 23, 2015, 01:31:32 AM
Not a dedicated one no. But, as far as we know, the 1.6 converter works fine with minor tweaks. You should get an error like this:
Code: [Select]
Unknown column 'msn' in 'field list'You should just remove the mentioned field from the conversion and it should work for the remaining parts ;)

Where can i delet this ? :$
Title: Re: [SMF Converter] MyBB 1.6
Post by: margarett on December 23, 2015, 06:10:01 AM
In the .sql file (I'm sorry but I'm typing from my phone...)
Title: Re: [SMF Converter] MyBB 1.6
Post by: benny3041 on December 23, 2015, 04:38:20 PM
I cant find this in the .sql File o.O
Title: Re: [SMF Converter] MyBB 1.6
Post by: Illori on December 23, 2015, 06:16:40 PM
you are using the files attached in the first post?

in the sql there is

SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn, 1, 255) AS msn,

remove the second part of that line.
Title: Re: [SMF Converter] MyBB 1.6
Post by: benny3041 on December 24, 2015, 03:54:14 PM
Thx. It works.

Now i have an other error :

Converting polls...The database value you're trying to insert does not exist: id_member