Text only | Text with Images

Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: jamesamorris on July 28, 2009, 12:00:05 PM

Title: Continual Error on Upgrade.....from YABB SE
Post by: jamesamorris on July 28, 2009, 12:00:05 PM
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
Title: Re: Continual Error on Upgrade.....from YABB SE
Post by: ThorstenE on July 28, 2009, 02:32:17 PM
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.

Title: Re: Continual Error on Upgrade.....from YABB SE
Post by: jamesamorris on July 29, 2009, 12:06:11 PM
This seems a very long way around is there no way to disable anything to get it to work the conventional way ?

Thanks

James
Title: Re: Continual Error on Upgrade.....from YABB SE
Post by: ThorstenE on August 22, 2009, 05:31:39 AM
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.
Text only | Text with Images