Advertisement:

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

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] MyBB 1.6
« Reply #140 on: April 24, 2014, 07:54:08 PM »
Are you using the converter from the downloads page?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline bobmail

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] MyBB 1.6
« Reply #141 on: April 25, 2014, 02:25:02 AM »
Hi

Thanks for your answer.

I'm using the third one (mybb to smf) - with the default .sql file it doesn't detect the database prefix and can't read any table, (error: Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.The error that was received from the Database was: SELECT command denied to user 'dev'@'localhost' for table 'users') - with the latest .sql file given in this thread everything goes fine until I have this error message. "The database value you're trying to insert does not exist: poster_email"...


If I change the .inc/config related line in the .sql file given on the download page, with "---~ from_prefix: "`{$config['database']['database']}`.{$config['database']['table_prefix']}"" I can start the script but then I have several mysql errors.





Offline bobmail

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] MyBB 1.6
« Reply #142 on: April 25, 2014, 02:44:08 AM »
Attachment is the .sql file that did work for me.

Hope it can help someone :)


Offline Bogus

  • Semi-Newbie
  • *
  • Posts: 96
  • Gender: Male
  • Ostfrisiescher Pinguin
    • Das etwas andere Linux Forum
Re: [SMF Converter] MyBB 1.6
« Reply #143 on: May 31, 2014, 04:17:40 AM »
Thanks bobmail for the sharing from your mysql convert file ;D

Offline De$T_RoYeR

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.6
« Reply #144 on: June 05, 2014, 08:33:38 AM »
i am getting this error

Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

please help me

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] MyBB 1.6
« Reply #145 on: June 05, 2014, 09:08:03 AM »
Which converter are you using? The one from the downloads page or the one from this topic? You should use the one from the downloads page.
Is your MyBB 1.6?

Also, check this tip here:
http://www.simplemachines.org/community/index.php?topic=404303.msg2877724#msg2877724
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline ariolander

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] MyBB 1.6
« Reply #146 on: June 20, 2014, 02:38:00 AM »
I am having issues with the birthday field mainly because my myBB version I am converting from had bad birthdays because the conversion from the other board software to myBB botched the birthday data. While some users have them, a lot of users have the field totally blank.

Is there any way to get the conversion script to skip the b-day field or run some sort of SQL query to insert a valid date if the field is blank?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] MyBB 1.6
« Reply #147 on: June 20, 2014, 03:37:49 PM »
Best way is really to just have no values inserted --> no one has birthdate.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline kj_

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.6
« Reply #148 on: July 01, 2014, 09:20:11 AM »
It worked perfect for me :).

kj

Offline Oldcrow

  • Jr. Member
  • **
  • Posts: 268
  • Gender: Male
  • "One foot in the grave!"
    • Seniors Worldwide
Re: [SMF Converter] MyBB 1.6
« Reply #149 on: November 30, 2014, 07:59:57 PM »
I have a mybb 1.6.15 I no longer wish to update or upgrade.

I wish to convert over to smf, I am familiar with smf forums to begin with..

What is the first step, use a test board first then go for the real thing..

I am going to need help on this, because I am not the brainiest guy around..

Ron

Offline Antes

  • Evil Black Cat
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,646
  • Gender: Male
  • Black cat rulz!
    • Antes on GitHub
    • merta on LinkedIn
    • @antesistan on Twitter
    • Lunarfall
Re: [SMF Converter] MyBB 1.6
« Reply #150 on: November 30, 2014, 08:02:03 PM »
Active Project(s): [ SimpleDesk ] # [ Lunarfall ] # [ CoreStore ]

Past Project(s): [ ezPortal ]

Offline Oldcrow

  • Jr. Member
  • **
  • Posts: 268
  • Gender: Male
  • "One foot in the grave!"
    • Seniors Worldwide
Re: [SMF Converter] MyBB 1.6
« Reply #151 on: November 30, 2014, 08:11:08 PM »
You can read: http://wiki.simplemachines.org/smf/Converting

Thanks Antes, I opened and bookmark it. I will read it later tonight..

Is there help here with this, paid or other that you know of..

Ron..

Offline Antes

  • Evil Black Cat
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,646
  • Gender: Male
  • Black cat rulz!
    • Antes on GitHub
    • merta on LinkedIn
    • @antesistan on Twitter
    • Lunarfall
