Continual Error on Upgrade.....from YABB SE

[jamesamorris]

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tonym/public_html/smf/convert.php on line 811 Unsuccessful!
This query:
SELECT @@SQL_BIG_SELECTS, @@SQL_MAX_JOIN_SIZE;
Caused the error:

Unknown system variable 'SQL_BIG_SELECTS'

Any ideas guys this is annoying me now. I have them both setup and working in the same database....

Thanks


James

[ThorstenE]

This is a permission issue with your MySQL installation (the MySQL user isn't  allowed to change MAX_JOIN_SIZE or BIG_SELECTS)..

The only solution: convert your forum offline.. you can install a local webserver system (eg XAMPP), then convert your YaBB and move the converted forum back to your host.

[jamesamorris]

This seems a very long way around is there no way to disable anything to get it to work the conventional way ?

Thanks

James

[ThorstenE]

James, do you still require assistance with this issue? I don't have any other ideas to get rid of that error as it is a LIMIT in your MySQL configuration.