Advertisement:

Author Topic: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"  (Read 8281 times)

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
"Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« on: January 19, 2017, 10:37:31 AM »
 I see this error when i just click to start the conversion:

"Unknown system variable 'SQL_MAX_JOIN_SIZE'"

I try to convert a phpbb 3.011 forum to SMF.  The empty SMF intalled is the 2.011

domain.xx/foro5
domain.xx/SMF

do u know what can be the problem?. Thanks!


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,342
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
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 motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #2 on: January 19, 2017, 10:57:05 AM »
Thank you! . i remove this code. But know i get a empty screen when i execute convert.php
 ???

this file must be located on the /foro5 ( php path) or the /SMF ( SMF path) ?

well i tried on both and same result.  ::)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,342
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #3 on: January 19, 2017, 10:58:08 AM »
convert.php should be in the SMF path
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 motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #4 on: January 19, 2017, 11:01:15 AM »
Thanks.

im not sure if im removing correctly the code.. ???

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,342
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #5 on: January 19, 2017, 11:04:02 AM »
Attach it here.
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 motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #6 on: January 19, 2017, 11:07:28 AM »
This is with the code removed .

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #7 on: January 19, 2017, 11:08:44 AM »
This is without the code removed ( as the file come diretcly from the ZIP conversor files)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,342
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #8 on: January 19, 2017, 11:23:11 AM »
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 motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #9 on: January 19, 2017, 11:27:40 AM »
Converting!.

Thanks mate. Ill let you know how it works finally.

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #10 on: January 19, 2017, 11:36:04 AM »
The conversion seems to be  stopped at this point:

Converting...
Converting posts...
Duplicate entry '72155' for key 'PRIMARY'


 ???

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,342
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #11 on: January 19, 2017, 11:47:40 AM »
Does it have a line number?
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 motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #12 on: January 19, 2017, 11:56:57 AM »
I attached what i see


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,342
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #13 on: January 19, 2017, 12:05:48 PM »
hmm 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 motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #14 on: January 19, 2017, 12:43:00 PM »
Hi mate,
i tried to re-beging without any change , before you send me the last convert.php file .

Now is still converting the posts .

243.600 post fo 634.000 ( total) .

Ill let you know how it finish..fingers crossed.

Thanks so much

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #15 on: January 19, 2017, 05:43:12 PM »
After 3 hours converting the posts... it appears this message and stop it:

Converting...
Converting posts...
The database value you're trying to insert does not exist: modified_name


The converting stopped at this point on the URL:

URL:  /SMF/convert.php?step=1&substep=19&start=544800

Total post of the forum : 624.000


Screenshoot attached.

any help?  :-\



Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,342
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #16 on: January 19, 2017, 05:46:08 PM »
Keep it open on that page.
Then alter your SMF database try this query
Code: [Select]
alter table smf_boards add column modified_name varchar(255);
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 motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #17 on: January 19, 2017, 05:52:24 PM »
Thanks for your quick answer!.


ouch.. i dont know how to do this.
Is it on PHPmyadmin?

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #18 on: January 19, 2017, 05:56:15 PM »
My phpmyadmin is in spanish, sorry. Should it be here and "execute query" buttom ( on the right)


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,342
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #19 on: January 19, 2017, 06:02:44 PM »
Yeah try that
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