Customizing SMF > Modifications and Packages

geoIP (IP to Location)

<< < (13/15) > >>

cyberjunkie:
I have 3 errors

The Database is not installed
Last Update Status: The MaxMind download site did not respond

This was voor de country and city csv


The Database is not installed
Last Update Status: Error during the downloading of the zip file from MaxMind

This was for the Country only


The Database is not installed
Last Update Status: Unable to find unzipped files

And this one was for the manual install.

The csv file.s are in the directory  Sources/geoIP/

koop:
I just installed geoip, installed the full database option and then enabled the options.  I'm now getting the following error on my site and have lost all functionality. 

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

Any ideas?  I cannot find "Max_join_size" in my php.ini file. 

Arantor:
You won't find it in php.ini, because it's not a PHP option. It's an SQL configuration option in MySQL - and on shared hosting you're just not going to be able to change that.

I'd love to know what's on lines 576-586 of geoIP.php.

Leo2:
I have same MAX_JOIN_SIZE error after my hoster made some 'upgrade' in their database.

My forum didn't work until I removed older Geoip version ( I had to comment call to it in subs.php because admin pages didn't work either). After installing the newer version, the forum works, but shows same error in user profile.

Lines 568-586 are:


--- Code: --- if (strpos($ip,'.'))
$ip = geo_dot2long($ip);

$request = $smcFunc['db_query']('', '
SELECT ip.start, ip.end,
bl.city, bl.latitude, bl.longitude,
gc.cc, gc.cn as country,
gr.rn as region
FROM {db_prefix}geoip_ip as ip
LEFT JOIN {db_prefix}geoip_blocks AS bl ON (ip.locid = bl.locid)
LEFT JOIN {db_prefix}geoip_countries AS gc ON (gc.cc = bl.country)
LEFT JOIN {db_prefix}geoip_regions AS gr ON (gr.rc = bl.region && gr.cc = bl.country)
WHERE ip.end >= {int:ip}
ORDER BY ip.end ASC
LIMIT 1',
array(
'ip' => (int) $ip
)
);

--- End code ---

Joker™:

--- Quote from: Leo2 on October 22, 2012, 03:33:16 AM ---I have same MAX_JOIN_SIZE error after my hoster made some 'upgrade' in their database.

My forum didn't work until I removed older Geoip version ( I had to comment call to it in subs.php because admin pages didn't work either). After installing the newer version, the forum works, but shows same error in user profile.

--- End quote ---
A user has faced similar issue. Try reading out the topic.

Navigation

[0] Message Index

[#] Next page

[*] Previous page