I've noticed a problem if you create a toplist using the Geo IP Database.
I you have a toplist in the wrapper template that shows listings determined by geo location, and then someone enters a location that doesn't exist in the database, for the brief moment the redirect page is shown, and error is displayed. See Below.
Quite few people are likely to see this error as many people ignore the search location suggestions.
This error will only occur if the toplist is in the wrapper and therefore executed during the redirect.
Error...
Error occurred at www.exampledomain.co.uk/clo...dition=and&whichtype=links on 2010-10-12 20:56:09. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/hello211/public_html/clone/databases/mysql.php on line 79. Last SQL error: Unknown column '' in 'field list'
Debug info:
Load time so far: 0.034 seconds.
Query 1: SET CHARACTER SET 'utf8', character_set_server = 'utf8', CHARACTER_SET_CLIENT=utf8, CHARACTER_SET_RESULTS=utf8, CHARACTER_SET_CONNECTION=utf8 Query 2: SELECT [huge field list omitted] FROM wsnlinksclone1_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (type='regular' OR type="sponsored" AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1286916969 AND alias=0 AND inalbum=0 ORDER BY distance ASC,type desc,rand() LIMIT 0,3 Load time so far: 0.583 seconds.
Further to this, if anyone at all comes on the site with an IP that produces something that isn't in the database, a big error will show at the top of the site.
Comments on Geo IP database toplists
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
I've noticed a problem if you create a toplist using the Geo IP Database.
I you have a toplist in the wrapper template that shows listings determined by geo location, and then someone enters a location that doesn't exist in the database, for the brief moment the redirect page is shown, and error is displayed. See Below.
Quite few people are likely to see this error as many people ignore the search location suggestions.
This error will only occur if the toplist is in the wrapper and therefore executed during the redirect.
Error...
Error occurred at www.exampledomain.co.uk/clo...dition=and&whichtype=links on 2010-10-12 20:56:09. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/hello211/public_html/clone/databases/mysql.php on line 79.
Last SQL error: Unknown column '' in 'field list'
Debug info:
Load time so far: 0.034 seconds.
Query 1: SET CHARACTER SET 'utf8', character_set_server = 'utf8', CHARACTER_SET_CLIENT=utf8, CHARACTER_SET_RESULTS=utf8, CHARACTER_SET_CONNECTION=utf8
Query 2: SELECT [huge field list omitted] FROM wsnlinksclone1_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (type='regular' OR type="sponsored" AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1286916969 AND alias=0 AND inalbum=0 ORDER BY distance ASC,type desc,rand() LIMIT 0,3
Load time so far: 0.583 seconds.
Unknown column '' in 'field list'
Step 1 of backtrace:
File: /home/hello211/public_html/clone/databases/mysql.php
Line: 79
Function: mysql_num_rows
Arguments:
Step 2 of backtrace:
File: /home/hello211/public_html/clone/classes/database.php
Line: 159
Function: numrows
Arguments:
Class: db
Step 3 of backtrace:
File: /home/hello211/public_html/clone/includes/commonfuncs.php
Line: 5415
Function: numrows
Arguments:
Class: database
Step 4 of backtrace:
File: /home/hello211/public_html/clone/end.php
Line: 544
Function: runtoplist
Arguments:
Step 5 of backtrace:
File: /home/hello211/public_html/clone/includes/searchlogic.php
Line: 17
Function: require
Arguments: /home/hello211/public_html/clone/end.php
Step 6 of backtrace:
File: /home/hello211/public_html/clone/search.php
Line: 26
Function: include
Arguments: /home/hello211/public_html/clone/includes/searchlogic.php
Forum Regular
Usergroup: Customer
Joined: Nov 27, 2006
Total Topics: 187
Total Comments: 465
Further to this, if anyone at all comes on the site with an IP that produces something that isn't in the database, a big error will show at the top of the site.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
These are fixed in beta 15.