Advertisement:

Author Topic: MyBB 1.8 Convertor  (Read 10123 times)

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
MyBB 1.8 Convertor
« on: December 27, 2018, 07:01:48 PM »
MyBB 1.8 Convertor Beta

https://github.com/SimpleMachines/converters/tree/master/SMF2.0/MyBB/1.8

Requires both files to be copied to your new empty SMF install.
« Last Edit: January 01, 2019, 12:29:19 AM by GigaWatt »
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 587
Re: MyBB 1.8 Convertor
« Reply #1 on: December 28, 2018, 02:24:22 AM »
To 2.0.15 i guess?

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #2 on: December 28, 2018, 09:29:45 AM »
Yes
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline tinoest

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 246
Re: MyBB 1.8 Convertor
« Reply #3 on: December 28, 2018, 11:33:03 AM »
Convert.php needs modifications to work on php7 as it uses the built in php mysql_ not the smcFunc one.

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #4 on: December 28, 2018, 12:27:44 PM »
Many thanks vbgamer45 I'll try it these days and let you know  :)

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #5 on: December 28, 2018, 12:37:11 PM »
Convert.php needs modifications to work on php7 as it uses the built in php mysql_ not the smcFunc one.
It does. I think I made some changes.
I did run that convert.php on PHP 7.1 when I did my testing.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline tinoest

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 246
Re: MyBB 1.8 Convertor
« Reply #6 on: December 28, 2018, 01:45:52 PM »
Convert.php needs modifications to work on php7 as it uses the built in php mysql_ not the smcFunc one.
It does. I think I made some changes.
I did run that convert.php on PHP 7.1 when I did my testing.

Apologies I saw the one in convert_result, which you don't seem to be using now.

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #7 on: December 30, 2018, 05:26:06 AM »
I'm trying to convert mybb 1.8.19 with wamp but for now I have two problems:
1. SQL_MAX_JOIN_SIZE error fixed following this;
2. Field 'message_labels' doesn't have a default value!


There is a way to solve the 2 problem?

PS. is not for the 1.4 version as it is written right?

Thanks

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #8 on: December 30, 2018, 07:59:33 AM »
OK, I applied this to solve the second problem but now I have many errors and the conversion crashes.
I'm using PHP 7.1.22

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #9 on: December 30, 2018, 10:01:17 AM »
For the convertor grab the latest from https://github.com/SimpleMachines/converters/tree/master/SMF2.0/MyBB/1.8  that should fix all the issues in your first post.
I can't edit my posts unfortunately
Also what SMF version are you converting to?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #10 on: December 30, 2018, 10:53:34 AM »
Thanks vbgamer45  ;)
I downloaded the new version from github, but I always have the error "Converting members...Field 'message_labels' doesn't have a default value"  :-\
I'm using SMF 2.0.15 and MyBB 1.8.19


Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #11 on: December 30, 2018, 11:06:43 AM »
Change your smf_members table in phpmyadmin the column of "message_labels" to have a default value of "" an empty string
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #12 on: December 30, 2018, 11:12:31 AM »
message_labels seems already empty  :-\

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #13 on: December 30, 2018, 11:32:46 AM »
No check the database structure of the table make sure it allows null and or has a default value set.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #14 on: December 30, 2018, 11:45:51 AM »
Sorry but I do not know how to do, I solved with this mod.
Thanks for now, I'll let you know when the conversion has been completed.

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #15 on: December 30, 2018, 12:44:36 PM »
Conversion completed without errors  :laugh:

I noticed three problems after the conversion:
1. Wrong ip addresses, mybb has changed something in the latest versions

2. Quote links do not work

3. Many bbcodes are not converted, as align, but this is not important and can be changed from phpmyadmin

Many thanks for your work vbgamer45  :D

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #16 on: December 30, 2018, 12:52:18 PM »
K glad it mostly works
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #17 on: December 30, 2018, 02:34:35 PM »
Sorry, now I'm trying in the online forum and I have this error.


Something has probably changed with the latest versions of mybb...

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #18 on: December 30, 2018, 09:06:54 PM »
Try this file
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,104
  • Gender: Male
    • Macedonian electronics forum
Re: MyBB 1.8 Convertor
« Reply #19 on: December 30, 2018, 11:00:12 PM »
I can't edit my posts unfortunately

What would you like to edit :)?
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #20 on: December 30, 2018, 11:21:48 PM »
Like the first post with the two latest files on
https://github.com/SimpleMachines/converters/tree/master/SMF2.0/MyBB/1.8
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,104
  • Gender: Male
    • Macedonian electronics forum
Re: MyBB 1.8 Convertor
« Reply #21 on: December 31, 2018, 03:05:11 AM »
Done :).
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #22 on: December 31, 2018, 03:41:51 AM »
Try this file
https://github.com/SimpleMachines/converters/tree/master/SMF2.0/MyBB/1.8

Now I have many errors like these

and after a few minutes it stops with this


Can it be because I'm using UTF-8?

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #23 on: December 31, 2018, 09:02:09 AM »
No. Did it complete even with those errors?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #24 on: December 31, 2018, 10:07:28 AM »
No, it stops  :-\

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #25 on: December 31, 2018, 10:16:34 AM »
Try
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #26 on: December 31, 2018, 11:37:39 AM »
OK, now the conversion starts, but then hangs here


EDIT: However, it has completed the conversion by itself and the IP addresses are correct  :o

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #27 on: December 31, 2018, 11:58:14 AM »
There is a problem only with few empty IP but I think that it does not depend by the converter.


Forum has been converted with more than 100,000 messages!

