I am trying to convert a forum from PHPBB 3.0.12 to SMF. I have the PHPBB forum moved to my server and have SMF installed and working as well. User privileges granted for both databases. When I enter the path to both to start the conversion I get this error right off: Unknown system variable 'SQL_MAX_JOIN_SIZE'
I read on one topic to delete that out of the convert.php file, but when I do I still get errors starting with ranks. Any help please?
Are you on you own server/vps or shared hosting?
It is a mysql setting https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
I'm on a VPS server.
Then look into increasing that variable in your my.cnf file
I contacted my hosting company. They told me I am on a managed VPS account and that change can't be made unless I'm on an unmanaged VPS account. Right now that join size is set at 1,000,000. Thoughts / suggestions?
I just tried it again this morning and didn't get the max join size error but here is what I got:
Notice: Undefined index: convert_script in /home/*****/public_html/bb/convert.php on line 972
Warning: Invalid argument supplied for foreach() in /home/*****/public_html/bb/convert.php on line 975
Notice: Undefined index: convert_script in /home/*****/public_html/bb/convert.php on line 987
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/*****/public_html/bb/convert.php on line 2494
Notice: Undefined variable: result in /home/*****/public_html/bb/convert.php on line 2495
Notice: Undefined index: db_fetch_assoc in /home/*****/public_html/bb/convert.php on line 1386
Fatal error: Function name must be a string in /home/*****/public_html/bb/convert.php on line 1386
Anyone have any suggestions here? Any help is greatly appreciated.
Make sure you hosting account is at least on PHP version 5.4 or higher.
I am still having issues with this. I moved everything to another server where the max join size wasn't capped, it is a shared hosting plan, but since that was the error I was getting I figured I should be alright.
Set everything up on the new server to try the converter, and bam, same max join size error and it's set as high as it'll go. Any help?
Any thoughts on this? Running php 5.6 by the way.
Attach your convert.php
I think we can try stuff in this post here https://stackoverflow.com/questions/22630238/error-set-sql-big-selects-1-or-set-max-join-size
See Attached convert file.
Try this file
Same error: Unknown system variable 'SQL_MAX_JOIN_SIZE'
Lets try this one.
I didn't get an error this time, which is great, however it just sits on converting ranks.
I am at a loss here. Is there anyone I can pay to help convert his for me?