MAX_JOIN_SIZE rows database error

[koop]

I couldn't find any documentation that was helpful when searching.  In general I understand the cause, but I'm not sure how to fix it.  I'm assuming it's just a value change in a line of code for the file listed.  Unfortunately I do not know where to find that file.  Any help would be very appreciated.  The error is below. 

Code Select Expand

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
File: /hermes/waloraweb082/b2083/moo.thebigtenhangoutcom/forum/Sources/geoIP.php
Line: 586

[Joker™]

Note - Make backup of file before editing it

Open the file : Sources/geoIP.php

Code (Find:) Select Expand

// make sure its an int an not in a 1.2.3.4 format
if (strpos($ip,'.'))
$ip = geo_dot2long($ip);

Code (Add After:) Select Expand

$smcFunc['db_query']('', 'SET @@SQL_BIG_SELECTS = 1',
array());

[koop]

Thanks so much!  You're a life saver.  I'm very new to SMF, but the community has been so wonderful. 

[Joker™]

Welcome to the crazy world of SMF