Advertisement:

Author Topic: [SMF Converter] MyBB 1.6  (Read 91667 times)

Offline Nibogo

  • SMF Hero
  • ******
  • Posts: 6,531
  • Gender: Male
    • smfpacks on Facebook
    • @smfpacks on Twitter
    • SMFPacks
[SMF Converter] MyBB 1.6
« 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.

Offline chaitu_cheat

  • Jr. Member
  • **
  • Posts: 175
    • Contrive Crook
Re: [SMF Converter] MyBB 1.6
« Reply #1 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'

Offline Nibogo

  • SMF Hero
  • ******
  • Posts: 6,531
  • Gender: Male
    • smfpacks on Facebook
    • @smfpacks on Twitter
    • SMFPacks
Re: [SMF Converter] MyBB 1.6
« Reply #2 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

Offline chaitu_cheat

  • Jr. Member
  • **
  • Posts: 175
    • Contrive Crook
Re: [SMF Converter] MyBB 1.6
« Reply #3 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'

Offline Nibogo

  • SMF Hero
  • ******
  • Posts: 6,531
  • Gender: Male
    • smfpacks on Facebook
    • @smfpacks on Twitter
    • SMFPacks
Re: [SMF Converter] MyBB 1.6
« Reply #4 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.

Offline chaitu_cheat

  • Jr. Member
  • **
  • Posts: 175
    • Contrive Crook
Re: [SMF Converter] MyBB 1.6
« Reply #5 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]

Offline Nibogo

  • SMF Hero
  • ******
  • Posts: 6,531
  • Gender: Male
    • smfpacks on Facebook
    • @smfpacks on Twitter
    • SMFPacks
Re: [SMF Converter] MyBB 1.6
« Reply #6 on: October 27, 2010, 12:54:00 PM »
Try recalculating all the stats from your admin panel, that should do it.

Offline chaitu_cheat

  • Jr. Member
  • **
  • Posts: 175
    • Contrive Crook
Re: [SMF Converter] MyBB 1.6
« Reply #7 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.

Offline Nibogo

  • SMF Hero
  • ******
  • Posts: 6,531
  • Gender: Male
    • smfpacks on Facebook
    • @smfpacks on Twitter
    • SMFPacks
Re: [SMF Converter] MyBB 1.6
« Reply #8 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 :)

Offline chaitu_cheat

  • Jr. Member
  • **
  • Posts: 175
    • Contrive Crook
Re: [SMF Converter] MyBB 1.6
« Reply #9 on: October 28, 2010, 11:32:27 PM »
ok no problem Devil  ;D thanks for your fantastic support...

Offline SkyAttack Madi

  • Jr. Member
  • **
  • Posts: 255
  • Smf Arabic Translator
    • Promasry Entertainment Community
Re: [SMF Converter] MyBB 1.6
« Reply #10 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?
I love SMF, I love Creativity and finally, I love you!

Offline wh4yer0

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] MyBB 1.6
« Reply #11 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.

Offline AndrewS

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] MyBB 1.6
« Reply #12 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'

Offline NanoSector

  • Support Specialist
  • SMF Hero
  • *
  • Posts: 9,758
  • Gender: Male
    • rick2288 on Facebook
    • Yoshi2889 on GitHub
    • Test Server
Re: [SMF Converter] MyBB 1.6
« Reply #13 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.
My Mods / Mod Builder - A tool to easily create mods / Support team member

Offline AndrewS

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] MyBB 1.6
« Reply #14 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?

Offline NanoSector

  • Support Specialist
  • SMF Hero
  • *
  • Posts: 9,758
  • Gender: Male
    • rick2288 on Facebook
    • Yoshi2889 on GitHub
    • Test Server
Re: [SMF Converter] MyBB 1.6
« Reply #15 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.
My Mods / Mod Builder - A tool to easily create mods / Support team member

Offline AndrewS

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] MyBB 1.6
« Reply #16 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.

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.6
« Reply #17 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.
« Last Edit: November 08, 2010, 05:29:28 PM by TE »

Offline AndrewS

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] MyBB 1.6
« Reply #18 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 :)

Offline Pete50

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] MyBB 1.6
« Reply #19 on: November 09, 2010, 05:53:47 PM »
Am I missing something? Where can I find the MyBB 1.6 convert.php + sql files?