Advertisement:

Author Topic: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14  (Read 2528 times)

Offline apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« on: June 26, 2017, 06:03:37 PM »
I am trying to convert a forum from PHPBB 3.0.12 to SMF.  I have the PHPBB forum moved to my server and have SMF installed and working as well.  User privileges granted for both databases.  When I enter the path to both to start the conversion I get this error right off: Unknown system variable 'SQL_MAX_JOIN_SIZE'

I read on one topic to delete that out of the convert.php file, but when I do I still get errors starting with ranks.  Any help please?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,349
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #1 on: June 26, 2017, 06:06:31 PM »
Are you on you own server/vps or shared hosting?

It is a mysql setting https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
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 apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #2 on: June 26, 2017, 06:13:22 PM »
I'm on a VPS server. 

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,349
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #3 on: June 26, 2017, 06:22:33 PM »
Then look into increasing that variable in your my.cnf 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 apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #4 on: June 27, 2017, 12:10:53 PM »
I contacted my hosting company.  They told me I am on a managed VPS account and that change can't be made unless I'm on an unmanaged VPS account.  Right now that join size is set at 1,000,000.  Thoughts / suggestions?

I just tried it again this morning and didn't get the max join size error but here is what I got:

Notice: Undefined index: convert_script in /home/*****/public_html/bb/convert.php on line 972

Warning: Invalid argument supplied for foreach() in /home/*****/public_html/bb/convert.php on line 975

Notice: Undefined index: convert_script in /home/*****/public_html/bb/convert.php on line 987
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/*****/public_html/bb/convert.php on line 2494

Notice: Undefined variable: result in /home/*****/public_html/bb/convert.php on line 2495

Notice: Undefined index: db_fetch_assoc in /home/*****/public_html/bb/convert.php on line 1386

Fatal error: Function name must be a string in /home/*****/public_html/bb/convert.php on line 1386

Offline apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #5 on: June 29, 2017, 06:03:26 PM »
Anyone have any suggestions here? Any help is greatly appreciated.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,349
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #6 on: June 29, 2017, 06:16:45 PM »
Make sure you hosting account is at least on PHP version 5.4 or higher.
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 apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #7 on: July 12, 2017, 01:27:43 PM »
I am still having issues with this.  I moved everything to another server where the max join size wasn't capped, it is a shared hosting plan, but since that was the error I was getting I figured I should be alright. 

Set everything up on the new server to try the converter, and bam, same max join size error and it's set as high as it'll go.  Any help?

Offline apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #8 on: July 18, 2017, 12:11:41 PM »
Any thoughts on this?  Running php 5.6 by the way. 

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,349
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #9 on: July 18, 2017, 12:14:26 PM »
Attach your convert.php

I think we can try stuff in this post here https://stackoverflow.com/questions/22630238/error-set-sql-big-selects-1-or-set-max-join-size
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 apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #10 on: July 18, 2017, 07:09:04 PM »
See Attached convert file.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,349
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #11 on: July 18, 2017, 07:53:58 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 apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #12 on: July 24, 2017, 11:05:11 AM »
Same error: Unknown system variable 'SQL_MAX_JOIN_SIZE'


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,349
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #13 on: July 24, 2017, 12:13:07 PM »
Lets try this one.
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 apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #14 on: July 25, 2017, 05:07:53 PM »
I didn't get an error this time, which is great, however it just sits on converting ranks.

Offline apexadllc

  • Semi-Newbie
  • *
  • Posts: 20
Re: Errors While Converting from PHPBB 3.0.12 to SMF 2.0.14
« Reply #15 on: August 03, 2017, 02:40:59 PM »
I am at a loss here.  Is there anyone I can pay to help convert his for me?