Advertisement:

Author Topic: phpbb convert Unknown system variable 'SQL_MAX_JOIN_SIZE'  (Read 6527 times)

Offline DanesDK

  • Semi-Newbie
  • *
  • Posts: 17
phpbb convert Unknown system variable 'SQL_MAX_JOIN_SIZE'
« on: September 27, 2014, 04:38:27 AM »
what does this mean.?

Thanks

Offline DanesDK

  • Semi-Newbie
  • *
  • Posts: 17
Re: phpbb convert Unknown system variable 'SQL_MAX_JOIN_SIZE'
« Reply #1 on: September 27, 2014, 04:44:11 AM »
ok.. it dont work with mysql 5.6, my host says..

Hmmm.. I thought that the converter/smf worked with 5.6

Offline Gwenwyfar

  • Customizer
  • Full Member
  • *
  • Posts: 687
  • Gender: Female
    • Gwenwyfar on GitHub
Re: phpbb convert Unknown system variable 'SQL_MAX_JOIN_SIZE'
« Reply #2 on: October 04, 2014, 09:33:50 AM »
I have the exact same issue. I'm running the convertor from a locally installed smf through xampp. Is this a setting somewhere?

Edit: Yep, my version of mysql is the same, but isn't that the latest?

Edit2: Found the problem, just go to convert.php and remove both places where "SQL_MAX_JOIN_SIZE'" appears, with a comment around "attempt to make big selects". Like on this post. But there are two places to remove, not just one.