Advertisement:

Author Topic: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"  (Read 8461 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!


Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • 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.  ::)

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • 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.. ???

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • 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)

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • 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'


 ???

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • 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


Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • 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?  :-\



Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • 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)


Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • 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

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #20 on: January 19, 2017, 06:04:19 PM »
Ok, done.
What should i have to do? . The converter is in the same way(stopped)

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #21 on: January 19, 2017, 06:07:28 PM »
Refresh the page.
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

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #22 on: January 19, 2017, 06:08:17 PM »
I made a mistake run this query instead
alter table smf_messages add column modified_name varchar(255);
Then run
alter table smf_boards drop column modified_name;
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 #23 on: January 19, 2017, 06:10:15 PM »
So , now in this situation,  must i run this two queries?
Or just the last one?

Attached the SFM_boards situatio ( just now)

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #24 on: January 19, 2017, 06:19:37 PM »
Ok, i understood. I ran these two queries.


alter table smf_messages add column modified_name varchar(255);
Then run
alter table smf_boards drop column modified_name;

refresh the page , and get this message:


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


Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #25 on: January 19, 2017, 06:27:25 PM »
Run both then refresh 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 motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #26 on: January 19, 2017, 06:30:06 PM »
Done. refresh the page , and get this message:


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

Must i have to run the queries with all the tables selected or just only the smf_messages and smf_boards?
(i did it only selecting these tables)

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #27 on: January 19, 2017, 06:33:08 PM »
just those tables.
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 #28 on: January 19, 2017, 06:34:30 PM »
Ok. So, i did it well.get this message now on the converter :(

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #29 on: January 19, 2017, 06:37:37 PM »
could be the problem becouse i run a incorrect query at first?

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #30 on: January 19, 2017, 07:04:33 PM »
Any help?   :-\

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #31 on: January 19, 2017, 07:45:20 PM »
You had that issue before did you try the convert.php i posted before...
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 #32 on: January 19, 2017, 07:54:51 PM »
well, not the last one, becouse the conver started well as i mentioned.
how i proceed now?

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #33 on: January 19, 2017, 08:03:11 PM »
upload the convert.php that i changed and just refresh the page...
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 #34 on: January 19, 2017, 08:06:20 PM »
now this appears again:

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

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #35 on: January 19, 2017, 08:30:34 PM »
ThereĀ“s a "modified_name" colum on the SFM_messages table.

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #36 on: January 19, 2017, 08:35:57 PM »
Yeah that was a guess now i don't what else.
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 #37 on: January 19, 2017, 08:45:11 PM »
Ill restart from the begining qith your last convert.php file.
Ill let you know which is the first messega again after that, in a few hours. Thank you.

Offline motu828

  • Semi-Newbie
  • *
  • Posts: 67
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #38 on: January 20, 2017, 04:50:08 AM »
I  started from the begining. I have this error:


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



Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #39 on: January 20, 2017, 09:34:34 AM »
Not sure why that would occur i see that field in smf_messages and in your screenshot above.
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 #40 on: January 20, 2017, 05:45:19 PM »
must i unistall any mod or theme?
only have talkpad mod.  :(

Offline nbjohnson87

  • Newbie
  • *
  • Posts: 3
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #41 on: June 11, 2017, 11:10:32 PM »
Try this one

Need some help and don't know if this thread is being watched so here goes nothing...:)

Running a phpbb3 version 3.0.14 and trying to convert it to smf 2.0.14. I ran into the "SQL_MAX_JOIN_SIZE" issue as well. Tried the modified convert.php and it at least attempted to start converting but nothing happens. I looked in the error_log file and I see issues. None of which I know what to do to address. Looking for some help if I can get it. I have attached my error_log file

Thanks!

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #42 on: June 11, 2017, 11:14:22 PM »
I would say if you have access to your mysql my.cnf try to raise the limit there SQL_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 nbjohnson87

  • Newbie
  • *
  • Posts: 3
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #43 on: June 11, 2017, 11:31:34 PM »
total greenhorn when it comes to mysql....where do I find my.cnf?

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #44 on: June 11, 2017, 11:35:27 PM »
If you have your own linux serer or vps /etc/my.cnf on linux servers.   or windows it's in my.ini
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 nbjohnson87

  • Newbie
  • *
  • Posts: 3
Re: "Unknown system variable 'SQL_MAX_JOIN_SIZE'"
« Reply #45 on: June 11, 2017, 11:37:45 PM »
sorry....I am hosted on hostmontser.com. Don't have access to /etc/my.cnf. Any other ideas? Could I ask them to raise max? If they would what I need it raised to?