SMF Support > MyBB

Merging databases through myBB

(1/3) > >>

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:

--- Quote from: 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: ---UPDATE smf_boards SET description = REPLACE(description, '\\', '') WHERE description LIKE "%\\\\%";
UPDATE smf_boards SET name = REPLACE(name, '\\', '') WHERE name LIKE "%\\\\%";
--- End code ---

--- End quote ---

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™:

--- Quote from: PsychoticHorticulture on January 03, 2012, 05:27:57 PM ---"Wrong value type sent to the database. Date expected. (birthdate)" error.

--- End quote ---

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.

Navigation

[0] Message Index

[#] Next page