Advertisement:

Author Topic: MyBB 1.8 Convertor  (Read 15693 times)

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,541
    • 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: 288
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: 288
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


Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,541
    • 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: 288
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 »

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,541
    • 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

Offline Gene Steinberg

  • Newbie
  • *
  • Posts: 6
Re: MyBB 1.8 Convertor
« Reply #47 on: May 29, 2020, 03:19:39 PM »
I am trying to convert a MyBB 1.8.22 forum to the current release SMF.

i'm using the proper converter.

But I keep getting errors when I try to run the converter (all is properly installed per directions).

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.8. 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: 1142

Both databases are properly installed in a Plesk Obsidian server, in the same domain. Each forum works properly so far as I can tell.

Suggestions?

Peace,
Gene

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,541
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #48 on: May 29, 2020, 03:22:24 PM »
The database username needs to have permission to move databases in order to do the conversion.
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 Gene Steinberg

  • Newbie
  • *
  • Posts: 6
Re: MyBB 1.8 Convertor
« Reply #49 on: May 29, 2020, 06:13:46 PM »
All permissions I can see for the two users involved are checked in Plesk.

What am I looking for — or should it be the same user?

Peace,
Gene

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,541
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: MyBB 1.8 Convertor
« Reply #50 on: May 29, 2020, 07:53:16 PM »
Same database user should be on both databases with permissions to access both.
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