Topic: [SMF Converter] MyBB 1.6

[Nibogo]

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.

[chaitu_cheat]

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'


[Nibogo]

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

[chaitu_cheat]

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'


[Nibogo]

Are you sure you're using MyBB 1.6? Those rows were added in that version. Please try to upgrade.

[chaitu_cheat]

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]

[Nibogo]

Try recalculating all the stats from your admin panel, that should do it.

[chaitu_cheat]

Thanks Red...fixed it !! 

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.

[Nibogo]

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

[chaitu_cheat]

ok no problem Devil  thanks for your fantastic support...

[SkyAttack Madi]

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?

[wh4yer0]

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.

[AndrewS]

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'

[Yoshi]

EDIT: Sorry you already had it that way.

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

[AndrewS]

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?

[Yoshi]

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.

[AndrewS]

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.

[TE]

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.

[AndrewS]

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

[Pete50]

Am I missing something? Where can I find the MyBB 1.6 convert.php + sql files?