MyBB Community Forums

Is possible to do this with any method? i need convert my forum than i have over 500 visits a day and i wanna convert my old forum to mybb 1.6

I am in the same boat. This should be added in a few weeks.

(2012-01-12, 12:41 PM)Dylan M. Wrote: [ -> ]

(2012-01-12, 08:00 AM)flyalaska Wrote: [ -> ]Any news for IPB 3x. The merge downloads show upto 2.3?

A beta, with a few outstanding bugs, is in the svn trunk for IPB3 already. One for XenForo and one for vB3 are both coming to the svn trunk as soon as I finish this big contract I'm working on, which means ~2-3 weeks. Sooner if possible, but figure on that kinda timeline.

would be interested in this also with IPB hosting disallowing the use of some of it's plugins in there Hosted solutions.

Guys, to make your life easier just do this (until dylan gets an ipb3 merge file):

Convert - IPB ----> SMF 2 ----> MYBB

smf converter

Follow directions via smf site....remember to backup

thanks will give it a try and post how i got on.

I know it works, I did it myself and your welcome !

ok, i test this, and i post results

---

cannot convert, locked in 1st step

What error do you see, verbatim...

i get

Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt, 
m.last_visit AS last_login, 
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `ipbtest`.ipbmembers AS m
LEFT JOIN `ipbtest`.ipbpfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `ipbtest`.ipbprofile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'm.email_pm' in 'field list'

converting from IPB 3.2 i will wait and see what happens over the next frew days. i will not be beaten i just want to see what pans out.

(2012-01-14, 07:45 PM)hagz Wrote: [ -> ]i get

Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt, 
m.last_visit AS last_login, 
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `ipbtest`.ipbmembers AS m
LEFT JOIN `ipbtest`.ipbpfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `ipbtest`.ipbprofile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'm.email_pm' in 'field list'

converting from IPB 3.2 i will wait and see what happens over the next frew days. i will not be beaten i just want to see what pans out.

That is from IPB to SMF, and we cannot help you with it. You'll need to ask on the SMF support forums. Do not tell them you're going to merge from SMF to MyBB after, just ask them for help with this.