Advertisement:

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

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!

Offline vbgamer45

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

Offline vbgamer45

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