Re: [SMF Converter] MyBB 1.6
« Reply #152 on: November 30, 2014, 08:14:48 PM »
You can read: http://wiki.simplemachines.org/smf/Converting

Thanks Antes, I opened and bookmark it. I will read it later tonight..

Is there help here with this, paid or other that you know of..

Ron..

Hello, I'm glad to help

You can post in http://www.simplemachines.org/community/index.php?board=50.0 if you want to post a paid job (Please mind to give as much as detail possible about the job).
Active Project(s): [ SimpleDesk ] # [ Lunarfall ] # [ CoreStore ]

Past Project(s): [ ezPortal ]

Offline Blodo

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.6
« Reply #153 on: February 24, 2015, 07:45:07 PM »
Hi guys,

While trying to convert a really big forum (1.5gb database size) I ran into issues during conversion of threads table. The particular select query in the sql file that was causing problems was this:

Code: [Select]
SELECT
t.tid AS id_topic, t.fid AS id_board, t.sticky AS is_sticky,
t.poll AS id_poll, t.views AS num_views, IFNULL(t.uid, 0) AS id_member_started,
IFNULL(ul.uid, 0) AS id_member_updated, t.replies AS num_replies,
CASE
WHEN (t.closed = '1') THEN 1
ELSE 0
END AS locked,
MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg
FROM {$from_prefix}threads AS t
INNER JOIN {$from_prefix}posts AS p
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)
WHERE p.tid = t.tid
GROUP BY t.tid
HAVING id_first_msg != 0
AND id_last_msg != 0;

Turns out the INNER JOIN in this absolutely chokes out on a big table to the point where it can't even return 1 row in a reasonable amount of time. I rewrote the select query for that particular conversion step to the following:

Code: [Select]
SELECT
    t.tid AS id_topic, t.fid AS id_board, t.sticky AS is_sticky,
    t.poll AS id_poll, t.views AS num_views, IFNULL(t.uid, 0) AS id_member_started,
    IFNULL(ul.uid, 0) AS id_member_updated, t.replies AS num_replies,
    IF(t.closed = '1', 1, 0) AS locked,
    (SELECT MIN(p.pid) FROM {$from_prefix}posts AS p WHERE p.tid = t.tid LIMIT 1) AS id_first_msg,
    (SELECT MAX(p.pid) FROM {$from_prefix}posts AS p WHERE p.tid = t.tid LIMIT 1) AS id_last_msg
FROM {$from_prefix}threads AS t
    LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)
HAVING id_first_msg != 0 AND id_last_msg != 0;

Time taken to complete this query is reduced by orders of magnitude due to MySQL optimiser now not ignoring the indexes. The BINARY statement on the ul.username made indexes not be used on the users table (which was a big problem), and the INNER JOIN with GROUP BY clause on the posts table ignored indexes as well (which was an even bigger problem). Hope it helps somebody.

Offline benny3041

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] MyBB 1.6
« Reply #154 on: December 20, 2015, 05:23:52 PM »
Hey,

is there an importer for MyBB 1.8 ?

greets

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] MyBB 1.6
« Reply #155 on: December 20, 2015, 07:20:22 PM »
Not a dedicated one no. But, as far as we know, the 1.6 converter works fine with minor tweaks. You should get an error like this:
Code: [Select]
Unknown column 'msn' in 'field list'You should just remove the mentioned field from the conversion and it should work for the remaining parts ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline benny3041

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] MyBB 1.6
« Reply #156 on: December 23, 2015, 01:31:32 AM »
Not a dedicated one no. But, as far as we know, the 1.6 converter works fine with minor tweaks. You should get an error like this:
Code: [Select]
Unknown column 'msn' in 'field list'You should just remove the mentioned field from the conversion and it should work for the remaining parts ;)

Where can i delet this ? :$

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] MyBB 1.6
« Reply #157 on: December 23, 2015, 06:10:01 AM »
In the .sql file (I'm sorry but I'm typing from my phone...)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline benny3041

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] MyBB 1.6
« Reply #158 on: December 23, 2015, 04:38:20 PM »
I cant find this in the .sql File o.O

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,063
Re: [SMF Converter] MyBB 1.6
« Reply #159 on: December 23, 2015, 06:16:40 PM »
you are using the files attached in the first post?

in the sql there is

SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn, 1, 255) AS msn,

remove the second part of that line.