Merging databases through myBB

[PsychoticHorticulture]

I've got two separate SMF databases presently that I want to merge, one was converted from zetaboards and shares many of the same members that are on the second database.

I'm aware that it's considered extremely difficult and time consuming to do, however a quick search turned up this [nofollow], which apparently has the ability to merge two SMF databases into a myBB db.

So my basic plan is to merge and convert two SMF dbs into myBB, then convert back to SMF. Is that a possibility or is it a foolish thought? Looking to get some feedback before undertaking this, since I don't want to waste time and possibly screw something up.

Oh, and my current SMF version is 2.0, if it matters.

[PsychoticHorticulture]

Figured I'd just try it and find out for myself. Long story short, it works.

[PsychoticHorticulture]

Clarified: Merging the two SMF databases goes without a hitch (for the most part), however converting from myBB back to SMF is an absolute nightmare.

I'm using the converter attached to the below post:

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 Expand

UPDATE smf_boards SET description = REPLACE(description, '\\', '') WHERE description LIKE "%\\\\%";
UPDATE smf_boards SET name = REPLACE(name, '\\', '') WHERE name LIKE "%\\\\%";

I'm still getting the "Wrong value type sent to the database. Date expected. (birthdate)" error. Could someone please help me with this? I see a lot of the threads here have hundreds of views but 0 replies after literally weeks, and I know there's gotta be someone out there who can offer a helping hand. Converting from myBB 1.6.5 to SMF 2.0

Thank you in advance.

[Joker™]

"Wrong value type sent to the database. Date expected. (birthdate)" error.

Can you post the complete error over here, i.e filename etc.

[PsychoticHorticulture]

Thanks for the reply!

Here's a screenshot of the occurrence. I'm unclear on what you mean by the "complete error."

From what I understand by reading other threads, clearing the birthdates seems to navigate around the error, however I'm unclear on exactly what query I input, if that is indeed the case (I have no grasp on sql at all, terrible I know). I've tried the various other fixes offered in other threads I've found, to no avail.

Also this thread should probably be moved to the myBB subforum given that it's evolved in this fashion.

[Joker™]

Please try to read the fix provided here.

Edit - Topic moved .

[PsychoticHorticulture]

Please try to read the fix provided here.

Edit - Topic moved .

Already tried that, didn't solve the problem.

[Joker™]

Can you run this query in phpmyadmin and tell us the results obtained

Code Select Expand

SELECT birthday from [your_tables_prefix]users;

[PsychoticHorticulture]

Here they are

[Joker™]

First of all the birthdate seems to be default one. Personally I've never used Mybb, just making a guess about the default birthdate.

Moreover is your forum having any other date of birth other than "1-1-1970" mentioned in the above sql file.

[PsychoticHorticulture]

Ah yeah, sorry I thought it exported all the entries, instead it was just the first 30. Didn't double check. Full results attached.

I'm not sure how the 1-1-1970 date got added in, I think it got set to that when I imerged the databases in myBB.

[Joker™]

Well I installed Mybb 1.65 and converted it to SMF 2.0.2 without any errors. Give me some time I'll try to figure out the exact error .

[PsychoticHorticulture]

Thanks

In the meantime I used the fix found in this thread, which seemed to work for the birthdate problem, but then I got the following error:

Converting members... Unsuccessful!
This query:

    SELECT
    uid AS id_member, SUBSTRING(username, 1, 255) AS member_name,
    SUBSTRING(username, 1, 255) AS real_name, email AS email_address,
    SUBSTRING(password, 1, 64) AS passwd, SUBSTRING(salt, 1, AS password_salt,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS last_login, IF(usergroup = 4, 1, 0) AS id_group,
    regdate AS date_registered, SUBSTRING(website, 1, 255) AS website_url,
    SUBSTRING(website, 1, 255) AS website_title,
    SUBSTRING(icq, 1, 255) AS icq, SUBSTRING(aim, 1, 16) AS aim,
    SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn, 1, 255) AS msn,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hide_email,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS member_ip, SUBSTRING(regip, 1, 255) AS member_ip2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS total_time_logged_in
    LIMIT 0, 500;

Caused the error:

    Unknown column 'uid' in 'field list'

[Joker™]

Thanks

In the meantime I used the fix found in this thread, which seemed to work for the birthdate problem, but then I got the following error:

Converting members... Unsuccessful!
This query:

    SELECT
    uid AS id_member, SUBSTRING(username, 1, 255) AS member_name,
    SUBSTRING(username, 1, 255) AS real_name, email AS email_address,
    SUBSTRING(password, 1, 64) AS passwd, SUBSTRING(salt, 1, AS password_salt,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS last_login, IF(usergroup = 4, 1, 0) AS id_group,
    regdate AS date_registered, SUBSTRING(website, 1, 255) AS website_url,
    SUBSTRING(website, 1, 255) AS website_title,
    SUBSTRING(icq, 1, 255) AS icq, SUBSTRING(aim, 1, 16) AS aim,
    SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn, 1, 255) AS msn,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hide_email,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS member_ip, SUBSTRING(regip, 1, 255) AS member_ip2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS total_time_logged_in
    LIMIT 0, 500;

Caused the error:

    Unknown column 'uid' in 'field list'

Great. This is the best part of coding, you learn with every topic.

Can you make sure that "[your_tables_prefix]users" has the uid column intact?

Just a noobish question, you are using this converter, right?

[bfeist]

Hi all,
Sorry for waking up an old topic, but I've just posted a tool that will merge two SMF databases. Hopefully no more need for myBB and all this shenanigans.

Have a look.
http://www.simplemachines.org/community/index.php?topic=513684.msg3630822

Ben

[Joker™]

Hi all,
Sorry for waking up an old topic, but I've just posted a tool that will merge two SMF databases. Hopefully no more need for myBB and all this shenanigans.

Have a look.
http://www.simplemachines.org/community/index.php?topic=513684.msg3630822

Ben

Awesome work bfeist