3.5.4 to 3.6.1 Error

[da_judge]

I keep getting this error when trying to upgrade....

Database error in vBulletin 3.5.5:

Invalid SQL:
UPDATE cronlog AS cronlog, cron AS cron SET
cronlog.varname = cron.varname
WHERE cronlog.cronid = cron.cronid;

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Monday, September 25th 2006 @ 09:36:15 PM
Script : http://www.*************/test/install/upgrade_360b1.php?step=4
Referrer :
IP Address : ***********
Username :
Classname : vb_database

What a pain... cant work it out.. any ideas...

Cheers

[da_judge]

Gonna try eva2000's method.. will keep you posted

[da_judge]

No get same error. any ideas

[Steve Machol]

What is the MAX_JOIN_SIZE setting in your my.cnf file?

[da_judge]

Our server wont allow us access to it... so i have no idea m8

[Steve Machol]

Ask your host.

[da_judge]

I have m8.. they very poor... dont allow things like that... even told us if we ask for anything like this again they will delete our account... lol thats very sad.. but their loss... we prob move servers... then i try again

Cheers