Advertisement:

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

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)

Offline vbgamer45

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

Offline vbgamer45

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


Offline vbgamer45

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

Offline vbgamer45

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

Offline vbgamer45

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

Offline vbgamer45

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

Offline vbgamer45

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



Offline vbgamer45

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