You did a great job and now IP addresses are corrects  ;D

Many thanks vbgamer45  ;)

It would be perfect if it also convert quotes but I will try to find a solution.

MyBB
Code: [Select]
[quote='user' pid='45607' dateline='1546264032']
SMF
Code: [Select]
[quote author=user link=topic=?????.msg45607#msg45607 date=1546264032]
The problem is that MyBB doesn't use topic id

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #28 on: December 31, 2018, 12:07:38 PM »
Yeah ip's might be odd IPV6 issues forget about that. Glad you have it convert. Will think about the quote issue too.

I would also check your forum level permissions make sure they are setup correctly I don't believe those carry over.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,104
  • Gender: Male
    • Macedonian electronics forum
Re: MyBB 1.8 Convertor
« Reply #29 on: December 31, 2018, 08:42:47 PM »
@vbgamer45: Since this is probably going to be a WIP, would you like me to add the GitHub page in the first post of the topic?
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #30 on: December 31, 2018, 11:13:16 PM »
yes please
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,104
  • Gender: Male
    • Macedonian electronics forum
Re: MyBB 1.8 Convertor
« Reply #31 on: January 01, 2019, 12:29:54 AM »
I just left the link to the GitHub page, removed the files (attachments), is that OK :)?
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #32 on: January 02, 2019, 01:55:49 PM »
Hi, I'm here again to ask  ::)
I'm using the latest version of github and I noticed that there is a problem with some imported user...

username are empty but if I display the profile by entering the user number in the http path I see that he uses special characters like ®


I tried to do the conversion using UTF-8 but I always get this error and the conversion crashes.


I also could not solve with "quote" but since SMF 2.1 accepts links like this
Code: [Select]
[quote author=user link=msg=123 date=1546320594]after the update I should not have this problem anymore because I will change it from phpmyadmin.


Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #33 on: January 02, 2019, 04:45:28 PM »
All usernames or just some? If so do you have an example of one in mybb that works but not in SMF?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #34 on: January 02, 2019, 05:28:48 PM »
All usernames or just some?

Just some

If so do you have an example of one in mybb that works but not in SMF?

Sure:

Piè™
Slìì
madrì
Firefox®


Thanks

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #35 on: January 02, 2019, 09:35:21 PM »
Try this filename for the username fix
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #36 on: January 03, 2019, 02:55:49 AM »
Fixed, thanks  ;D

Offline Freevy

  • Newbie
  • *
  • Posts: 5
Re: MyBB 1.8 Convertor
« Reply #37 on: January 04, 2019, 02:59:35 AM »
Wow, finally, a converter for mybb 1.8 .    It's safe to use it now or i should wait for final release ? I love some SMF themes and i want to move from Mybb.

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #38 on: January 04, 2019, 03:19:42 AM »
It's safe to use it now or i should wait for final release ?

Yes vbgamer45 did a great job, missing only the conversion of the quote tag.
I noticed that with SMF server load has decreased a lot  ;D

Offline Freevy

  • Newbie
  • *
  • Posts: 5
Unknown system variable 'SQL_MAX_JOIN_SIZE'
« Reply #39 on: January 04, 2019, 11:36:40 AM »
Hey. First, i got this error

Code: [Select]
Unknown system variable 'SQL_MAX_JOIN_SIZE'
after this, i removed from convert.php two pieces of

Code: [Select]
$max_join_var_name = 'SQL_MAX_JOIN_SIZE';
now i get this error:

Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

Anyone knows the problem ? Thanks again.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #40 on: January 04, 2019, 11:39:58 AM »
Hmm haven't tested with MariaDB will have to take a look
Rename it to MAX_JOIN_SIZE instead of SQL_MAX_JOIN_SIZE
And try again.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Freevy

  • Newbie
  • *
  • Posts: 5
Re: MyBB 1.8 Convertor
« Reply #41 on: January 04, 2019, 11:45:34 AM »
Hmm haven't tested with MariaDB will have to take a look
Rename it to MAX_JOIN_SIZE instead of SQL_MAX_JOIN_SIZE
And try again.

This works. Thanks so much. Have a good day  :) :)

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #42 on: February 19, 2019, 01:34:03 PM »
Hi, I'm converting another forum and I have the error "MySQL has gone away" during topics conversion.
My host does not change the timeout, what can I do?

Thanks

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #43 on: February 20, 2019, 02:56:22 PM »
I have a problem with the conversion, both databases are UTF-8 and the conversion crashes with
Code: [Select]
Converting members...
Incorrect string value: '\xC3' for column 'real_name' at row 209

I'm using this version https://github.com/SimpleMachines/converters/tree/master/SMF2.0/MyBB/1.8


Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #44 on: February 20, 2019, 03:07:35 PM »
Hi, I'm converting another forum and I have the error "MySQL has gone away" during topics conversion.
My host does not change the timeout, what can I do?

Thanks

the mysql packet might be bigger than the limit if it stops right away
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Massl

  • Jr. Member
  • **
  • Posts: 256
Re: MyBB 1.8 Convertor
« Reply #45 on: February 21, 2019, 02:20:48 AM »
How can I limit mysql packet?

Code: [Select]
Converting members...
Incorrect string value: '\xC3' for column 'real_name' at row 209

I found the cause, one user with name "quìquòquàquòquì"  ::)
I have removed the accents and it works!

I have no words... he should be banned  ;D
« Last Edit: February 21, 2019, 03:15:32 AM by Massl »

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,505
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #46 on: February 21, 2019, 08:14:37 AM »
Glad you have it working!
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro